Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Hope someone can assist me
I would like to allow users to search for a value in a field using the Search Object.
They should however only see values based on a certain condition
I tried to use the following formula in the List of Fields expression text box in the Search Box properties, but this did not work
=If(PD_PatModule_ModuleName = 'Casebook note', PD_CBMKeyword_TermValue)
Any ideas how I can get this right in the search object (without needing to use a macro)
Thanks a mil
Hello,
What I'd do is to create that "display field" in the script, so the filed used in the search object will only have the values for your condition, so in your load script, something like the following
Table:LOAD // Your fields here If(PD_PatModule_ModuleName = 'Casebook note', PD_CBMKeyword_TermValue) AS SEARCH_OBJECT_DISPLAYFROM Source
Then use the search object with this field.
Hope that helps.