Skip to Content
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odgovori
4639 Prikazi

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
Opusti
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
Opusti
Related Posts Odgovori Prikazi Aktivnost
1
maj 15
5951
1
dec. 22
44337
1
sep. 18
4234
0
mar. 15
11234
1
mar. 15
9460