Search and Filter limitations

[Fabian_Weller]

We can enable "searchable" to use search and filter for that column.
But there are still some limitations.
Let's say we have 2 tables: Orders (Parent) and Products (Children). They are referenced in 2 ways: via Ref and via Enum Type Ref.

Orders

ID (Key)	Order (Label)	Name	Related Products (REF_ROWS)	Related Products (EnumList Type Ref)
Ord00001	First order	William	Pro00001 , Pro00002	Pro00001 , Pro00002

Products

ID (Key)	Order (Ref)	Order (Enum Type Ref)	Product (Label)
Pro00001	Ord00001	Ord00001	Apple
Pro00002	Ord00001	Ord00001	Banana

Search and Filter

	Example	Search (Ref)	Filter (Ref)	Search (Enum Type Ref)	Filter (Enum Type Ref)
In Products Table search for the Order's ID	Ord00001	✔️Working	✔️Working (search box)	✔️Working	✔️Working (search box)
In Products Table search for the Order's Label	First order	✔️Working	✔️Working (search box and dropdown)	❌Not working	✔️Working (search box and dropdown)
In Products Table search for the Order's Name	William	❌Not working	❌Not working	❌Not working	❌Not working
In Orders Table search for Product's ID	Pro00001	✔️Working	❌Not working	✔️Working	✔️Working (search box)
In Orders Table search for Product's Labels	Apple	❌Not working	❌Not working	❌Not working	✔️Working (search box and dropdown)

At the moment the only way I see to workaround the limitations is to add Virtual Columns that calculate the desired searchable values.

[1minManager]

I'd love to help with this.  But I'm struggling to understand what you mean by

• Search (Ref)
• Filter (Ref)
• Search (Enum Type Ref)
• Filter (Enum Type Ref

I can sort of see why

• In Products Table search for the Order's Label
• In Products Table search for the Order's Name

don't work.  You refering to data in the parent table and AFAIK the search only works on data in the table your searching

Ditto with

• In Orders Table search for Product's ID
• In Orders Table search for Product's Labels

You're looking for data which is actaully in the daughter table.  

So unless I'm missing something then yes your going to have to have a column in both tables that read the parent/daughter table to put the relevant info in this table.

My hunch as to why some of the searches are partially working is that these are able to read the Display info for a Ref column.

Simon@1minManager.com

[Steve]

Escalated.

[sak]

I'm surprised this issue hasn't been fixed.

[kvngo94]

Still hasn't been fixed.

[Fabian_Weller]

I don't know if this was ever noticed by the AppSheet team?

@lizlynch can you share any insights about it?

[lizlynch]

@Fabian_Weller - Apologies for the delay. I have reached out to the dev team. Will report back when I get more clarification. Thanks for the ping!

[kvngo94]

Hi lizlynch, 

Could you please give some information on this issue ? Thank you. 

For now I'm creating VC columns for searching the ENUM TYPE REF. 

Not very ideal, as for table view, I need to also have steps to hide these VC columns... not clean steps.

[kvngo94]

Please allow search the ENUM TYPE REF, by typing the LABEL

[Fabian_Weller]

CC @lizlynch