I've done it too. However, in my case, I had to first create the table and then put the materialized view on the prebuilt table in order for Remedy to recognize it. It didn't see it if I created a "normal" materialized view for some reason.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pritch Sent: Wednesday, September 14, 2011 7:33 AM To: arslist@ARSLIST.ORG Subject: Re: materialized View and Remedy View form Yes - I've created a view form using the materialized view - didn't have any issues. ----- Original Message ----- From: "Bhupesh Gupta" <gupta.bhupesh3...@gmail.com> To: arslist@ARSLIST.ORG Sent: Wednesday, September 14, 2011 7:12:06 AM Subject: materialized View and Remedy View form ** Dear All - Can we build an ARS View form over Materialized view ? Have soembody worked on this? -- Regards, Bhupesh Gupta _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"