New Topic

Community Topic Question System Configuration

Category System Configuration

Product Version 9.0

Job Title/Description Location in Config Database

Lex Clay shared this question 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

The same question

Replies (1)

Mike Sheehan ●

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

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

Reply URL

Lex Clay ●

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

Cheers Mike

URL

Mike Sheehan ●

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

URL