cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oria
Level: Powered On

search numeric field

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

1 REPLY 1
Community Support Team
Community Support Team

Re: search numeric field

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):

20190213FACILITYIDDATASOURCE1.png

20190213FACILITYDATASOURCE2.png

App Test1:

Gallery.Items: Filter('[dbo].[Spectulative]', Value(TextInput1.Text) = FACILITY_ID)

20190213FACILITYAPPTEST1.jpg

Result:

20190213resulttest1.gif

App Test2:

Gallery.Items:Filter('[dbo].[Spectulative]', TextInput1.Text in FACILITY_ID)

20190213FACILITYAPPTEST2.jpg

Result test:

20190213resulttest2.gif

Hope this can be helpful.

Best Regards.

Yumia