Skip to Content
Menu
This question has been flagged
3 Replies
1346 Views

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.

Avatar
Discard
Author Best Answer

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' 

 

Avatar
Discard
Best Answer

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

Avatar
Discard
Best Answer

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 )

Avatar
Discard
Related Posts Replies Views Activity
3
Sep 22
6008
1
Aug 22
3641
5
Feb 20
10858
2
Feb 19
2169
0
Feb 19
3226