Using conditional joins, you can establish joins based on conditions other than equality between fields. In addition, the host and cross-referenced join fields do not have to contain matching formats, and the cross-referenced field does not have to be indexed.
The conditional join is supported for FOCUS and all relational data adapters. Because each data source differs in its ability to handle complex conditional criteria, the optimization of the WHERE syntax differs depending on the specific data sources involved in the join and the complexity of the conditional criteria.
Joining Tables
| Note |
|---|
|
You can edit the description of a join by clicking Edit in the Join dialog box and typing in the Description section. You can only use letters, numbers, and underscores in your description. No special characters are allowed. |
Related Articles
| Filter by label (Content by label) |
|---|
| showLabels | false |
|---|
| max | 5 |
|---|
| spaces | IKB |
|---|
| showSpace | false |
|---|
| sort | modified |
|---|
| reverse | true |
|---|
| type | page |
|---|
| cql | label = "kb-how-to-article" and type = "page" and space = "IKB" |
|---|
| labels | kb-how-to-article |
|---|
|
...