JoinOptions (Collection)

Member of:

DataModel object

Description:

Represents the available join usage preferences.

Constants:

The Type property of the JoinsOptions (Collection) uses the BqDataModelJoinsOptions constant group, which consists of these values:·

bqDataModelJoinsOptionAllTopics (= 0, Read-only)
bqDataModelJoinsOptionAutoJoin (= 4, Read-only)
bqDataModelJoinsOptionDefJoin (=3, Read-only)
bqDataModelJoinsOptionMinTopics (=1, Read-only)

bqDataModelJoinsOptionRefTopics (=2, Read-only)

Note:

If you choose to define your own joins paths by selecting the bqDataModel JoinsOptionDefJoin constant, specify your join preferences using the DefinedJoinPaths (Collection).

Tip:

All collections have the “Item(NameOrIndex)” method. This is the default method for all collections that returns collection items at a particular index or by name. Use brackets ([]) to represent calls to the Item (Method). For example, these statements are identical: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy")

Example:

This example shows how to specify to use only topics represented by items on the Request line for joins:

ActiveDocument.Sections["Query"].DataModel.JoinsOptions.Type= bqDataModelJoinsOptionMinTopics

Methods:

None

Properties:

Read-write: Property Type As BqDataModelJoinsOptions

Collections:

DefinedJoinPaths As DefinedJoinedPaths