As Joe said it will not work that way. You are trying to mix direct SQL and Remedy. If you are working against a Remedy form then why are you needing to do your selection using direct SQL? Can you not use a standard Set Fields action to query for your records (as that will bring up the Results list for multiple matches)?
Fred ________________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Monday, January 05, 2009 6:29 AM To: [email protected] Subject: Re: how to open a window on a set field action with multiple request match The short answer is you cannot do what you are trying to do with the current limitations of the product. To the best of my knowledge you cannot 'set fields' to the Result list using workflow. Joe ________________________________________ From: Remedy Maniac <[email protected]> To: [email protected] Sent: Monday, January 5, 2009 6:06:09 AM Subject: how to open a window on a set field action with multiple request match dear all, I have a set field action built with a direct SQL. The query returns several rows. So I have set the "If Multiple Requests Match" to Display a List. What I would like to achieve is to have the Result list open instead of the SelectionPopup window. Is that possible? If not, then how can I build a workflow to have the Result list opens ? I tried with Set the Result List field to $1$ and tried the Open Window Action but I didn't manage to produce anything with this. I tried to select from the SelectionPopup window, but nothing opens when you click on the OK button. Any idea or tips would be appreciated. Thank you Serouche _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
