This question has been flagged
1 Reply
20819 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 ?

Avatar
Discard
Best Answer

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>
Avatar
Discard

I also need this..

I also tried like this but its not working.