HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

How does the application store user assignments in the database?


Continuing the discussion from How does helpspot store category assingnments in the database:

Based on the question asked in the linked topic, I am having a similar issue trying to understand how the application determines what is an active user to a category.


You’re trying to understand where it is in the database or in the UI? You define who is part of each category on the category screen in Admin-Categories. That will then control who is available when you select a category on the request screen.


I’m trying to understand how it works in the database. I see that it is held in HS_Category.sPersonList in the database, but like the linked topic, I’m confused on how it determines who is the active user for that category.