May I extend Ross's idea just a little bit? Do not use the ID directly in that search criteria. You "find" that ID and set in a hidden field. Search the CTM:SupportGroups table in a preceding piece of code, which is multi tenant enabled, so will return only those rows, that belong to the user performing the search, thus returning the right ID, and use the field that captured that ID in the search criteria you have built instead of hardcoding the value.
This would make the solution a little less hard coded, should that ID change for whatever reason. Technically it should not, but s**t happens sometimes especially with small faults in a migration or something like that. Generally it is a good idea to think in the direction of not hard coding stuff in the work flow unless it is just not possible to not do so. At least that is how I have built a lot of my code in my recent years and it works like a charm. I also have reasons to believe there is more value in code built that way. Cheers Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Mitcham, Ross Sent: Saturday, March 22, 2014 1:06 PM To: [email protected] Subject: Re: ITSM - HPD:Help Desk What is wrong with this statement? I might make a suggestion to not use 'Assigned Group' = "Desktop Solutions" and use the support group ID ex. 'Assigned Group ID' = "SGP00000000000x") This can prevent future issues if: * you ever create a another support group called Desktop Solutions under another Company/Tenant * You change the name of you Desktop support group Regards, -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Terry Bootsma Sent: Friday, March 21, 2014 9:37 PM To: [email protected] Subject: Re: ITSM - HPD:Help Desk What is wrong with this statement? Hi Claire... You don't have your brackets in the right place... The way you had it, it was behaving exactly add you described. See corrected below... (Inline) Terry On Mar 21, 2014 11:31 AM, "Sanford, Claire" < <mailto:[email protected]> [email protected]> wrote: > > Very simple. > > If the Closure Prod Cats and specifically the Product Name are not filled in and the ticket is assigned to the Desktop Solutions team, you can't "Resolve" the ticket. > > They are the only group that will use the Hardware/End User Device > combo. > > It works in terms of other groups still being able to close their tickets if the Closure Product name is filled in or left blank. It does not matter at all if they are filled in or not, the DS team could not resolve a ticket. > > What do I have wrong here??? > > Run IF > > (('Assigned Group' = "Desktop Solutions") AND (('Status' = "Resolved") > OR ('Status' = "Closed"))) AND ('Closure Product Category Tier1' = > "Hardware") AND ('Closure Product Category Tier2' = "End User Device") > AND ('Closure Product Name' = $NULL$) > > Error message tells them they have to fill in the fields if they are > blank. > > Right now regardless of whether or not they are filled in they get the error. > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org> www.arslist.org > "Where the Answers Are, and have been for 20 years" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at <http://www.arslist.org> www.arslist.org "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"
