Auto populating existing user in a field while creating new user

[Vaibhav_Dubey]

Hello, 

While creating new user, my requirement is When I select ERP-Number, The Legal Entity(organisation) and Responsible Person gets auto-populated. 

ERPno -> Legal Entity is working, now I want the Primary contact/Org owner to be auto filled as well.

I need SQL queries for two possible scenarios : 

1. Primary contact of the organisation gets populated in the Responsible person field.
2. Organisation owner gets populated in the Responsible person field.

[NM]

Hi @Vaibhav_Dubey how are the linked??

How to check if org should user point to?

[Vaibhav_Dubey]

I want the "Responsible person" field to be populated based on the organisation owner of the "Legal Entity" field or the primary contact of the organisation. 

I need sql queries for both the scenarios, how i can populated the "responsible person" field 

I cant seem to find the column in the database containing Org owner or primary contact of the org. 

[rushikeshvartak]

•  primary contact of the org.  : select u.username as id from customer_history ch,users u where ch.customerkey=1 and ch.versionstatus=2 and ch.PRIMARYVENDORCONTACT =u.userkey

[Vaibhav_Dubey]

There is no customer_history table in my database

[rushikeshvartak]

Check from analytics 

Data analyzer does not expose all tables

[Vaibhav_Dubey]

I tried and its not working 
Query I used : select u.username as id from customer_history ch,users u where ch.customerkey=9 and ch.versionstatus=2 and ch.PRIMARYVENDORCONTACT =u.userkey

My organisation with customerkey 9 has a primary contact in place but its not showing here 

[rushikeshvartak]

: select ch.PRIMARYVENDORCONTACT   from customer_history ch where ch.customerkey=9

[Vaibhav_Dubey]

[rushikeshvartak]

Check logs