The $GROUPS$ is going to be the groups the current logged in user has.
If you were to fire an active on a form and in the message box put
$GROUPS$ in it will show the groups you are assigned.
*Rocky*
Rocky Rockwell
eMA Team – Remedy Developer
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Ph#1: 214-567-8874
Ph#2: 325-884-1263
Grooms, Frederick W wrote:
**
Neel,
$GROUPS$ = The list of groups (in name format) that the user executing
the workflow is in. This will not search the whole database. It is
the same as what you see in the Group List when you look at a User
record for a user.
Fred
------------------------------------------------------------------------
*From:* Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] *On Behalf Of *SUBSCRIBE arslist Neel
*Sent:* Wednesday, April 25, 2007 12:00 PM
*To:* [email protected]
*Subject:* Re: Boolean Logic
**
Hello Michael,
You got me a bit confused here as “($GROUPS$ LIKE "%System POC%" )”
is a part of a qualification.
I believe that LIKE keyword will search the whole database and I think
it will find at least one record where $GROUPS$ is %System POC% AND
the ‘Dialog_Prev_Status’ is one of those 3.
May be you need to narrow-down to a record level somehow to avoid
having to scan the whole table. I would put a pre-condition like have
another field on the form and (let’s say temp_group) set temp_group =
“YES” if (($GROUPS$ LIKE "%System POC%" ) OR ($GROUPS$ LIKE
"%Reshipment%" ) OR ($GROUPS$ LIKE "%Quality Assurance%" )) otherwise
set it to “NO”
And then re-write your original qual as (( 'Dialog_Prev_Status' =
"Closed" ) OR ( 'Dialog_Prev_Status' = "Helpdesk Working" ) OR (
'Dialog_Prev_Status' = "Pending Vendor" )) AND (temp_group = “YES”)
I hope this helps.
Best regards,
*Neel Gautam*
Accenture - Chicago Delivery Centre
Office: 312-693-7279 Mobile: 630-440-6335
MSN: [EMAIL PROTECTED] AIM: neelgautam
Core Values: Stewardship · Best People
· Client Value Creation · One Global Network
· Respect for the Individual · Integrity
*From:* Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of* McManus Michael A SrA HQ
754 ELSG/DOO
*Sent:* Wednesday, April 25, 2007 9:53 AM
*To:* [email protected]
*Subject:* Boolean Logic
Version 5.1.2
SQL 2K
I’m having problems with a run if condition that isn’t allowing our
System POC’s to send emails. Here’s the condition.
(( 'Dialog_Prev_Status' = "Closed" ) OR ( 'Dialog_Prev_Status' =
"Helpdesk Working" ) OR ( 'Dialog_Prev_Status' = "Pending Vendor" ))
AND (($GROUPS$ LIKE "%System POC%" ) OR ($GROUPS$ LIKE
"%Reshipment%" ) OR ($GROUPS$ LIKE "%Quality Assurance%" ))
If it evaluates to true, a message pops up that tells the user they
don’t have permission to update a ticket that had a previous status
of: $Dialog_Prev_Status$
The problem is, this always evaluates to true if $GROUPS$ = “System
POC” regardless of the value of Dialog_Prev_Status.
I unhid Dialog_Prev_Status to make sure, and I had a ticket where
Dialog_Prev_Status = “Sys POC Working” and it still evaluated to true
and didn’t allow the System POC to update the ticket.
I’m sure it’s something boneheaded that I’m missing but I can’t wrap
my head around it.
Michael A. McManus, SrA, USAF
Remedy Developer
HQ 754 ELSG/DOOH
DSN: 596-6478/Comm: 334-416-6478
This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information. If you have
received it in error, please notify the sender immediately and delete
the original. Any other use of the email by you is prohibited.
__20060125_______________________This posting was submitted with HTML
in it_____20060125_______________________This posting was submitted
with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
