| **
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 -----
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: [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
__20060125_______________________This posting was submitted with HTML in it___
|
group_list_query.pdf
