A query line can be one of three types: DataItem, column, and filter. Each has its own property set:
Again, we'll review a selected subset of these properties:
- SqlJoinType: If enabled by the DataItemLinkType property, this property allows the specification of one of five different SQL join types (inner, left outer, right outer, full outer, or cross join). More information is available in the Help sections. Look for the SqlJoinType property and SQL Advanced Options for Data Item Link Types.
- DataItemTableFilter: This provides the ability to define filters that will be applied to the DataItem.