DefinedJoinPath (Object)

Member of:

DefineJoinPaths collection

Description:

Contains the customized join preferences that enables Interactive Reporting to include or exclude appropriate tables based on the items referenced on the Request and Limit lines.

Example 1:

This example shows how to select the user-defined join path option, and change a defined join path by adding a join path topic:

ActiveDocument.Sections["Query"].DataModel.JoinsOptions.Type= bqDataModelJoinsOptionDefJoin
ActiveDocument.Sections["Query"].DataModel.JoinsOptions.DefinedJoinPath ["MyJoinPath"].AddTopic("Periods")

Example 2:

This example shows how to select the user defined join path option, create a defined join path, and add all join path topics to the defined join path:

ActiveDocument.Sections["Query"].DataModel.JoinsOptions.Type= bqDataModelJoinsOptionDefJoin
ActiveDocument.Sections["Query"].DataModel.JoinsOptions.DefinedJoinPath.Add("MyJoinPath")
ActiveDocument.Sections["Query"].DataModel.JoinsOptions.DefinedJoinPath["MyJoinPath"].AddAllTopics()

Methods:

AddAllTopics(), AddTopic(DefinedJoinPathsName As String), Remove(), RemoveAllTopics(), RemoveTopic(DefinedJoinPathName As String)

Properties:

Read-write: Name As String