Join (Object)

Member of:

DataModel object

Description:

Represents a join between topics in a Data Model.

Example:

This example shows how to change the type of join to a left join and print the names of the joined topic items to the Console window:

ActiveDocument.Sections["Query"].DataModel.Joins[1].Type = bqJoinLeft
Console.Writeln(ActiveDocument.Sections["Query"].DataModel.Joins[1].TopicItem1.DisplayName="Sales")
Console.Writeln(ActiveDocument.Sections["Query"].DataModel.Joins[1].TopicItem2.PhysicalName)

Console Output:

WineId

WineId

Methods:

Remove()

Properties:

Read Only: Topic1Name, Topic2Name

Read-write: Type as BqJoinType

Objects:

TopicItem1, TopicItem2