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'.

Related Topics

About Pass-Through SQL

Examples of SBM Pass-Through SQL

Examples of Using Joins in Pass-Through SQL

Common SQL Operators