Considerations for Using Pass-Through SQL

When you use pass-through SQL, you must use the database names for fields. The names must be entered in upper-case letters. The schema of system tables is documented. SBM uses standard names for system fields. The following table shows the common system fields that are available in tables, depending upon how your system administrator set up your tables, the corresponding database names, and the field type. Your administrator may elect not to include these fields.

System Field	Database Name	Type
Active/Inactive	TS_ACTIVEINACTIVE	Integer
Close Date/Time*	TS_CLOSEDATE	Date***
Description	TS_DESCRIPTION	Text
Item ID	TS_ISSUEID	Text
Item Title/Name	TS_TITLE	Text
Item Type	TS_ISSUETYPE	Integer
Last Modified Date	TS_LASTMODIFIEDDATE	Date***
Last Modifier	TS_LASTMODIFIER	Integer**
Last State Change Date*	TS_LASTSTATECHANGEDATE	Date***
Last State Changer*	TS_LASTSTATECHANGER	Integer**
Owner*	TS_OWNER	Integer**
Project*	TS_PROJECTID	Integer**
State*	TS_STATE	Integer**
Submit Date/Time	TS_SUBMITDATE	Date***
Submitter	TS_SUBMITTER	Integer**

* Fields found only in primary tables

** Fields that are foreign keys and can be joined to other tables

*** For Oracle, the date data type is 'DATE'; for SQL Server, it is 'datetime'.

Considerations for Using Pass-Through SQL

Related Topics