Yes, it does need to be in single quotes for the sql menu. I am also using Remedy 7 on Solaris/Oracle so that should work for you as well.
________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 1:28 PM To: arslist@ARSLIST.ORG Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** So the syntax is '$FIELDID$' not $FIELDID$ ? I will try the former because the latter is what I have not and is not working On Mon, May 11, 2009 at 12:12 PM, Barnhill, Jason (Jason) <jbarnh...@avaya.com> wrote: ** 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:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Monday, May 11, 2009 12:57 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 10:22 AM To: arslist@ARSLIST.ORG 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 <lj.longw...@gmail.com> 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:arsl...@arslist.org] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 9:27 AM To: arslist@ARSLIST.ORG 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: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ -- Now let's all take a moment to ponder the depth, brilliance, and emotional gravity of Mr. Rankin's above statements. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"