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