AnsweredAssumed Answered

SQL - Query with multi value lookup

Question asked by MRPR on Oct 22, 2018
Latest reply on Oct 23, 2018 by MRPR

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.