Hmm, the 7.6.04 docs show that the percentage sign when used in a LIKE
operation "matches any string of 0 or more characters" which is why I didn't
add a clause for nothing at the end. I did test it with group ID 1 (and the
string Administrator) at the end of the Group List field and it matched the
filter qualification.

 

-Rick

 

 

___________________________

Rick Westbrock

QMX Support Services

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj
Sent: Monday, April 22, 2013 10:12 AM
To: arslist@ARSLIST.ORG
Subject: Re: Allowing Status Change By Group Membership

 

** 

Rick,

Yes, $GROUPS$ is messy, which is why they added the $GROUPIDS$ keyword, and
to avoid the exact issue you are discussing, the keyword for group ids
always has a semicolon at the beginning and end of the string, so you don't
need to do what you describe.

 

Oh...and you are forgetting the groups being at the END of the string...so
when using it you need to not only do '1234;%', '%;1234;%', but also
'%;1234'...very ugly :)

 

On Mon, Apr 22, 2013 at 10:44 AM, Rick Westbrock <rwestbr...@qmxs.com>
wrote:

** 

Does the system just read the Group List field of the User record when
resolving the operation? If so then wouldn't you also need to use LIKE
"12345%" since the first group wouldn't have the leading semi-colon? I was
using this extra clause when checking to see if group ID 1 was in the Group
List (field ID 104) of a supporting form (which is fed from the User form).
In my case I'm using 'Group List' LIKE "1;%" OR 'Group List' LIKE "%;1;%" to
check for the Admin group being the first or later in the field.

 

-Rick

 

___________________________

Rick Westbrock

QMX Support Services

 

From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Longwing, Lj
Sent: Monday, April 22, 2013 9:30 AM
To: arslist@ARSLIST.ORG
Subject: Re: Allowing Status Change By Group Membership

 

** 

Yolanda,

First I would suggest you utilize the group id keyword instead of the groups
keyword, only from the perspective that group names can 'overlap'...meaning
you can have an 'Admin' and 'Contact Admin', and if you do groups like
admin...both would match....but not if you utilize the group id keyword
properly...and I assume you want to throw an error when someone other than
the groups try...so you would want to try something like this

 

('Status' = "Scheduled" OR 'Status' = "Cancelled" OR ('Status = "Denied" AND
'Organization' = "EAST)) AND NOT ($GROUPIDS$ LIKE "%;12345;% OR  $GROUPIDS$
LIKE "%;23456;%"

 

please note the ; on both sides of the group ID.  This helps ensure that the
group id is fully encased, and not part of another group number.

 

On Mon, Apr 22, 2013 at 10:12 AM, Yolanda Collier
<yolanda.collier....@navy.mil> wrote:

We have a custom application and the customer would like to limit the user's
ability to change the status, unless that person is a member of a particular
organization. You must be a member of certain groups in order to change the
status to Scheduled, Cancelled, or Denied.

We have attempted to used ($GROUPS$ LIKE "%ABC%") OR ($GROUPS$ LIKE "%XYZ%")
OR (($GROUPS$ LIKE "%DFG%") AND ('Status' = "Scheduled")) OR ('Status' =
"Cancelled") OR (('Status' = "Denied") AND ('Organization' = "EAST"))

and we have attempted to use (NOT ($GROUPS$ LIKE "%ABC%") and it is still
not working.

Any suggestions on how to successfully implement would be greatly
appreciated.

____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 

_ARSlist: "Where the Answers Are" and have been for 20 years_

 

_ARSlist: "Where the Answers Are" and have been for 20 years_ 


_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"

Reply via email to