Querying with a Filter that checks substrings of integer

I'm not sure this is possible on a primitive integer DB column, since the string equivalent of an integer wouldn't be apparent prior to base conversion (since presumably the DB would store int valus as binary until display time). One workaround I can think of off the top of my head, which should only be minimal effort, is to create a view for the table in question containing the same column cast as some text type instead of numeric, and then you could do the normal "contains" query filter.

I think we cannot search the values if it is in integer value. For searching, you got to parse into text format and use appian predefined functions search it and again parse it back to integer and then you can query it. I don't think any straight forward way is there

@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.