Classification: UNCLASSIFIED Caveats: NONE Not sure if it's just a difference in the tables in 7.1 but the below worked for me.
select name from filter where filterId in (select filterId from filter_mapping where schemaid in (select schemaid from arschema where name = 'FORMNAME')) order by name; -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Sunday, October 18, 2009 2:58 PM To: [email protected] Subject: Re: Menu to list flters of a form ** You could also use select name from filter where schemaid in (select schemaid from arschema where name = 'formname') order by name; to get a ordered list of filter names tied to your form in question.. Joe ________________________________ From: Norbert Bolmer <[email protected]> To: [email protected] Sent: Sun, October 18, 2009 10:13:05 AM Subject: Re: Menu to list flters of a form Hi Nitin, yes, use a SQL menu with following statement: select name from filter f, arschema s where f.schemaid = a.schemaid and a.name <blockedhttp://a.name/> = 'formname' Br, Norbert Am 18.10.2009 um 16:04 schrieb nitin gogna: > ** > Hi ARlist, > > Is there any way to create character menu in which I can list the filters related to a particular form? > > --With Warm Regards, > > Nitin Gogna _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ Classification: UNCLASSIFIED Caveats: NONE _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
