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 ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
