Dataview - Edit Join Fields
Here is a description of the interface elements on the Dataview - Edit Join popup. This popup is displayed when you click the 
icon on a relationship join on the Joins tab of the Dataview Editor. You can apply a filter to a relationship join so that a subset of data is retrieved from the joined object.
The following fields are read-only.
| Field | Description |
|---|---|
| Join To | The joined object. This is the object to which the filter is being applied. |
| Join Name | The join name. |
Building the Filter
The filter is displayed graphically as an expression and always starts with an AND container. Drag the Field icon and drop it within the AND container (inside the area marked as the drop zone), then click the pencil icon to display the Filter Criteria popup where you define the details to use.
Filter Criteria
| Field | Description |
|---|---|
| Field | The field that you want to use. Only fields that belong to the joined object and have been added to the dataview are available. |
| Operator | The operator that you want to use. For example, with numeric fields you might want to use "=" or "In Range", whereas with text fields you might want to use "Starts With" or "Contains". If the field is a Salesforce Record ID the operator can only be "=" or "<>". |
| Value | The value that you want to use. If the operator is "In Range" or "Not in Range", you need to enter From and To values. If the value is a date, you can enter either an explicit date (hard date) or an offset of the current date (soft date Salesforce refers to soft dates as "relative date values". Accounting supports the following relative date values: Today, Tomorrow, Yesterday, Last "n" Days, Next "n" Days, This Week, Last Week, Next Week, This Year, Last Year, Next Year. See the Salesforce Help for details of how these relative date values are resolved.
Note that Last "n" Days and Next "n" Days are ranges. For example if today is May 25 then Last 3 Days is from May 23 to May 25. A filter on transaction date of "< Last 3 days" would retrieve transactions dated prior to May 23.). The value can only be left blank when the operator is "=" or "<>". |
| Prompt | Prompts at runtime to allow you to change the value and the operator. See Filter Statements |
You can add multiple AND and OR containers to build a more complex filter.
You can remove criteria and containers from the filter by clicking their 
symbol. You can also rearrange containers and criteria by dragging and dropping them within the filter.