Delegable Data Source - SQL - In Operator Service Limitation

[Delid4ve]

So according to the PowerApps knowledge base the 'in' operator is delegable with SQL as a data source. So why doesn't this work:
In a gallery (search box text as number type)
Filter('fgaslogs',searchbox.text in JobNo)

It returns incomplete results and the 'in' operator is underlined in blue stating service limitation - highlighted operation is not supported by column 'JobNo'

JobNo data type in sql is int

[hpkeong]

Hi

It is sometimes good to have trial and error because the tutorial reference may miss out something.

Why not try on

- = ?

TQ

[Delid4ve]

Sorry for my naivety but I don't understand what you are saying: 'why not try on - = ?'

[hpkeong]

Hi @Delid4ve

Apolgize, I mean try using "=".

TQ