hi am in multi company odoo accounting in v.11 i have 13 company each company have user a i want to know how i can know the connected user in datatbase , i need it for a report that i created.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
thanks for your reponse but am using query clause to create report and i want to add consition to get just the connected company because this company get all record
SELECT
code as x_compte , account_move_line.name as x_designation ,account_move_line.debit as x_debit ,account_move_line.credit as x_credit, account_move.narration as x_observation
FROM account_account JOIN account_move_line on account_account.id = account_move_line.account_id
JOIN account_move on account_move_line.move_id = account_move.id
JOIN res_users on account_move_line.company_id = res_users.company_id
JOIN login_detail on login_detail.name = res_users.login
where substring (code,1,1) ='5'
You can get the current user in a variable and print in your report.
current_user_name = self.env.user.name
current_user_id = self.env.user
in your python code you can get active user id :
current_uid = self._context.get('uid')
user_obj = self.env['res.users'].browse(current_uid)
after that you can access the company or companies of that user (user_obj )
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
3
Sep 22
|
6008 | ||
|
1
Aug 22
|
3641 | ||
|
5
Feb 20
|
10858 | ||
|
2
Feb 19
|
2169 | ||
|
0
Feb 19
|
3226 |
try this: https://www.pinterest.com/pin/711005859915282446/