Skip to Content
Menu
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
To pytanie dostało ostrzeżenie
2 Odpowiedzi
1644 Widoki

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!


Awatar
Odrzuć
Najlepsza odpowiedź

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


Awatar
Odrzuć
Autor

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

Najlepsza odpowiedź

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

Awatar
Odrzuć

<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

Powiązane posty Odpowiedzi Widoki Czynność
1
kwi 25
3820
2
lip 20
3681
1
kwi 25
1175
2
mar 25
1289
4
lis 24
7040