The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Newbie Question of TICKETS Schema 
Posted: 21 Jun 10 9:38 AM
|
Having just started to work with Saleslogix I have a quick question on the schema. I'm trying to track down the relation of the 'assigned to' field in the TICKETS table as I need to pull out the current assigned users ID for open tickets.
I assume that there is a link between the USERINFO tabel and TICKETS table but expect there to be table(s) inbetween.
Sorry if this is a simple question !!!!
Thanks in advance |
|
|
|
Re: Newbie Question of TICKETS Schema
Posted: 21 Jun 10 9:44 AM
|
Tickets get assigned to "Owners". In other word, it could be a "User" or a Team.
Because of this, the ID that gets stored on it is a SECCODEID. You need to look at the Seccode Table.
If it is assigned to a Team, then you would get the selected users from the SecRights table.
If it is assigned to a single user, then you could get the user via the USERSECURITY table (DEFAULTSECCODEID) field. |
|
|
| |
| |
|