Jarl/Joe/Axton/Jay:
Look in the Developer Connection. This may be there as a schema. I think that was where we started and worked our way through the situation where we had a form to reset the NextID on our development server. Made things much easier. And this was in the day before Display Only forms (ARS 3.2.1)
James McKenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jarl Grøneng
Sent: Monday, October 23, 2006 10:41 PM
To: arslist@ARSLIST.ORG
Subject: Re: Enhancement: Schema ID on AR Admin tool...
Remedy had(has?) a tool to convert sql logfile schemaid's and fieldis to schemanames and fieldnames.
--
Jarl
On 10/23/06, Joe DeSouza <[EMAIL PROTECTED]> wrote:
> **
>
>
> Troubleshooting one of my customers application for performance, so
> since SQL logs show T<schemaId> on SQL logs, I have to query the
> arschema table all the time before opening the form in question in the
> Admin tool.. which is where I found that if the admin tool listed the
> schemaId's with their corresponding schema Id's, it would have been
> easier for me to identify the form by the ID instead of its name..
> also it would have been nice to have the View by feature modified to
> show a form or a list of forms by schema ID's..
>
> Personally I do not think it will be too hard to modify the Admin tool
> code to display the schemaid along with the schema name..
>
> Rgds
>
> Joe D'Souza
> Remedy Developer / Consultant,
> Shyle Networks,
> New Jersey.
>
>
>
> ----- Original Message ----
> From: Axton <[EMAIL PROTECTED]>
> To: arslist@ARSLIST.ORG
> Sent: Sunday, October 22, 2006 11:53:21 AM
> Subject: Re: Enhancement: Schema ID on AR Admin tool...
>
>
> It would be nice, would also be nice to see a list of forms/fields a
> menu is attached to.
>
> Joe, what are you doing where the schemaid would be useful? In my
> direct sql workflow, I set an integer field to the schemaid and use
> that as a variable in the direct sql action. I do this because the
> schemaid can vary from server to server. I refrain from using the
> views for several reasons (the naming has changed in the past;
> permissions get dropped from views on each form change; etc.).
>
> Axton Grams
>
> On 10/22/06, Jarl Grøneng <[EMAIL PROTECTED]> wrote:
> > I dont see the problem. Active links can be a part of unlimited
> > number of
> forms.
> >
> > This is an enhancment I would like to se. I had to create a sql-stmt
> > to list which active links and filters that are not part of a guide
> >
> > --
> > Jarl
> >
> >
> > On 10/22/06, Joe D'Souza <[EMAIL PROTECTED]> wrote:
> > > That might be nice but you got to remember that an AL or a filter
> > > could
> be a
> > > part of more than one guide... and I do not think there is a limit
> > > to
> the
> > > number of guides you can tie a AL or Filter to...
> > >
> > > Joe
> > >
> > > -----Original Message-----
> > > From: Action Request System discussion list(ARSList)
> > > [mailto:arslist@ARSLIST.ORG]On Behalf Of Jay Rohrer
> > > Sent: Saturday, October 21, 2006 8:07 PM
> > > To: arslist@ARSLIST.ORG
> > > Subject: Re: Enhancement: Schema ID on AR Admin tool...
> > >
> > >
> > > I would not find that nearly as useful as having a tab on ALs and
> > > FILs
> that
> > > tell me which Guides they are a part of.
> > >
> > > Jay Rohrer
