I didn't see this response when I responded earlier... I agree, this should be working for you. Sorry for being repetitive.
Jason ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 12:45 PM To: [email protected] Subject: Re: Is there anyway to pass a parameter to SQL Menu? ** yes... $fieldID$ is actually what we tried. I have not tried $field_name$ have you done this and had it work? On Mon, May 11, 2009 at 11:25 AM, Grooms, Frederick W <[email protected]> wrote: ** Have you tried using $FieldID$ instead of Field Name. It would be something like ='$536870923$' From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Marquez Rankin Sent: Monday, May 11, 2009 11: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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
