Can any one please let me know the syntax to use multi valued attribute as a parameter in the lookup.
Thanks in Advance.
SQL for equality of multiple values is "IN" not "="
To be clear, I am suggesting that the parameter is still a single value (the object id), the SQL in the lookup is where you would use the "IN" (when referring to values in the ODF_MULTI_VALUED_LOOKUPS table).
Perhaps use the object id as the parameter and use that in your NSQL to read the multi-valued attributes from the database table (ODF_MULTI_VALUED_LOOKUPS)
But I may get more than one value from the multi valued table and the '=' will not work when equating to the respective field.
Same as this ?
navzjoshi00 wrote: Same as this ? https://communities.ca.com/message/12792918#comment-12792918 NJ
No - that other discussion is using multi-valued lookups in portlets, this discussion is about parametrised lookups I think (i.e. on an object).
Hi Jaya - Did Dave's response answer your question? If so please mark it as Correct Answer. Thanks!
Retrieving data ...