Querying with a Filter that checks substrings of integer

Question

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.

mikes0011 · Accepted Answer

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.

tejak2639 · Answer

Hi,I think in a!queryFilter if the field is integer we can use only some of the operators, And if it is string then we can take includes or start with operators which will be helpful for the solution.But you are taking the integer field. So, instead of using a!queryFilter take a rule to get all the data and use "like" function to search for data and get the values that are true from the output(wherecontains), and get the whole data by indexing. I don't know whether it is exact solution but this will work

Sign up

Login with SSO

Login to the community

Login with SSO