When you select "Data Source: SQL" in a Set Fields action, any results from the query are returned as $1$, $2$, etc. So if your SQL statement was:
select a, b, from my_form To map the results of "a" you would use a value of $1$, and for the results of "b" you would use a value of $2$. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales Sent: Thursday, June 18, 2015 2:48 PM To: arslist@ARSLIST.ORG Subject: Count CRQ related an INC in status=<"Completed" Hi, I need know how can I get in a field the result of SELECT COUNT (*) FROM CHG_Association_ID02Join WHERE (Request_ID01 =$Incident Number$ AND RequestID02_Status>=10) What I need is that no one could resolve or close or cancel and incident if it has one or more related changes in status less than completed, closed or canceled. I was trying to do this by a filter with a Direct SQL command with this query, but I don't know how to take the number of the result of the query. If you have any other solution please, let me know. Best Regards, Pamela _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" ---------------------------------------------------------------------- This email message and any attachments are for the sole use of the intended recipient(s). Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message and any attachments. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
