Requests (Collection)

Member of:

QuerySection object

Description:

Represents all topic items on the request line.

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 remove all request line items and add items based on topics queries:

with(ActiveDocument.Sections["Query"])
            {
            Requests.RemoveAll()
            for (I = 1; I <= DataModel.Topics[1].TopicItems.Count; I++)
                       {
                       TopicName = Topics[1].Name
                       TopicItemName = Topics[1].TopicItems[I].DisplayName
                       Requests.Add(TopicName,TopicItemName)
                     }
           }

Methods:

Add(TopicName As String, TopicItemName As String) As Request, AddComputedItem(Name As String, Expression As String, Type As BqDataType) As Request, Item(NameOrIndex) As Request, RemoveAll()

Properties:

Read-only: Property Count As Number