Axton:
Unless all of the underlying databases support the requested functionality, you will never see it in ARS. Thus, you probably will not see nested queries even if they are quicker and easier.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Tuesday, August 08, 2006 11:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Nested SELECT table qualification?
My opinion on the enhancement request is that BMC will not venture anywhere near actually using a db for anything above simple select, insert, update, and delete statements.
Union joins, table field grouping/aggregates (sum, avg, stddev, etc), sub-queries; keywords like 'in' and 'between'; are all beyond the capabilities of ARS.
Axton Grams
On 8/8/06, Thomas Bean <[EMAIL PROTECTED]> wrote:
> **
> Create a database view that performs the nested select statement, then
> create a View form in ARS that reads from the view. You will probably
> need to include the C1 column in your SELECT, so that you have a valid
> field to use as the Request ID column in the View form.
>
> Use the View form as the source for your table field, and give it a
> blank qualification or something like "(1 = 1)". (The SELECT
> statement in the database view should filter the query results).
>
> HTH,
>
> Thomas
>
>
> ----- Original Message -----
> From: Peter Joran
> Newsgroups: gmane.comp.crm.arsystem.general
> Sent: Tuesday, August 08, 2006 12:32
> Subject: Nested SELECT table qualification?
>
> All
> I'm hoping for a simple answer for a simple question. How can you do a
> nested SELECT in a table field qualification? If there is no simple
> way what's the opinion regarding an enhancement request?
>
> Many Thanks!
> Pete
> Oracle
> AR7
>
> For Example:
>
> SELECT C536870913,C536870914,C536870915 FROM T191 WHERE C536870913 !=
> 'SID25'
> AND
> C536870914 IN
> (SELECT C536870914
> FROM T191
> WHERE C536870913 = 'SID25'
> AND
> C536870915 IN
> (SELECT C536870915
> FROM T191
> WHERE C536870913 = 'SID25')) ORDER BY
> C536870914;This electronic message contains information from CACI
> International Inc or subsidiary companies, which may be company
> sensitive, proprietary, privileged or otherwise protected from
> disclosure. The information is intended to be used solely by the
> recipient(s) named above. If you are not an intended recipient, be
> aware that any review, disclosure, copying, distribution or use of
> this transmission or its contents is prohibited. If you have received
> this transmission in error, please notify us immediately at
> [EMAIL PROTECTED] With the exception of messages sent by authorized
> CACI contracts or purchasing personnel, nothing in this message may be
> interpreted as a digital or electronic signature that can be used to:
> (a) authenticate either the submission or the acceptance of a proposal
> or offer to contract, or (b) modify an existing contract.
>
> __20060125_______________________This posting was submitted with HTML
> in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
