Hi Marquez,
You can pass field variables in sql menus. You just have to use the field ID instead of the name. SELECT value FROM table WHERE field = '$REMEDYFIELDID$' I use that in many sql menus, works just fine... Jason ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ Longwing Sent: Monday, May 11, 2009 12:57 PM To: [email protected] Subject: Re: Is there anyway to pass a parameter to SQL Menu? I have done it in Search menus successfully...don't think I've tried it with SQL....try turning on SQL Logging in the client when you open the window and verify that the SQL being passed is correct. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 10:22 AM To: [email protected] Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** Yeah we tried that with no success. Has this worked for you before? On Mon, May 11, 2009 at 10:53 AM, LJ Longwing <[email protected]> wrote: ** You should be able to use $Field Name$ from the form you intent to attach the menu to to get it to substitute that value in. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: [email protected] Subject: Is there anyway to pass a parameter to SQL Menu? ** The documentation doesnt mention whether this can be done or not. I need to pass the current request number (or instance ID) into this SQL Menu Query so it will return a list based on data within the active request. See the SQL Statement below. I should not have to hard code the Instance ID and of course this will only serve one record. Any word on this? We are on ARS 7.01 / Oracle / Solaris SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS>1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS>1 GROUP BY [FORM_NAME_INSTANCE_ID] HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) UNION SELECT [FIRST VALUE] FROM [FORM_NAME] TBL1 WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS>1 AND EXISTS ( SELECT [FORM_NAME_INSTANCE_ID], COUNT(DISTINCT [FIRST VALUE]) FROM [FORM_NAME] WHERE [FORM_NAME_INSTANCE_ID]='SA222159775600SA1cLA7Qj_8Ax1UB' AND STATUS>1 GROUP BY [FORM_NAME_INSTANCE_ID]HAVING COUNT(DISTINCT [FIRST VALUE]) = 1 ) _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
