Clarity

Hi All,

Can any one please let me know the syntax to use multi valued attribute as a parameter in the lookup.

Thanks in Advance.

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 ?

https://communities.ca.com/message/12792918#comment-12792918

NJ

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).

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).

Hi Jaya - Did Dave's response answer your question? If so please mark it as Correct Answer. Thanks!