Ok....I stand corrected :) -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Friday, May 21, 2010 8:28 AM To: arslist@ARSLIST.ORG Subject: Re: View forms and Remedy Schema tables
You should find an Oracle view of Txxx for your Remedy View Form. For Regular forms Remedy creates T/H/B tables. For View forms Remedy creates T views in the database. Dialog and Vendor forms are not represented tables/views in the database. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ LongWing Sent: Friday, May 21, 2010 8:58 AM To: arslist@ARSLIST.ORG Subject: Re: View forms and Remedy Schema tables Gopal, I may be off base on this one.....but I don't believe that Remedy creates views of 'view forms'....due to the fact that Remedy is not maintaining the data for the form (the view is)....I don't believe you will find T/H/B tables for it....same thing for Display only Forms....and I think Vendor as well.... -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gopal-srg Sent: Friday, May 21, 2010 4:46 AM To: arslist@ARSLIST.ORG Subject: Re: View forms and Remedy Schema tables Hi ben, Thanks for ur response.we are having a situation here like there are some view forms(Created using Native SQL Prev6), somehow for some os these view forms the T ables ,H Tables and B tables has been dropped off from the databse(Oracle). We need to find such those view forms. Are we need to query the oracle databse to know this information or there is another way to find out those view forms that do not T,H and B tables using a AR admin and AR User tool? One more question is, are the view forms without the T,H and B Tbales will be visible in AR Admin tool? Please provide information for the above queries, it will be more helpful... Regards SRG Ben Chernys wrote: > > How to find out almost anything: Look the documentation! Specifically AR > System Database Reference, and, for the "SchemaType" integers, file "ar.h" > (not the best spot) > > select name from arschema where schematype = 3 > > #define AR_SCHEMA_NONE 0 /* null schema */ > #define AR_SCHEMA_REGULAR 1 /* regular schema */ > #define AR_SCHEMA_JOIN 2 /* join schema, has two member schemas */ > #define AR_SCHEMA_VIEW 3 /* view schema, has one base schema */ > #define AR_SCHEMA_DIALOG 4 /* dialog schema, only display-only fields */ > #define AR_SCHEMA_VENDOR 5 /* vendor schema */ > #define AR_SCHEMA_MAX_SCHEMA_TYPE 5 /* list the max type of schema */ > > Ben Chernys > > Senior Software Architect > Software Tool House Inc. > > Canada / Deutschland / Germany > Mobile: +49 171 380 2329 GMT + 1 + [ DST ] > Email: Ben.Chernys _at_ softwaretoolhouse.com > Web: www.softwaretoolhouse.com > > Check out Software Tool House's free Diary Editor. > > Meta-Update, our premium ARS Data tool, lets you automate > your imports, migrations, in no time at all, without programming, > without staging forms, without merge workflow. > http://www.softwaretoolhouse.com/ > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Gopal-srg > Sent: May 21, 2010 8:30 AM > To: arslist@ARSLIST.ORG > Subject: View forms and Remedy Schema tables > > Hi all, > I need some information regarding the remedy view forms. > How to find the view forms created with Native SQL(Prev6) which are not > having T tables? > > Regards, > SRG ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
