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 ) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
