Create Outer Join Filters

When you create an outer join, you can add join filters to filter the data returned from the secondary table without filtering the data from the primary table.

Join filters are similar to segment filters in that they limit the records that can be returned by the report, but they apply to the table join rather than to the data returned by the query on the database.

1. Select a joined table in the data set tree.
2. Select Outer as the join type.
   The Join Filters heading displays.
3. Expand the Join Filters heading on the Edit Data Set window.
   The Edit Data Set window displays the Join Filters section.
4. Click Add Filter.
   The Add Filter window opens.
5. Enter field information.

   Add Filter Window

   Field	Description
   Name	Enter the name of the filter. If you leave this field blank, the database name displays.
   *Expression	Enter the expression you want to use to limit the data set in this field. The syntax is <table_name>.<column_name>. As you type an entry in the Expression field, a drop-down list displays a list of database tables that begin with the letters you type. You can enter the complete expression or select a table and field from the drop-down list. You can also select a table and column or function by right-clicking in the field. Tip: If you drag and drop a column name from the Fields section, the field contains the table and column name.
   Operator	Select the operator to use in comparing the expression to the value. The available operators vary depending on the expression.
   Value Type	Select the type of value to match with the expression from these options.
   Constant	Select this option to enter the value to complete the filter or select the value from a drop-down list or calendar (depending on the expression).
   Expression	Select this option to enter an expression to complete the filter, using the syntax <table_name>.<column_name>.
   Value	Enter the value that the expression is compared to. The available options in the Value field change depending on the type of field, the operator you select, and the value type. For example, when the field type is menu, you select it from a drop-down list, but when the field type is date, you select if from a calendar.

6. Click OK.
   The Edit Data Set window is updated to display the filter, along with additional actions.

   The additional actions that become available are identical to those used when creating logical expressions for segment filters. These actions let you edit your filter, create additional filters, add OR logic to the join filters, negate filters, and view a text definition of the join filter logical expression. For procedures on using these actions, see Edit a Logical Expression.