We need to be able to query a column so that the user's input matches the be

nickh647 over 8 years ago

We need to be able to query a column so that the user's input matches the beginning of whole words in a column that start with the same value.

For example, a user would type the word "BEA" into a search field, and the results returned from that column would include ("BLACK BEAN", "BEAN BURRITO", "BEAR", etc.) so that it isn't searching on the entire string, but on the words split by a space. The "starts with" in the a!queryrule doesn't allow for that.

We also need to avoid the case where a user types "B" and something like "CARBON FILTER" is returned, since it contains the letter B. The query needs to match the beginning of the whole word.

Any ideas on how we could implement this?

Discussion posts and replies are publicly visible

0 corbinp505 over 8 years ago

Check out the a!queryEntity() function which gives you a little more flexibility than standard query rules.

I believe you could use an OR filter to combine your 'starts with' filter and an 'includes' filter with a prepended space ("BEA" -> " BEA"). It looks like that might satisfy your use case.

forum.appian.com/.../System_Functions.html
forum.appian.com/.../System_Functions.html

Example: forum.appian.com/.../Query_Recipes.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nickh647 over 8 years ago

Thanks! This way worked
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel