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"
