Search Object and Conditional Expression

[#1]

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

[Miguel_Angel_Baeyens]

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.