Re: Form Aliases (UNCLASSIFIED)
Gordon, There is a message entitled "Delete Records of Alert Events" from Jan 10 with a SQL script attached that lists all the ARS forms with their corresponding DB table names. Is this what you are looking for? Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC Sent: Tuesday, March 25, 2008 8:05 AM To: arslist@ARSLIST.ORG Subject: Form Aliases (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Does anyone know what DB table the form "aliases and labels" are held in? I had thought it was arschema, but they don't appear to be there. Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified DISA\Verizon FNS Office phone: 703-614-6130 Office email: [EMAIL PROTECTED] Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Form Aliases (UNCLASSIFIED)
Classification: UNCLASSIFIED Caveats: NONE Thanks for the feedback. I am actually looking for where the alias is held. Example: Form Name: HPD:Help Desk Alias: Incidents I know about the .dat in the home directory, but aren't these held in a database table someplace? Like I said, I thought it was arschema. Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified DISA\Verizon FNS Office phone: 703-614-6130 Office email: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Tuesday, March 25, 2008 8:40 AM To: arslist@ARSLIST.ORG Subject: Re: Form Aliases (UNCLASSIFIED) Gordon, There is a message entitled "Delete Records of Alert Events" from Jan 10 with a SQL script attached that lists all the ARS forms with their corresponding DB table names. Is this what you are looking for? Stephen Remedy Skilled Professional -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC Sent: Tuesday, March 25, 2008 8:05 AM To: arslist@ARSLIST.ORG Subject: Form Aliases (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Does anyone know what DB table the form "aliases and labels" are held in? I had thought it was arschema, but they don't appear to be there. Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified DISA\Verizon FNS Office phone: 703-614-6130 Office email: [EMAIL PROTECTED] Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Form Aliases (UNCLASSIFIED)
FRANK, GORDON CTR DISA JSSC wrote: Classification: UNCLASSIFIED Caveats: NONE Thanks for the feedback. I am actually looking for where the alias is held. Example: Form Name: HPD:Help Desk Alias: Incidents I know about the .dat in the home directory, but aren't these held in a database table someplace? Like I said, I thought it was arschema. Gordon M. Frank Gordon, The "Web" alias name is stored in the arschema table in the objProp column. Look for object property number 60018 and you should find the following for your example: 60018\4\9\Incidents\ Hope this helps, Ian Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support & Information Team, Academic & Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741 web: http://www.open.ac.uk/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Form Aliases (UNCLASSIFIED)
Classification: UNCLASSIFIED Caveats: NONE Yes, This is what I am looking for. Thanks Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified DISA\Verizon FNS Office phone: 703-614-6130 Office email: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ian Trimnell Sent: Tuesday, March 25, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Form Aliases (UNCLASSIFIED) ** FRANK, GORDON CTR DISA JSSC wrote: Classification: UNCLASSIFIED Caveats: NONE Thanks for the feedback. I am actually looking for where the alias is held. Example: Form Name: HPD:Help Desk Alias: Incidents I know about the .dat in the home directory, but aren't these held in a database table someplace? Like I said, I thought it was arschema. Gordon M. Frank Gordon, The "Web" alias name is stored in the arschema table in the objProp column. Look for object property number 60018 and you should find the following for your example: 60018\4\9\Incidents\ Hope this helps, Ian Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support & Information Team, Academic & Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741 web: http://www.open.ac.uk/ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Classification: UNCLASSIFIED Caveats: NONE ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Form Aliases (UNCLASSIFIED)
The alias you are looking for is going to be stored with the View, not the form itself, I don't know the tables, but I know how to get at it via the API. The reason it's stored there is because each view of a form can have its own alias. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ian Trimnell Sent: Tuesday, March 25, 2008 7:27 AM To: arslist@ARSLIST.ORG Subject: Re: Form Aliases (UNCLASSIFIED) ** FRANK, GORDON CTR DISA JSSC wrote: Classification: UNCLASSIFIED Caveats: NONE Thanks for the feedback. I am actually looking for where the alias is held. Example: Form Name: HPD:Help Desk Alias: Incidents I know about the .dat in the home directory, but aren't these held in a database table someplace? Like I said, I thought it was arschema. Gordon M. Frank Gordon, The "Web" alias name is stored in the arschema table in the objProp column. Look for object property number 60018 and you should find the following for your example: 60018\4\9\Incidents\ Hope this helps, Ian _ Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support & Information Team, Academic & Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741 web: http://www.open.ac.uk/ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Form Aliases (UNCLASSIFIED)
LJ Longwing wrote: ** The alias you are looking for is going to be stored with the View, not the form itself, I don't know the tables, but I know how to get at it via the API. The reason it's stored there is because each view of a form can have its own alias. The view alias and label name(s) can be found in the table field_dispprop. You need to look for rows where the schemaId is that of your schema and the fieldId is NULL. There is a row for each vuiId and in the propLong column you will find the information concerning view names and labels. The structure of the propLong field is a bit complicated to describe in an email, but it consists of '\' delimited values detailing the values of the various properties of the view. The first number is the number of properties stored. For the view name look for the string '20\4\nn\' where nn represents the length of the name string and is that name. The label for "Entry Point, New Mode" is property number 5026 and that for "Entry Point, Search Mode" is 5027. If the label is empty then the property value will be displayed as 5026\4\0\\ (for New Mode). I know it looks confusing but I hope this helps. Using the API is makes it much slightly easier to decipher as it separates out the properties for you, but you still have to work out some of the values for yourself. Ian Ian Trimnell, AR System Lead Developer (amongst other jobs), Specialist Support & Information Team, Academic & Administrative Computing Service Open University, MILTON KEYNES, UK Phone: 01908 653741 web: http://www.open.ac.uk/ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"