Re: Menu to list flters of a form (UNCLASSIFIED)
Classification: UNCLASSIFIED Caveats: NONE Not sure if it's just a difference in the tables in 7.1 but the below worked for me. select name from filter where filterId in (select filterId from filter_mapping where schemaid in (select schemaid from arschema where name = 'FORMNAME')) order by name; -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Sunday, October 18, 2009 2:58 PM To: arslist@ARSLIST.ORG Subject: Re: Menu to list flters of a form ** You could also use select name from filter where schemaid in (select schemaid from arschema where name = 'formname') order by name; to get a ordered list of filter names tied to your form in question.. Joe From: Norbert Bolmer norb...@bolmer.de To: arslist@ARSLIST.ORG Sent: Sun, October 18, 2009 10:13:05 AM Subject: 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 blockedhttp://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_ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Menu to list flters of a form
I have done this before. I used a SQL menu. First I fetch the Form name and then it's schemaID and placed the schemaId in field 536870970 then I use the select statement below in a SQL menu (not character). select name from filter where filterid in (select filterid from filter_mapping where schemaId='$536870970$') -- Ibrahim Akar ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Menu to list flters of a form
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
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
AW: Menu to list flters of a form
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
Re: Menu to list flters of a form
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.comwrote: 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.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: 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
Re: Menu to list flters of a form
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 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 ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- 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
Re: Menu to list flters of a form
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 norb...@bolmer.de 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 conny.mar...@t-systems.comwrote: 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.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are -- With Warm Regards, Nitin Gogna _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@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
Re: Menu to list flters of a form
You could also use select name from filter where schemaid in (select schemaid from arschema where name = 'formname') order by name; to get a ordered list of filter names tied to your form in question.. Joe From: Norbert Bolmer norb...@bolmer.de To: arslist@ARSLIST.ORG Sent: Sun, October 18, 2009 10:13:05 AM Subject: 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Menu to list flters of a form
Hi Nitin, did you replace the string formname with the name of an existing form or shall the formname replaced by a field value from your form? In this case you have to fill in the FIELDID instead of the FIELDNAME select f.name from filter f,filter_mapping fm, arschema s where f.filterid = fm.filterid AND fm.schemaid = s.schemaid and s.name = '$536870123$' -- Replace the field id with the correct id. Br Norbert Am 18.10.2009 um 19:42 schrieb nitin gogna: ** 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 norb...@bolmer.de 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 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 ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are -- With Warm Regards, Nitin Gogna _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ -- 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