Thanks, Thomas!
This article is very helpful.
Dwayne
---- Original message ----
>Date: Fri, 21 Apr 2006 10:34:19 -0500
>From: Thomas Bean <[EMAIL PROTECTED]>
>Subject: Re: Creating a menu on based on user’s permissions
SOLVED
>To: arslist@ARSLIST.ORG
>
> **
> Hi Dwayne,
> If you only want to see users belonging to the group
> with group ID 1000, this qualification would be more
> effective:
>
> ('Group List' LIKE "1000;%") OR ('Group List' LIKE
> "%;1000;%") OR ('Group List' LIKE "% 1000;%")
>
> I have attached an old "how-to" document from Remedy
> (circa 1998 -- ARS 3.x) that explains why this is
> the most consistent way to search the 'Group List'
> field on the User form. It is still valid today.
>
> As for basing the selection on a local variable, I
> provided a workable example of that in my last
> post. Here it is again:
>
> ('Group List' LIKE $536870100$ + ";%") OR ('Group
> List' LIKE "%;" + $536870100$ + ";%") OR ('Group
> List' LIKE "% " + $536870100$ + ";%")
>
> Search menus are not tied to a specific form, so you
> cannot use field name references like:
>
> 'Group List' LIKE "%" + $number$ + ";%"
>
> This will not work. Instead of using the field name
> reference ($number$), you must reference the field
> ID of the desired field, enclosed in dollar signs
> (e.g., $536870100$).
>
> --Thomas
>
>
> ----- Original Message -----
> From: Dwayne Martin
> Newsgroups: gmane.comp.crm.arsystem.general
> Sent: Friday, April 21, 2006 06:50
> Subject: Re: Creating a menu on based on user’s
> permissions SOLVED
> 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: arslist@ARSLIST.ORG
> >
> > **
> > 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
>
> __20060125_______________________This posting was
> submitted with HTML in it___
>________________
>group_list_query.pdf (21k bytes)
Dwayne Martin
Computing Support
James Madison University
