Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Qweb report sort by and multi lines if number of code in a field exceed X number

By
Christian Parent
on 4/15/14, 10:30 AM 4,279 views

When working with qweb reports, is it possible to sort it ascending by internal reference ?

Also, I have a field which is called designation, it has the position on the board where to solder components. Is it possible to add a counter that after, lets say 10, components, it will add a new line in the fields and continue listing on the next line ?

                        <t t-foreach="docs" t-as="o">
                        <tr t-foreach="get_children(o.bom_lines)" t-as="l">

Sort ascending by pcode !!!

                             <td>
                                    <span t-esc="l['pcode']"/>
                            </td>
                            <td>
                                <span t-esc="formatLang(l['pqty'])"/>
                                <span t-esc="l['uname']" groups="product.group_uom"/>
                            </td>

Designation is hard coded for now but will come from a field named designation. After printing 10 numbers, it would make a new line a keep going for 10 more.

                            <td>R1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19,20.</td>
                            <td>
                                <span style="color: white;" t-esc="'... '*(l['level'])"/>
                                <span t-esc="l['name']"/>
                            </td>
                            <td>
                                <span t-esc="l['spcode']"/>
                            </td>
                            <td>
                                <span t-esc="l['qavail']"/>
                            </td>
                        </tr>
                    </t>

Is it possible ?

1
zuher83
On 11/14/15, 11:45 AM

Hi,

If you want sort an object in qweb try:

Eg: I want to sort all sale order by partner name in my report:

<t-as="l" t-foreach="o.order_ids.sorted(key=lambda b: b.partner_id.name)">
<span t-field="l.partner_id.name"/>
....
</t>

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 4/15/14, 10:30 AM
Seen: 4279 times
Last updated: 11/14/15, 11:45 AM