Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
2 Replies
1656 Tampilan

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
Buang
Jawaban Terbai

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
Buang
Penulis

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

Jawaban Terbai

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
Buang

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

Penulis

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

Post Terkait Replies Tampilan Aktivitas
1
Apr 25
3835
2
Jul 20
3690
1
Apr 25
1188
2
Mar 25
1321
4
Nov 24
7047