Skip to Content
avatar image
Former Member

CLM: Filter prompts and Value list Values

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

F.prompt.PNG (14.1 kB)
F.prompt(2).PNG (8.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 18, 2016 at 11:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Vigneshwar.

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

      Thanks for helping,
      Heiko