Skip to Content
Menu
This question has been flagged
1 Reply
4795 Views

I have a function which selects a query from database and returns a result, I want to use this function in my openoffice report, please help on how to call that function in the report.

Avatar
Discard
Best Answer

You should add methods you want to use in the report in the python file inside report folder of your module. For example:

class picking(report_sxw.rml_parse):
    def __init__(self, cr, uid, name, context):
        self.localcontext.update({
            'time': time,
            'your_method_name_from_rml':self._your_method,
        })   

    def _your_method(self,value):
        result = []
        object = self.pool.get('object.name')
        # DB query
        return result

In self.localcontext.update, you have to add the new methods added, so that they are "visible" from the RML file, together with the method they are related to.

You should call your new method from the RML file using the following code:

[[ your_method_name_from_rml(o.value) ]]

Hope you find this useful

Avatar
Discard
Related Posts Replies Views Activity
1
May 15
6170
1
Dec 22
44569
1
Sep 18
4337
0
Mar 15
11430
1
Mar 15
9675