Hi Conny, Thanks a million for your solution but there is something strange I am facing, the query is working fine on the database when I copy same query n the ARS, it doesnt work. Could you please help me?
Regards, Nitin On Sun, Oct 18, 2009 at 8:08 PM, Conny Martin <conny.mar...@t-systems.com>wrote: > here's the correct one. > > select f.name > from filter f,filter_mapping fm, arschema s > where f.filterid = fm.filterid AND fm.schemaid = s.schemaid > and s.name = 'formname' > > Kind Regards Conny > > -----Ursprüngliche Nachricht----- > Von: Action Request System discussion list(ARSList) [mailto: > arsl...@arslist.org] Im Auftrag von Norbert Bolmer > Gesendet: Sonntag, 18. Oktober 2009 16:13 > An: arslist@ARSLIST.ORG > Betreff: 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 = '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: rmisoluti...@verizon.net ARSlist: "Where the > > Answers Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:rmisoluti...@verizon.net <sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:rmisoluti...@verizon.net<sponsor%3armisoluti...@verizon.net>ARSlist: > "Where the Answers Are" > -- With Warm Regards, Nitin Gogna _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"