Joining Tables on Specific Values

Add joins to pre-defined values directly in the Data Model Designer by right-clicking on any Tables/Views and selecting Joins on specific values.

Example

Here, a join between the ITMMASTER table and the ATEXTRA table for a field and four specific values.

The specific values can be input manually or based on a Global Parameter that is dynamic or on two specific values:

##CurrentLang (will be replaced by the current languages of the user, this will allow the content of the data to be multi-lingual)
##CurrentUser (will be replaced by the current user)
Note
No quotes are required around these ## specific values when using them within the Specific value for joins window shown above. They will be required in other areas, like when using them to define a Global Variable (Administration > Global Variables), or when using them in the WHERE clause window of a Data Model Designer.