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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"