Filter list no working

Hi team, i´m using this template to do a Multi-Search, but the list of reference not working, i´m receiving the Map view

the template is: https://www.appsheet.com/Template/AppDef?appName=Multi-SearchDemo-675786#Data.Columns

Result:

This is my Formula:
FILTER(“PROJETOS”, **
** AND(

** OR( ISBLANK([_THISROW].[PROJETO]) , CONTAINS([PROJETO] ,[_THISROW].[PROJETO]) ),**
** OR( ISBLANK([_THISROW].[STATUS]) , CONTAINS([STATUS] ,[_THISROW].[STATUS]) )**
** )**
)

My result in map view

Who can help me?

Try with removing [_THISROW] de-ref from your column names

1 Like

@Alan_Martins
Also you can try with this

FILTER(
    "PROJETOS",
	AND(
		OR(
			ISBLANK([PROJETO]),
			CONTAINS([_THISROW].[PROJETO],[PROJETO])
		),
		OR(
			ISBLANK([STATUS]),
			CONTAINS([_THISROW].[STATUS],[STATUS])
		)
    )
)
2 Likes

UPDATE!

The results changed but no in list yet


I used this formula : FILTER(“PROJETOS”,
AND(
OR( ISBLANK([_THISROW].[PROJETO]) , CONTAINS([PROJETO] ,[_THISROW].[PROJETO]) ),
OR( ISBLANK([_THISROW].[STATUS]) , CONTAINS([STATUS] ,[_THISROW].[STATUS]) )
)
)

My reference is this results view in list

How can i change the results view to list?

1 Like

What do you mean by this? Please elaborate.

1 Like

Hi Steve,

I need to see the “results” in list, just it.

Still not entirely clear what you mean by “results”. The table appears to be “results” to me. But if you just want a flat list of the individual codes, try changing the column type from List to EnumList.

1 Like

Hi Steve, i changed to Enumlist type but not work.

PS:
to be clearer or what I need is for the view to be presented as a table as in the example and not as a list

Like the left (green) exemplo:
Staus / Date / Name

1 Like

Oh, I see the problem.

First, revert the EnumList back to List.

Then, create a new view of type table in the ref position for the Projectos table or slice. That view will govern the display of the results.

3 Likes

Hi Steve!! Working perfect!!

Solution: I created a new view in the table formate

Thanks!

1 Like

Hi team,

I´m Trying to create a second view but i didn´t receive the same list results

Could you help me?