Hi Norbert, I am using ARS Server 5.5 whereas BMC Remedy User and Admin 7.0. I have tried using same steps as you have described but I do not see anything in the menu when I click on it though I do not get any error message. When I use the same query directly in database, it displays the list of filters correctly.
Regards, Nitin Gogna On Sun, Oct 18, 2009 at 9:20 PM, Norbert Bolmer <[email protected]> wrote: > ** 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] >> <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 > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > > > _Platinum 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"
