CLM: Filter prompts and Value list Values

[Private_Member_113126]

Hello experts,

I'm not very familiar with SQL and need some help to create specific operators. I took the table FCI_CONGEN_DOC and I want to create a filter prompt which contains the operators "Equals" and "Not Equals" instead of entering the value in a free text field but if I choose the defined values from the "Value List Types" I got an error message.

I choose this settings for my filter prompt:

After creating this I will get this error by using the filter:

Maybe I have to create a query group with object reference instead. Any ideas how I can realize this issue?

Best regards,

Heiko

[Former Member · Accepted solution]

Hello Heiko,

Hope you have written proper syntax for filter in query. Please cross check.

<%AND_OP("(T1.CURR_CONFIG_PHASE_OBJECT_ID)",<%?(T1.CURR_CONFIG_PHASE_OBJECT_NAME)%>)%>.

Regards,

Vignesh

[Private_Member_113126 · Accepted solution]

Hello Vigneshwar.

I find out on my own way. You are right it was a mistake in my syntax.

Thanks for helping,
Heiko