Hi Nitin,
which ARS version do you use? Do you get error messages?
Create a SQL menu:
- Create a new Menu object
- In box Menu Type select the SQL checkbox
- Set Label Index List to "1" and Value Index to "1"
- Copy the statement ( Conny's statement is correct ;-) ) into field
SQL command
Br,
Norbert
Am 18.10.2009 um 17:21 schrieb nitin gogna:
** 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] ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the
Answers Are"
--
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] ARSlist: "Where the Answers Are"
