Community mailing list archives


Reporting Dashboard Query Cached

- 09/28/2017 03:59:31

Hi All

I am trying to cached my reporting dashboard in odoo. I have cached my query using fetchall() and store the result in variable FinalData now i am trying to create view using FinalData.
i have added following code in init method but it is showing OperationalError: Operatio...ursor.',).

tools.drop_view_if_exists(cr, self._table)
cr.execute( "CREATE OR REPLACE VIEW %s AS  FinalData" %(self._table))

Is it possible to do something like this? 

Please help me if there's a better way to cache reporting dashboard.

Thanks in advance.

Thanks & Regards

Ummiyah Nasim

"Privileged/Confidential Information  - Disclaimer"

 " Privileged/Confidential Information may be contained in this message/email and is intended only for the use of the addressee. If you are not the addressee, or person responsible for delivering it to the addressee, you should not copy or deliver this to anyone else. If you receive this message by mistake, please delete the message from any/all computer/s and notify the sender immediately by reply Email. We appreciate your assistance in preserving the confidentiality of our correspondence. Any information in this message that does not relate to the official business of the organization shall be understood as neither given nor endorsed by it. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful. The recipient acknowledges that Voylla Fashions Pvt.  Ltd. or  any of its affiliates or its subsidiaries and associated companies are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Voylla Fashions Pvt.  Ltd. Please advise immediately if you or your employer does not consent to Internet Email for messages of this kind. Before opening any attachments please check them for viruses and defects. Thank you.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email."