slist@ARSLIST.ORG
Subject: Re: Newbie help with creating a SQL menu..Making the SQL query
context sensitive
Thank you. Will try that.
One more question I have is: How do I make this menu context sensitive.
In other words. I have a field called Category with values Data and
Security. I
Couple of suggestions:
1. Use two Menus. One for server and for data. When user selects from
category you could change the menu with an Active Link Change action; you
might also have to do this on Display of each record.
2. You could have the table name and column be dynamic based on the Category
Thank you. Will try that.
One more question I have is: How do I make this menu context sensitive.
In other words. I have a field called Category with values Data and
Security. If the value is Data, I want to run a particular SQL query
(select distinct(LOCATION) from REMEDY.LOCATIONS). If the V
> >
> > Dave
> > --
> > [EMAIL PROTECTED] (Wireless)
> >
> > ----- Original Message -
> > From: Action Request System discussion list(ARSList)
> > To: arslist@ARSLIST.ORG
> > Sent: Sun Jul 29 13:13:51 2007
> > S
Ray,
In general all ARS workflow/objects should point at ARS servers. The
only exceptions that I can currently think of would be:
A) Calls to ARS Plugin Servers(Via Filter SetField actions)
ARS Plugin Servers can be hosted on non ARS Server hardware,
but typically are installed on ARS se
Message -
> From: Action Request System discussion list(ARSList)
> To: arslist@ARSLIST.ORG
> Sent: Sun Jul 29 13:13:51 2007
> Subject: Re: Newbie help with creating a SQL menu
>
> Hi Axton: I donot see anything in arerror.log. I have enabled logging on
> the remedy user client
ect: Re: Newbie help with creating a SQL menu
Hi Axton: I donot see anything in arerror.log. I have enabled logging on
the remedy user client and donot see anything there as well. Not sure if
his matters. This REMEDY user is not one created by remedy. It's a user
our db admin has created for
Jul 29 13:13:51 2007
Subject: Re: Newbie help with creating a SQL menu
Hi Axton: I donot see anything in arerror.log. I have enabled logging on
the remedy user client and donot see anything there as well. Not sure if
his matters. This REMEDY user is not one created by remedy. It's a user
our
I am not sure to which user you are referring. Any sql menu will run
as the db user that remedy is configured to use to connect to the db.
Axton
On 7/29/07, Ray <[EMAIL PROTECTED]> wrote:
> Hi Axton: I donot see anything in arerror.log. I have enabled logging on
> the remedy user client and dono
Hi Axton: I donot see anything in arerror.log. I have enabled logging on
the remedy user client and donot see anything there as well. Not sure if
his matters. This REMEDY user is not one created by remedy. It's a user
our db admin has created for readonly access to a few views and tables.
Than
1. Is there anything else I need to do for the SQL menu to work?
Shouldn't be
2. How does the sql menu know what is the password for the REMEDY user
in the database?
It already has sessions to the Oracle instance used by Remedy; it just
uses those
3. How does it know the ORACLE_SID to be used for
Hi: I have created a menu that should list value for all fields in a
database. The SQL command for the menu I am using is the following.
select distinct(LOCATION) from REMEDY.LOCATIONS
I have associated this menu with a field in my form. When I click on the
pulldown menu for the field, I get t
12 matches
Mail list logo
