Question: Table Name ?
Is there a way to find what the SQL table ID is for a Form - i.e. T234 ? Thanks! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Question: Table Name ?
Query the arschema table using LIKE. Or query the sql view for that table and look at the sql for the view. Drew ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Question: Table Name ?
Arschema contains a list of form names and schema id's -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: August 29, 2008 10:27 AM To: arslist@ARSLIST.ORG Subject: Question: Table Name ? Is there a way to find what the SQL table ID is for a Form - i.e. T234 ? Thanks! ___ 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: Question: Table Name ?
You can build a view form to the arschema table. That will give you a lot of information. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Friday, August 29, 2008 10:27 AM To: arslist@ARSLIST.ORG Subject: Question: Table Name ? Is there a way to find what the SQL table ID is for a Form - i.e. T234 ? Thanks! ___ 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: Question: Table Name ?
Thanks! On Fri, Aug 29, 2008 at 11:28 AM, Drew Shuller [EMAIL PROTECTED] wrote: Query the arschema table using LIKE. Or query the sql view for that table and look at the sql for the view. Drew ___ 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: Question: Table Name ?
I like the View Form idea, a lot! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Question: Table Name ?
Just remember you can build view forms to any of the ARSYSTEM tables. Just make sure you are very careful. As I said there is a lot of information in the ARSCHEMA table like Next Request ID for each table. If you make a change in that field guess what happens. We have been using this for years. Lenny Warren suggested it many moons ago. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, August 29, 2008 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Table Name ? I like the View Form idea, a lot! ___ 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: Question: Table Name ?
I always create a view form for the arschema. I usually create a form with two fields also. The first field I type in a query, such as: Select name, schemaid from arschema where name = XX Then a button I click that executes the query, and the query is set into the second window. I also always create a view form with a Date/Time field, a Character field, and two buttons. The first button will do a set fields action to the date/time field, setting it to the character field. The point of this is to translate a regular date into the epoch seconds. The second button does the inverse, giving me the epoch seconds of any date I need. It is very useful. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, August 29, 2008 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Table Name ? I like the View Form idea, a lot! ___ 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: Question: Table Name ?
If you create a View Form for arschema one of the fields is the Form name. You can then create a menu and attach it to the Form Name field. I think you will understand the rest. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Friday, August 29, 2008 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Table Name ? I always create a view form for the arschema. I usually create a form with two fields also. The first field I type in a query, such as: Select name, schemaid from arschema where name = XX Then a button I click that executes the query, and the query is set into the second window. I also always create a view form with a Date/Time field, a Character field, and two buttons. The first button will do a set fields action to the date/time field, setting it to the character field. The point of this is to translate a regular date into the epoch seconds. The second button does the inverse, giving me the epoch seconds of any date I need. It is very useful. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, August 29, 2008 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Table Name ? I like the View Form idea, a lot! ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Question: Table Name ?
Thanks everyone!! HAPPY FRIDAY! On Fri, Aug 29, 2008 at 11:41 AM, Nall, Roger [EMAIL PROTECTED] wrote: Just remember you can build view forms to any of the ARSYSTEM tables. Just make sure you are very careful. As I said there is a lot of information in the ARSCHEMA table like Next Request ID for each table. If you make a change in that field guess what happens. We have been using this for years. Lenny Warren suggested it many moons ago. HTH, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Drew Shuller Sent: Friday, August 29, 2008 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Question: Table Name ? I like the View Form idea, a lot! ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
