Skip to Content
Menú
This question has been flagged
2 Respostes
1641 Vistes

Hi. I am working with Odoo Enterprise 16.4e+

Currently I have Manpower table in QWeb report showing workers with their position.

What I want to do is showing amount of each position in different table as depicted below. Is it possible to get the count?

Any help will be appreciated. Thanks!


Avatar
Descartar
Best Answer

Hi,

You can use a query to get the count and pass it to the report and show it in the qweb report.
The Query will be something like this:
SELECT COUNT(position), name FROM Customers GROUP BY positon;


Hope it helps


Avatar
Descartar
Autor

Hi. Thanks for the query but where to put that and how to show it in the qweb?

Best Answer

Hi,
What you are looking for is technically it is doable .

As saas 16.4 , doesn't support custom module or python codes, you can create a template as follows:

* Add new table to existing report or build it as a new report
* Fetch all job positions from the hr.job model
* To get count of employees in this position you can utilize the employee_ids field in the hr.job model




Thanks

Avatar
Descartar

<templates>
<t t-set="jobs" t-value="request.env['hr.job'].search([])"/>
<t t-name="job_table">
<table class="table table-condensed">
<thead>
<tr>
<th>Job</th>
<th>Count</th>
</tr>
</thead>
<tbody>
<t t-foreach="jobs" t-as="job">
<tr>
<td><t t-esc="job.name"/></td>
<td><t t-esc="len(job.employee_ids)"/></td>
</tr>
</t>
</tbody>
</table>
</t>
</templates>

Autor

Hi Niyas. Thankyou for the answer but it shows all positions while the report I am working on is only showing some selected employee with their job position

depending on how employees are filtered/selected in other section of the report, you need to filter here also

Related Posts Respostes Vistes Activitat
1
d’abr. 25
3819
2
de jul. 20
3680
1
d’abr. 25
1170
2
de març 25
1284
4
de nov. 24
7034