Hi All,
I have a use case where we have to search for values in numerous constants if it matches a specific email domain. Just applying the search box value isnt productive as it doesnt provide the results with actual constant values, also gives descriptions which is not useful in my case.
Discussion posts and replies are publicly visible
Hi,
Can you please explain more like add ss or something. Please answer the questions for better understanding.
Why data is there in appian constant? Is it like one constant holds one data ?
Searchbox is there in grid?
Is it a synced record or only tables?
The design search box won’t work. It only matches names/descriptions, never the values inside constants.
My Suggestion for future proof solution update all constants description. This would be faster and easiest.
Search in Designer works on name and description of a constant. So best practice is to have values mentioned in the constant's description for better design experience. It helps in rules also to see the value in description window, without opening the constant object.
Could you make an expression rule like below that builds up array of keys and values with x number of constants:
a!localVariables(
local!allEmails: flatten({ local!const1, local!const2, local!const3 }),
local!dictArray: a!forEach( items: local!allEmails, expression: a!map( key: "Email_" & fv!index, value: fv!item ) ),
keys: local!dictArray.key,
values: local!dictArray.value
)
And add a foreach to check fv!item for: any(fn!contains(local!dictArray, "mydomain.com"))