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"