AnsweredAssumed Answered

V13 :browse-only and multi-valued field

Question asked by ispa-consulting on Nov 13, 2012
Latest reply on Nov 26, 2012 by ispa-consulting
Hello,
I have an issue with a dynamic lookup which I want to use with a multi valued lookup field.
The dynamic lookup will display only the users who are not inactived :
SELECT @SELECT:r.user_id:user_id@

,@SELECT:r.full_name:full_name@

,@SELECT:r.unique_name:unique_name@

,@SELECT:r.last_name:last_name@

,@SELECT:r.first_name:first_name@
FROM srm_resources r, cmn_sec_users u
WHERE u.id = r.user_id
AND @FILTER@
@BROWSE-ONLY:

AND u.user_status_id IN (select id from cmn_lookups where lookup_type='SEC_USER_STATUS' AND lookup_code IN ('ACTIVE','LOCK'))

:BROWSE-ONLY@

I create a multi valued lookup field in the resource object and associate my field with the lookup.
I go on a resource R1, and I select a resource R2 for my field and I save: everything works fine (I can select only the active and lock users)
Now, I inactive the resource R2.
When I go to the resource R1, my field do not display the resource R2 !!

I thought that BROWSE-ONLY was only for the selection and didn't impact the previous selection.

Where is my mistake ?

Thks a lot for your help

Regards

Outcomes