Dimension Tags

Purpose

The tags and tag_associations tables store the filter tags for both chart_master (GL Accounts) and dimensions table records. Field tags.type = 2 for dimensions table records.

Procedure

Dimensions -> Dimension Tags

Tips and Tricks

ERD Diagram

SQL of View

# DIMENSION Tag View

SELECT
    tags.name AS tag_name
    , description
    , tags.inactive AS tag_inactive
    , dimensions.id
    , reference
    , dimensions.name
    , dimensions.type_
    , closed
    , date_
    , due_date
FROM
    0_tags AS tags
    INNER JOIN 0_tag_associations 
        ON (tags.id = tag_id)
    INNER JOIN 0_dimensions AS dimensions
        ON (record_id = dimensions.id)
WHERE (tags.type = 2);