Where is 'Username' for a person saved in the database?

lock
push_pin
done
Besvart
4

Hi all.

Maybe I'm just blind, but I have no idea where to find 'username' for a given person in SuperOffice, once they have logged into CC.

Does anyone know where to look? :)

12. mar. 2025 | 03:28 p.m.

Alle Svar (4)

Hi Kasper

You are probably looking for the assiciate.name

associate Table (2)

12. mar. 2025 | 04:17 p.m.

Hi Georg.

I dont think they are saved there, since this is only (as I know) users of SuperOffice.

Im talking about regular people login into CC - they get a username. In the new service it is found under Task -> Manage Customer Center User.

 

12. mar. 2025 | 04:25 p.m.

I overlooked your reference to CC 

You find that name in crm7.USER_CANDIDATE.secret_key where person_id = your_person_id
https://docs.superoffice.com/en/database/tables/user-candidate.html

 

12. mar. 2025 | 05:09 p.m.
Thank you Georg. I would never has guessed this location. Weird to call username 'secret_key'.
12. mar. 2025 | 05:46 p.m.

Legg til svar