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 "123" 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
AFAIK you'd need to create a View where you cast the column as a text value, then use the text querying capabilities from there. When filtering on pure numeric values, neither Appian nor the DB back-ends will make much sense over trying to do this.
Thank you. I think we can use this approach.