I have to take the count of number of item in my invoice_line in my invoice [[repeatIn(o.move_lines,'line')]] --------------->here I am creating the object [[ reduce(lambda x, obj: x+obj.line , list , 0 ) ]] -------------------->expression to return the number of line in my invoice so my desired output should be like this *| location | code |

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Apskaita
Atsarga
PoS
Projektas
MRP

All apps

All Posts People Badges

Žymos (View all)

odoo accounting v14 pos v15

About this forum

Pagalba

How to use lambda expression in RML report

lambda

1 Atsakyti

7383 Rodiniai

Vigneshwaran

I have to take the count of number of item in my invoice_line in my invoice

<section>
<para>[[repeatIn(o.move_lines,'line')]]</para>--------------->here I am creating the object
<blockTable>
<tr>
<td>
<para style="terp_tblheader_General_Centre1">[[ reduce(lambda x, obj: x+obj.line , list , 0 ) ]] </para>-------------------->expression to return the number of line in my invoice
</td><t/r></blocktable></section>

so my desired output should be like this

| location | code | product | qty

House1 10 ipad 1

House2 25 iphone 2

----------------------------

total 3 ------------------------>For this how to use lambda function..In RML report

Anand Patel

Hi,

Lambda is the python function and you can use eeasily all the python function in the RML.

but if you need to count the no of lines of the invoice then you can pass one method which is called from the RML and revert the answer form the report's py file

i.e.

[[repeatIn(o.move_lines,'line')]] this is your rml loop for the invoice line. now you just need to call one method in the loop so it will count the and revert from the py side to rml and you will have your desired output

Vigneshwaran

Autorius

thanks for your answer, but i directly create a function in python and call it in my rml report like this, def _sum_qty(self): total = 0 for line in picking.move_lines: total+=line.product_qty str(total) print total return total

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registracija

Related Posts	Replies	Rodiniai
TypeError: <lambda>() takes exactly 4 arguments (1 given) lambda typeError	1 birž. 22	7387
what is lambda in OpenERP? Solved python lambda	3 saus. 21	25713
(<NewId 0x7ffaad918908>,) Solved lambda api.depends computed-fields Odoo13 NewId	2 birž. 21	7079
Pass context in XML action based on current user id? xml default context lambda odoo11	1 liep. 20	7748
[odoo10] what does order.order_line.sorted() mean? sale sale.order.line lambda order.line sorted	1 saus. 18	11610

This question has been flagged

Enjoying the discussion? Don't just read, join in!