Querying with a Filter that checks substrings of integer

alexandera

A Score Level 2

over 7 years ago

How could I query a database using a!queryFilter where the field it checks is an integer and would check if the search value is included in the whole integer?
e.g. If I searched "678" and one of the record items had an Id that is 123456789, I would like that item to show up in the resulting list.

Discussion posts and replies are publicly visible

Parents

0 vijayy700 over 7 years ago

@alexandera - you may also try this if it is feasible for you, add one more column for the value ID as a text/string (e.g. stringID) each time when ID is populated this one will also, and then you can apply "includes" operator on stringID column in your query rule, this will change the schema of your table but one time solution.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 vijayy700 over 7 years ago

@alexandera - you may also try this if it is feasible for you, add one more column for the value ID as a text/string (e.g. stringID) each time when ID is populated this one will also, and then you can apply "includes" operator on stringID column in your query rule, this will change the schema of your table but one time solution.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data