Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

in which table user name go to store in openerp 7 [Closed]

By
gpkarthick
on 5/7/13, 8:27 AM 5,084 views

The Question has been closed

by
Sudhir Arya (SA)
on 02/07/2014 23:51:50

in which table user name go to store in openerp 7

0

Martin

--Martin--
1978
| 5 6 8
Cornwall, Canada
--Martin--

Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com

Martin
On 5/7/13, 10:10 AM
01_test=> select u.id, u.login, u.signature, p.name, p.id 
            from res_users u, res_partner p
           where u.login = 'leow' 
             and p.id = u.partner_id;
 id | login |    signature    |    name    | id 
----+-------+-----------------+------------+----
  4 | leow  | Leonardo Wilder | Leo Wilder | 59
(1 row)

good answer thank you very much

gpkarthick
on 5/8/13, 1:34 AM
1

Sudhir Arya (SA)

--Sudhir Arya (SA)--
10150
| 6 8 8
Ahmedabad, India
--Sudhir Arya (SA)--

Working as an OpenERP/Odoo developer and a Team Leader 

Top 5 Odoo contributor On Stackoverflow

LinkedIn

Blog

Stackoverflow

Sudhir Arya (SA)
On 5/7/13, 8:32 AM

Object name is res.users and table name is res_users and field name is login that is used as user name.

res.users inherits res.partner so name field is used from res.partner. Thus you cannot see name field in res.users table.

name is not going to store in that table there is a login field it's only having a char value

gpkarthick
on 5/7/13, 8:40 AM

Yes, user name and password are store in this table. That login is used as user name.

Sudhir Arya (SA)
on 5/7/13, 8:43 AM

in res_users from there is field (Name,Login) -->login field there in table then where is the name field going

gpkarthick
on 5/7/13, 8:52 AM

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

Asked: 5/7/13, 8:27 AM
Seen: 5084 times
Last updated: 3/16/15, 8:10 AM