Thanks, Thomas, first of all for your info on the ARSList archives. I tried your menu suggestion, but it didn't bring in any info.
Fortunately I am hard-coding for a particular work group, so I tried basing it on the Group ID, ie: 'Group List' LIKE "%1000%". That brot in more than were supposed to be there, but that turned out to be because we also have a Group ID of 10000. The deciphered group list uses semi-colins to separate entries so I tried: 'Group List' LIKE "%1000;%" and that works. I don't know how you would base your selection on a local variable, but something like: 'Group List' LIKE "%" + $number$ + ";%" should work. Thanks again, Dwayne Martin ---- Original message ---- >Date: Thu, 20 Apr 2006 17:37:55 -0500 >From: Thomas Bean <[EMAIL PROTECTED]> >Subject: Re: Creating a menu on based on user’s permissions >To: [email protected] > > ** > Hi Dwayne, > The URL for the ARSList (www.arslist.org) was > somehow corrupted recently, it is missing a > character in the re-direct URL (missing the letter > "s" in "archives"): > > Current redirect URL: > http://listserv.rbugs.com/archive/arslist.html > > Correct redirect URL: > http://listserv.rbugs.com/archives/arslist.html > > Until this is corrected, the easiest way to get to > the main ARSList archives is to either bookmark the > above URL or go to www.wwrug.org and follow the link > for www.ARSlist.org. > > Your question is very similar to one that was posted > a few days ago by someone who needed to present a > menu showing all groups for a given user. You can > find my response to that thread under the subject > "Displaying users groups" in the main ARSList > archive or directly from either of these alternative > external ARSList archive sites: > > Gmane: > http://article.gmane.org/gmane.comp.crm.arsystem.general/25070 > The Mail Archive: > http://www.mail-archive.com/arslist%40arslist.org/msg00044.html > > What you are wanting to accomplish isn't quite as > complicated, since you want to show all users for a > given group, not all groups for a given user. You > can accomplish this by simply creating a search menu > against the User form, with these properties: > > Label field(s): Full Name, Login Name, or Full Name > and Login Name > Value field: Full Name or Login Name > > Qualification (Dynamic): > ('Group List' LIKE $536870100$ + ";%") OR ('Group > List' LIKE "%;" + $536870100$ + ";%") OR ('Group > List' LIKE "% " + $536870100$ + ";%") > > Qualification (Static, if group ID does not change > -- Group ID is "1" in this example): > ('Group List' LIKE "1;%") OR ('Group List' LIKE > "%;1;%") OR ('Group List' LIKE "% 1;%") > > If you are using a dynamic qualification, the field > reference in the qualification line ($536870100$ in > the above example) needs to reference a character > field from the current form, containing the Group ID > value from the Group form for the group you wish to > display. > > HTH, > > Thomas > > > ----- Original Message ----- > From: Dwayne Martin > Newsgroups: gmane.comp.crm.arsystem.general > Sent: Thursday, April 20, 2006 15:50 > Subject: Creating a menu on based on user’s > permissions > Hi Everyone! > > How can I create a menu that will select users > from the User > form who belong to a particular permission group? > > Excuse me if this question has already been asked, > but the > ARSList archive web page seems to be unavailable > just now. > > (ARS 6.3, HPUX-11 server, Oracle 9.2 db) > > Dwayne Martin > Computing Support > James Madison University > > __20060125_______________________This posting was > submitted with HTML in it___ Dwayne Martin Computing Support James Madison University
