Fullscreen Image

Report on User Defined Fields

If you want to run a report on the UDF labels that are currently in the TMS database, you can do so by building a SQL query that utilizes the vTMSUserDefinedFieldPropertiesReporting view.

This topic is only for advanced TMS users who are comfortable with working directly in SQL code.

  1. In Datasource Edit, select the Data Source Editor tab.

  2. Select the SQL sub tab.

  3. Click the Override SQL button.

  4. Click Yes in the warning pop-up window.

  5. Build your SQL query.

You can use these fields in your SELECT statement:

  • IDSegment

  • IDSection

  • ModuleID

  • IDType

  • IDCategory

  • IDSubCategory

  • IDSafetyDiscipline

  • IDSafetyProblem

  • UserLabel1

  • UserLabel2

  • UserLabel3

  • UserLabel4

  • UserLabel5

  • UserLabel6

  • UserLabel7

  • UserLabel8

  • UserLabel9

  • UserLabel10