Frederick is correct, you use the field ID in the format he states. There are OOB menus that use direct SQL that you can use as a model. One such (in Change Management 7.0.3) is SYS:MNU:ChangeTimingReason-S.
Regards, Chuck Baldi On Mon, May 11, 2009 at 12:25 PM, 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"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
