**
Dale,
We already are on ARS version 4.5.2 (1142)...Unless there is another patch
out there that I am not aware of. It was reading through the same knowledge
base entry and others that made me believe Field 112 supported multiple
groups on ARS 4.5.2.
If anyone has an idea what I need to do, it would be greatly appreciated :)
Thanks,
Robert Tripp
Programmer Analyst
GCI
-----Original Message-----
Date: Fri, 20 Sep 2002 15:10:00 -0400
From: "Dale Jones (DCS)"
Subject: Re: Multiple Groups for Field 112 with ARS 4.5.2
**
Robert,
If I recall correctly, multiple groups in field id 112 is only available in
4.5.2 Patch ?? and above.
Here is a Remedy KB 6873
Field 112 (Group Assignee) was enhanced to support multiple groups. In order
to make the search efficient, we had to come up with a syntax that would
allow a definitive match for a specific group that would not conflict with
any other group.
So, we needed to have the ability to look for group 10 but have it not match
101 or 110. The syntax of the group list "id;id;id;" left us with a problem.
There was not a way to perform the search cleanly.
Our solution was to add a lead semicolon so that the format of field 112 is
";id;id;id;" This means to look for group 10, we can search for "%;10;%" and
find only group 10 and not any other group even if the other group includes
a 10.
The upgrade to 4.5.2 included this conversion of field 112. The upgrade to
5.0 will convert any existing data as well if you are not already on 4.5.2.
Now, there was a problem with the client in 4.5.2 that caused a specific
type of search on field 112 using QBE to fail. To allow compatibility, we
actually provided a patch to the server that accepted the erroneous syntax
from the client and did the right thing and we have fixed the client for the
5.0 release so it does the right thing. So, the server will accept the bad
syntax of the 4.5 clients and the correct syntax of 5.0 clients when
searching field 112 using QBE.
So, the reason for the lead ";" in field 112 is to provide for an efficient
and definitive search ability that allows efficient support for the presence
of multiple groups for row level security.
Dale Jones
Director of Remedy Consulting
ARFOCUS/DCS
Raleigh, North Carolina
dale@dcsseattle.com
www.arfocus.com
www.dcsseattle.com
Mobile Phone 919-523-6034
Raleigh Office 919-866-1781
Head Office 1-800-345-1275
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.QMXS.COM]On Behalf Of Robert Tripp
Sent: Friday, September 20, 2002 1:27 PM
To: ARSLIST@LISTSERV.QMXS.COM
Subject: Multiple Groups for Field 112 with ARS 4.5.2
**
Hello all,
I was wondering if someone had information on how to get Field 112 (Group
Assignee) to accept more than one group on ARS 4.5.2.
I searched through my archive of list news, and found some information, but
it is still not working.
Edit the ar.conf file, and add the following line to the file:
Multiple-Assign-Groups: T
I restarted the ARS system to make sure the config file would be read.
I then tried entering groups using the little drop down, but it would only
let you have one group in the field. I then tried manually entering groups
by just their names.
Group1 Group2
Group1;Group2
;Group1;Group2;
Then also just the group numbers:
10 11
;10;11;
10;11
We are currendly on version 4.05.02 Patch 1053 for the user tool, and Server
version 4.05.02 patch 1142 (Solaris).
Does anyone have any insight? :)
Thanks,
Robert Tripp
Programmer Analyst
GCI
Previous Topic
Index