LocalResultsTopicItems (Collection)

Member of:

LocalResults object

Description:

Enables you to use local results topic items in joins and in the Request line for processing results sets.

Example 1:

This example removes a single local results topic and gets the topic item count of the Results2 local topic:

ActiveDocument.Sections["Query"].DataModel.LocalResults["Results2"].Remove()
ActiveDocument.Sections["Query"].DataModel.LocalResults["Results2"].
LocalResultsTopicItems.Count

Example 2:

This example adds a join between a topic and a local results topic:

Topic1=ActiveDocument.Sections["Query"].DataModel.LocalResults["Sales Fact"]. LocalResultTopicItems.Item("Store Id")
Topic2=ActiveDocument.Sections["Query"].DataModel.Results["Results2"].TopicItems.Item("Store Id")
ActiveDocument.Sections["Query"].DataModel.LocalJoins.Add(Topic1,Topic2, bqJoinLeft)

Methods:

Item()

Properties:

Read-only: Count as Number