Remedy View forms and SQL
Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS: 7.0.01 i wont to pull the data from the form which is present in the same database( as arsystem tablenamespace) under user sys(System tablenamespace) using remedy view forms using SQL query. my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='ARADMIN' AND TABLE_NAME='T1' when i am trying to load the columns its throwing error like Failure during SQL operation to the database : ORA-00933: SQL command not properly ended (ARERR 552). Please help in solving the issue. Regards, SQL -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677247.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Remedy View forms and SQL
Hi, i think you should first create view with your query in the DB and then create the view form on the new view On Wed, May 26, 2010 at 10:11 AM, Gopal-srg srgr...@gmail.com wrote: Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS: 7.0.01 i wont to pull the data from the form which is present in the same database( as arsystem tablenamespace) under user sys(System tablenamespace) using remedy view forms using SQL query. my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='ARADMIN' AND TABLE_NAME='T1' when i am trying to load the columns its throwing error like Failure during SQL operation to the database : ORA-00933: SQL command not properly ended (ARERR 552). Please help in solving the issue. Regards, SQL -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677247.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- BR, Hany ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Remedy View forms and SQL
Hi Hany, Thanks for ur response. the view for the form which i try in SQL already exist in the database. Also error which it throws is like some error in the SQL definition. Regards, Gopal Hany Abd El_Fatah wrote: Hi, i think you should first create view with your query in the DB and then create the view form on the new view On Wed, May 26, 2010 at 10:11 AM, Gopal-srg srgr...@gmail.com wrote: Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS: 7.0.01 i wont to pull the data from the form which is present in the same database( as arsystem tablenamespace) under user sys(System tablenamespace) using remedy view forms using SQL query. my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='ARADMIN' AND TABLE_NAME='T1' when i am trying to load the columns its throwing error like Failure during SQL operation to the database : ORA-00933: SQL command not properly ended (ARERR 552). Please help in solving the issue. Regards, SQL -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677247.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- BR, Hany ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677930.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Remedy View forms and SQL
Hi, then you can check the fields type if it's supported from remedy or not, and if the view exist in the DB so all what you need is to write the view name in the view form not the SQL On Wed, May 26, 2010 at 11:39 AM, Gopal-srg srgr...@gmail.com wrote: Hi Hany, Thanks for ur response. the view for the form which i try in SQL already exist in the database. Also error which it throws is like some error in the SQL definition. Regards, Gopal Hany Abd El_Fatah wrote: Hi, i think you should first create view with your query in the DB and then create the view form on the new view On Wed, May 26, 2010 at 10:11 AM, Gopal-srg srgr...@gmail.com wrote: Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS: 7.0.01 i wont to pull the data from the form which is present in the same database( as arsystem tablenamespace) under user sys(System tablenamespace) using remedy view forms using SQL query. my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='ARADMIN' AND TABLE_NAME='T1' when i am trying to load the columns its throwing error like Failure during SQL operation to the database : ORA-00933: SQL command not properly ended (ARERR 552). Please help in solving the issue. Regards, SQL -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677247.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- BR, Hany ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- View this message in context: http://old.nabble.com/Remedy-View-forms-and-SQL-tp28677247p28677930.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are -- BR, Hany ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Remedy View forms and SQL
So you want a view form 1 record that has only 1 column? What do you have in the Form Properties, View Information tab? Fred -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Gopal-srg Sent: Wednesday, May 26, 2010 2:11 AM To: arslist@ARSLIST.ORG Subject: Remedy View forms and SQL Hi all, i am just trying to create a remedy view form and environment details are below DB : Oracle ARS: 7.0.01 i wont to pull the data from the form which is present in the same database( as arsystem tablenamespace) under user sys(System tablenamespace) using remedy view forms using SQL query. my query in Remedy view form is SELECT TABLE_NAME FROM SYS.ALL_TABLES WHERE OWNER='ARADMIN' AND TABLE_NAME='T1' when i am trying to load the columns its throwing error like Failure during SQL operation to the database : ORA-00933: SQL command not properly ended (ARERR 552). Please help in solving the issue. Regards, SQL ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are