Strange. The 'Run If' qualification in an active link would technically not
be issuing a search to the database -- it is simply searching the values
already displayed in the client. That may be why your qualification worked
using group names instead of Group IDs. What happens if you change the 'Run
If' qualification in the active link to search on the Group IDs instead of
the group names? If it works using the Group IDs, I would recommend going
that route. The qualification will be a lot lengthier, but I think this
would be a more consistent solution between ARS versions.
--Thomas
----- Original Message -----
From: "McManus Michael A SSgt HQ 754 ELSG/DOMH"
<[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: <[email protected]>
Sent: Thursday, June 19, 2008 7:23 AM
Subject: Re: LIKE qualifications in 7.0
Very bizarre. If I run the query in the advanced search bar in the WUT, I
get no results. However, I changed the Run If qualification on one of our
dev servers to the following:
('Group_List' LIKE "%System%") OR ('Group_List' LIKE "%Admin%")
It's a 7.0.01 server and I'm using a 7.0.01 WUT. For some reason, it works.
I logged it, and it passes the qualification.
Just to make sure I'm not out of my mind, I changed it back to:
( 'Group_List' LIKE (( "%" + "System" ) + "%" )) OR ( 'Group_List' LIKE
(( "%" + "Admin" ) + "%" ))
And I received the error message again. It fails the qualification with the
latter query, but it passes with the former query. And to boot, neither
query will return a set of results in the advanced search bar.
Michael A. McManus, SSgt, USAF
Remedy Developer
HQ 754 ELSG/DOMH
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Bean
Sent: Wednesday, June 18, 2008 6:08 PM
To: [email protected]
Subject: Re: LIKE qualifications in 7.0
**
Michael,
I don't think this has anything to do with the way LIKE qualifications are
handled between version 5.1.2 and 7.0.1.
Even if you change "%" + "System" + "%" to "%System%", the issue is most
likely related to the fact that the 'Group List' field does not actually
store explicit group names -- it actually stores a semicolon-delimited list
of Group IDs.
I tried a similar search on my User form, using the Advanced Search bar with
a LIKE qualification:
'Group List' LIKE "%Administrator%"
This returned NO results. However, the following query will return all
Users in the "Administrator" group (group ID 1).
'Group List' LIKE "1;%" OR 'Group List' LIKE "% 1;%" OR 'Group List'
LIKE "%;1;"
AFAIK, this has always been the proper method to search the 'Group List'
field (see attached document titled "How To Query On The Group List Field",
circa ARS 3.x). I'm pretty sure this is still valid.
Now, I am curious why this seems to have worked differently in ARS 5.1...
Perhaps this version allowed searches on the 'Group List' field with
explicit group names, or maybe it was only possible in the "Run If"
statement on an Active Link???
--Thomas
----- Original Message -----
From: Grooms, Frederick W <mailto:[EMAIL PROTECTED]>
Newsgroups: gmane.comp.crm.arsystem.general
To: [email protected]
Sent: Wednesday, June 18, 2008 3:59 PM
Subject: Re: LIKE qualifications in 7.0
**
What happens if you run your qualification in the Advanced Query bar
on your v7 User tool. You should get a list of users.
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of McManus Michael A SSgt HQ 754
ELSG/DOMH
Sent: Wednesday, June 18, 2008 2:02 PM
To: [email protected]
Subject: LIKE qualifications in 7.0
We're in the process of upgrading our AR System Server and Clients
from version 5.1.2 to 7.0.01 and I've run into a bit of a problem. I was
asked to upgrade my User and Admin tools to 7.0.01 on my PC for testing
purposes, and to draft an implementation plan. Our server is still 5.1.2
but I was under the impression that the WUT is backwards compatible and I
generally do very little day-to-day work in the WUT anyway.
Anyhow, I upgraded with no problems and was able to login with no
problems. I did a cursory examination of some workflow and everything
seemed okay. This morning, I got a request to change the Group of a user.
I went to the USER form, made the required changes, and clicked a button to
Add them as a System POC and received an error:
"Before attempting to add a System POC, their Group List must be set
to System POC or System POC Manager. (ARERR 75001)
The preceding message occurred during the execution of active link
USER:Add A New POC -- action 1. (ARNOTE 1101)"
The first line is the Message action in the Else action of the above
Active Link. The problem is, I did in fact change the Group List of the
user to System POC. I went to the Admin tool and checked the Run If
qualification for that Active Link:
( 'Group_List' LIKE (( "%" + "System" ) + "%" )) OR (
'Group_List' LIKE (( "%" + "Admin" ) + "%" ))
Just to make sure I hadn't screwed up somewhere along the line, I
had one of my coworkers attempt the change on his 5.1.2 WUT and it worked
perfectly. To make sure it wasn't a backwards compatibility problem, I
tested the workflow on our 7.0.01 dev server and received the same error.
I looked through the Release Notes as well as the "What's new in
7.0.01" docs and didn't see any issues about LIKE qualifications being
interpreted differently in 7.0.01 versus 5.1.2 and I checked the patch notes
for 7.0.01 just to see if it was a possible bug. No luck.
I asked an old coworker of mine who now works on a 7.1 server if
he'd experienced anything like this, and he mentioned that I could change
"%" + "System" + "%" to "%System%"
That's all well and good, but this is only one active link in a
fairly large beast of an application. Did something change in the way the
WUT interprets LIKE qualifications?
Thanks much,
Michael A. McManus, SSgt, USAF
Remedy Developer
HQ 754 ELSG/DOMH
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers
Are" html___
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
