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 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
group_list_query.pdf
Description: Adobe PDF document
