Clarity

  • 1.  Multivalue user lookup

    Posted 07-10-2015 10:50 AM

    Hi!!

    Is there a way to do a multiselection user lookup?

    Regards



  • 2.  Re: Multivalue user lookup

    Posted 07-10-2015 11:38 AM

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

     

    Because the simple answer is just "Yes".



  • 3.  Re: Multivalue user lookup

    Posted 07-10-2015 12:25 PM

    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!



  • 4.  Re: Multivalue user lookup

    Posted 07-10-2015 01:03 PM

    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)