This method exposes a DataSet instead of a PageDataCollection. This method can return a DataSet in two formats, depending on whether the pivotData parameter is set to true or false. If set to false, then a single table is returned:
Column Name
|
Description
|
oneHopTopicId
|
The TMCore ID of the page topic found by traversing the first association.
|
oneHopPageId
|
The EPiServer Page ID of the page found by traversing the first association.
|
assoc1IsPublished
|
Set to true if the first association traversed is published
|
assoc1IsDeleted
|
Set to true if the first association traversed is deleted
|
oneHopPageLinkURL (optional)
|
The URL of the page found by traversing the first association.
|
oneHopPageName (optional)
|
The name of the page found by traversing the first association.
|
twoHopTopicId
|
The TMCore ID of the page topic found by traversing the second association.
|
twoHopPageId
|
The EPiServer Page ID of the page found by traversing the second association.
|
assoc2IsPublished
|
Set to true if the second association traversed is published
|
assoc2IsDeleted
|
Set to true if the second association traversed is deleted
|
twoHopPageLinkURL (optional)
|
The URL of the page found by traversing the second association.
|
twoHopPageName (optional)
|
The name of the page found by traversing the second association.
|
DataSet table schema returned by GetRelatedDataByTwoHop when pivotData==false
Columns marked as (optional) are only included if the addPageLinkAndName parameter is set to true. Note that in this results set there is one row for each topic found by traversing the second association.
The second data set is more useful for binding to sets of nested templated data bound ASP.NET controls, that splits the data in to two sets using a relation to link them. The first data set contains one row for each page topic found by traversing the first association (this is referred to as the "parent"), the second contains a "child" row for each page found as a result of traversing the second association from an instance of the parent.
Column Name
|
Description
|
id
|
The ID of this parent. This is the primary key of the table.
|
oneHopTopicId
|
The TMCore ID of the page topic found by traversing the first association.
|
oneHopPageId
|
The EPiServer Page ID of the page found by traversing the first association.
|
assoc1IsPublished
|
Set to true if the first association traversed is published
|
assoc1IsDeleted
|
Set to true if the first association traversed is deleted
|
oneHopPageLinkURL (optional)
|
The URL of the page found by traversing the first association.
|
oneHopPageName (optional)
|
The name of the page found by traversing the first association.
|
Parent dataset table schema returned by GetRelatedDataByTwoHop when pivotData==true
Column Name
|
Description
|
id
|
The ID of the parent that this row relates to.
|
twoHopTopicId
|
The TMCore ID of the page topic found by traversing the second association.
|
twoHopPageId
|
The EPiServer Page ID of the page found by traversing the second association.
|
assoc2IsPublished
|
Set to true if the second association traversed is published
|
assoc2IsDeleted
|
Set to true if the second association traversed is deleted
|
twoHopPageLinkURL (optional)
|
The URL of the page found by traversing the second association.
|
twoHopPageName (optional)
|
The name of the page found by traversing the second association.
|
Child dataset table schema returned by GetRelatedDataByTwoHop when pivotData==true
|