Job Title/Description Location in Config Database

Lex Clay shared this question 2 months ago
Answered

Hi Fishies,

Not really system configuration but that's the closest category I could see...

Can anyone tell me where I can get a user's Job Title & Description from?

It's not included in the AdministrationPerson object & for the life of me I can't find it in the config database. I'm guessing it's a description or value field... ?


Many thanks


Lex

Comments (1)

photo
1

Hi Lex,

Thanks for reaching out. This information is contained in the 'PersonConfiguration' table.

My user:

/7dfce3ce80b31827040af267f441285c

Two queries that will return these results:

SELECT * FROM personconfiguration WHERE IpPerson = '5' AND ConfigCode = 'JOBTITLE';

(The IpPerson value is pulled from the IpId for the corresponding user in IpClass table, for the record.)

/3b84043e5581653698c630f9a43e209b

And for the description:

SELECT * FROM personconfiguration WHERE IpPerson = '5'AND ConfigCode = 'USERDESCRIPTION';

/8b82868958b2abe05a4e9d1ddf35d465

Hopefully this gives you what you need, but please let me know if you have any follow-up questions!

Regards,

Mike

photo
1

Christ that's embarrassing, I've only been looking through that table for the last hour.

Cheers Mike

photo
1

Hi Lex,

Haha, no problem. Happens to all of us!

Considering it seems this is sorted, I'll go ahead and close this out new then, but please don't hesitate to reach out with any other questions or concerns.

Regards,

Mike

photo