Where is the Organization's Primary Contact stored in the database?

JDeTeves

I'm doing some custom integrations and I need to pull the Organization's Primary Contact from the MySQL database.

Unfortunately I have not been able to find this information even doing a full text search on every single table.

Where is this data stored?

KevinTheJedi

JDeTeves

Jared hasn’t worked here in ages and Peter doesn’t get on the forum. Please don’t tag them.

As for your question it is a flag set in the flags column of the user table. See here:

https://github.com/osTicket/osTicket/blob/develop/include/class.user.php#L184-L189

Cheers.

JDeTeves

KevinTheJedi Thanks for letting me know - they've helped me a few times, I didn't know they weren't active anymore (Peter as I understand it is doing CEO things now - good for him, can't wait for the 2.0 release). I was looking to tag a developer since they would know the database inside and out.

I see you updated your post re: the flags! Thanks, I was about to say, the Managers Column is empty (and only gets populated if I add an Agent as a manger).

The flag does appear to be the missing puzzle piece.

Thank you Kevin,