Hello,
I'm trying to filter my view using the facility_id but everytime i use the filter function, it doesnt work when i try to search for a facility id in the play screen. Here is the function i'm using:
Filter('[dbo].[Spectulative]',Value(TextSearchBox1.Text)=FACILITY_ID)
Am i supposed to be changing something elsewhere? Please help
Hi @oria,
What is your data source? Is it sql table?
Do you set FACILITY_ID int type or not?
I test as your formula expression and there is no issue here:
Filter('[dbo].[Spectulative]', Value(TextInput1.Text) = FACILITY_ID)
If that is not ok on your side you can create one new to test and change the formula to this to test:
Filter('[dbo].[Spectulative]', TextInput1.Text in FACILITY_ID)
I test as next:
Data Source(sql server):
App Test1:
Gallery.Items: Filter('[dbo].[Spectulative]', Value(TextInput1.Text) = FACILITY_ID)
Result:
App Test2:
Gallery.Items:Filter('[dbo].[Spectulative]', TextInput1.Text in FACILITY_ID)
Result test:
Hope this can be helpful.
Best Regards.
Yumia