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 <[email protected]>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: > [email protected]] Im Auftrag von Norbert Bolmer > Gesendet: Sonntag, 18. Oktober 2009 16:13 > An: [email protected] > 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: [email protected] ARSlist: "Where the > > Answers Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum > Sponsor:[email protected] <sponsor%[email protected]>ARSlist: > "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:[email protected]<sponsor%[email protected]>ARSlist: > "Where the Answers Are" > -- With Warm Regards, Nitin Gogna _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
