Is there anyway to pass a parameter to SQL Menu?

[Marquez Rankin]

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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"