GetRelatedDataByTwoHop

Top  Previous  Next

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