Re: Displaying users groups

[Thomas Bean]

** Hello Anthony, Here is one way to accomplish this.  You will need to base the menu upon a join of the User and Group forms.  Before setting this up the join form, you will need to make a slight modification to the Group form.  Add a character field (e.g., 'group_id_char') to store the string equivalent of the 'Group ID' integer field (ID 106).  Create an escalation (with a blank 'Run If' qualification) against the Group form that will populate the 'group_id_char' field on all records in the Group form with the value from the 'Group ID' field.  Disable or delete this escalation once it has run successfully.  Next, create a filter on the Group form that performs the same set fields operation.  Use the following 'Run If' qualification for the filter:   'TR.Group ID' !=  $NULL$   Now you are ready to create the join form.  This should be an outer join, with the 'Group' form as the primary form, and the 'User' form as the secondary form.  The join criteria should be specified in the qualification bar, similar to the following:   ( 'Group List' LIKE ( $group_id_char$ +  ";%" )) OR ( 'Group List' LIKE (( "%;"  + $group_id_char$) +  ";%" )) OR ( 'Group List' LIKE (( "% "  + $group_id_char$) +  ";%" ))   Make sure the join form includes the 'Group Name' field from the 'Group' form (field 105) and the 'Login Name' field from the 'User' form (field 101), along with any other desired fields.   Now you can create a search menu against the join form.  The search menu should use the 'Group Name' field as the Label/Value field, and should include the following qualification in order to retrieve a list of all groups for the current user:   'Login Name' = $USER$   If desired, you could also use a field id reference from the current form (e.g., $536870100$) containing a valid Remedy login name, instead of the $USER$ keyword.   Hope this helps,   --Thomas   ----- Original Message ----- From: Anthony Caressimo Newsgroups: gmane.comp.crm.arsystem.general Sent: Tuesday, April 18, 2006 06:36 Subject: Displaying users groups hi all, i am trying to figure out how i can get a user's groups to display into a menu or drop down field. I can get the specific user groups no problem, but they either come up as a string of all id's or names. Any way to seperate them out, so upon loading a user will be able to pull a drop down and see what groups they belong to? Thanks for you help. Anthony __20060125_______________________This posting was submitted with HTML in it___