Query Guide: Attributes Table

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.

The Attributes Table contains all of the custom fields that have been defined and the following info about each custom field:

• Name
• Whether it was marked as required
• Data type (e.g. date/time, dropdown, etc.)
• Other important metadata about the field

Query Example

You may use the following example as a starter template.

Select
    Top 10
    att.Att_ID,
    att.Att_Name,
    att.Att_Description,
    att.Att_DateCreated,
    att.Att_DateModified,
    att.Att_IsRequired,
    att.Att_FieldType,
    att.Att_Order,
    att.Att_ClientVisible,
    att.Att_ComponentID,
    cmpnt.CMPNT_Name As ComponentName,
    att.Att_AppID,
    att.Att_IsActive,
    att.Att_IsProtected,
    att.Att_IsUpdatable,
    att.Att_HeaderText,
    att.Att_DataType,
    att.Att_SectionID,
    att.Att_DefaultValue
    /* Add or change selected columns as necessary. */
From
    dbo.Attributes att With (NOLOCK)
    Inner Join dbo.Components cmpnt With (NOLOCK) On att.Att_ComponentID = cmpnt.CMPNT_ID
Where
    att.Att_BEID = @BEID
    /* Use the below line to filter to a specific application (tickets, assets). */
    -- And att.Att_AppID = APPLICATION_ID_HERE
    /* Use the below line to filter for custom fields specific to a component type.
       Refer to the Components table for valid values. For example, use 9 for tickets. */
    -- And att.Att_ComponentID = COMPONENT_ID_HERE