Clarity

 View Only
  • 1.  SQL - Query with multi value lookup

    Posted Oct 22, 2018 05:16 PM

    Hi All

    There is a scenario where i need to update the status of a custom object based on 3 multi value lookup fields created under the same custom object. I have 3 multi select lookup(L1, L2, L3) and an indicator field that lists the 3 multi select lookup (values - L1, L2, L3). Not when L1 is selected in indicator field, I would have to make sure that only multi select L1 is selected and no other multi select lookup is selected. If other multi value lookup values are selected too, then I would have to change the status as cancelled. Is there a way to accomplish this in Clarity? 

     

    Please help. Thanks in advance.

     

    Monica



  • 2.  Re: SQL - Query with multi value lookup
    Best Answer

    Posted Oct 23, 2018 04:17 AM

    Try this technique ; CA PPM: An easy way to create parameterized lookups (its not really about parameterised lookups, but lookups displaying content dependant upon other selected lookups)

    I'd recommend working through the EXACT example in that thread (in a development environment) so you understand how it works before attempting it with your (more complex) use-case.



  • 3.  Re: SQL - Query with multi value lookup

    Posted Oct 23, 2018 12:03 PM

    Dave_3.0 Thank you so much for the help!