Multivalue user lookup

[Flor_Salgado]

Hi!!

Is there a way to do a multiselection user lookup?

Regards

[David Morton]

Can you explain your question a bit more ; like where you are trying to do this?

 

Because the simple answer is just "Yes".

[Flor_Salgado]

Hi David,

We have an attribute which allows you to select an specific user from a list. The thing is that it only allows you to select one user and we need to select two, that is why we need this attibute to be a multiselection one. We explore the available options, but this kind of attriubute is not like "Multi Valued Lookup - String" ones.

This attribute was created with the following Dynamic Query:

 

SELECT @SELECT:u.id:user_id@,

@SELECT:u.user_name:user_name@,

@SELECT:u.user_name:UNIQUE_CODE@,

@SELECT:r.id:resource_id@,

@SELECT:r.unique_name:unique_name@,

@SELECT:r.first_name:first_name@,

@SELECT:r.last_name:last_name@,

@SELECT:r.full_name:full_name@,

@SELECT:r.unique_name:resourceID@,

@SELECT:r.person_type:person_type_id@,

@SELECT:l.name:person_type@,

@SELECT:u.user_status_id:user_status_id@,

@SELECT:s.name:user_status@,

@SELECT:G.ID:group_id@,

@SELECT:v.GROUP_NAME:group_name@

FROM srm_resources r,

cmn_sec_users u,

CMN_SEC_USER_GROUPS G,

CMN_SEC_GROUPS_V V,

cmn_lookups_v l,

cmn_lookups_v s

WHERE u.id = r.user_id

AND @FILTER@

AND group_id='5001061'

AND r.person_type = l.id

AND l.language_code=@WHERE:PARAM:LANGUAGE@

AND l.lookup_type='SRM_RESOURCE_TYPE'

AND u.user_status_id = s.id

AND s.language_code= @WHERE:PARAM:LANGUAGE@

AND s.lookup_type='SEC_USER_STATUS'

AND U.ID = G.USER_ID

AND G.GROUP_ID = V.ID

AND V.LANGUAGE_CODE = 'EN'

@BROWSE-ONLY:

AND s.lookup_code IN ('ACTIVE','LOCK')

:BROWSE-ONLY@

AND @WHERE:SECURITY:RESOURCE:r.id@

 

Thanks!

[David Morton]

So you should just be able to select the "multi-select" option* in the portlet filter-field properties against the user_id attribute?

 

I'm assuming here that user_id is mapped in your query to a lookup, and that user_id is the attribute you have in your portlet's filter.

 

* - The option to select between single-select and multi-select will only appear against a field property (in the portlet's "List Filter Section" / "Fields" ) if the query attribute is associated with a lookup and is a simple returned value rather than a user-specified parameter (which your is)