It would not be too easy for you to create a internal DB view of a table if you need to use the EXTERNAL() keyword for the simple reason EXTERNAL() is usually used to make the table field qualification dynamic by using values contained on the current screen. Unless offcourse the base part of the qualification can be passed from the nested select, and then you further requalify what is returned by that view based on values on the current screen, then EXTERNAL() could be used against it.
An example would be after you do the nested select to return a view, if you want to further qualify that view to return records that are not older than 5 days or values that are of a certain Status, etc... I've recently used this, and then used EXTERNAL() to give the users the ability to have a custom search criteria, using fields on the control panel of my home page. Works like a charm...
We would be able to analyze if you could use this DB view approach if you could describe what you want to do..
Joe D'Souza
Remedy Developer / Consultant,
BearingPoint,
Virginia.
----- Original Message ----
From: Peter Joran <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, August 8, 2006 2:51:58 PM
Subject: Re: Nested SELECT table qualification?
From: Peter Joran <[EMAIL PROTECTED]>
To: [email protected]
Sent: Tuesday, August 8, 2006 2:51:58 PM
Subject: Re: Nested SELECT table qualification?
Thanks for the replies! I do have a need to use an EXTERNAL qualification.
Pete
-----"Action Request System discussion list(ARSList)" <[email protected]> wrote: -----
To: [email protected]
From: Axton <[EMAIL PROTECTED]>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Pete
-----"Action Request System discussion list(ARSList)" <[email protected]> wrote: -----
To: [email protected]
From: Axton <[EMAIL PROTECTED]>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
