This article covers some common questions we have received historically relating to Private Cloud customers who can query their database directly. In this article we cover general and a few specific items/tables that we have been asked about more commonly than others.
This article will serve to assist organizations who wish to start querying their private cloud database for extended reporting scenarios. The following information is useful to keep in mind for all query situations.
This is the table containing all of the custom fields that have been defined. This would include the name of the custom field, whether it was marked as required, its data type (e.g. date/time, dropdown, etc.), and other important metadata about the field.
This is the table containing the custom fields information that is associated with a work item. In other words, this table will indicate that ticket 12345 has “Blue” selected for the Eye Color attribute. This may require joining from AttributeValues to AttributeChoices on choice ID to get the choice name.
This is the table containing replies to top-level feed items in the system.
This is the table containing each top-level feed item (not feed item replies) in the system.
This is the table containing each project, project request, and workspace record in the system.
This is the table containing each ticket record in the system. This table also contains "backing" records for ticket templates.
This is the table containing information about user records. This covers all types of user records (ex: users, customers, service accounts, etc.).