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: [email protected] 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:[EMAIL PROTECTED] Behalf Of Jay Rohrer > > Sent: Saturday, October 21, 2006 8:07 PM > > To: [email protected] > > 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 __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
