PivotCustomFieldSortEventArgs.ListSourceRowIndex2 Property

Gets the index in the data source of the second of the two rows being compared.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v20.2.dll

NuGet Packages: DevExpress.WindowsDesktop.Wpf.PivotGrid, DevExpress.Wpf.PivotGrid

Declaration

C#

public int ListSourceRowIndex2 { get; }

VB.NET

Public ReadOnly Property ListSourceRowIndex2 As Integer

Property Value

Type	Description
Int32	An integer value representing the index of the second row in the data source.

Remarks

You can use the ListSourceRowIndex2 property in your sorting algorithm to compare values contained in another column instead of the current column values.

The ListSourceRowIndex2 is the index of the record in the data source that provides data for the current PivotGrid field and whose value for the e.Field.FieldName column equals the PivotCustomFieldSortEventArgs.Value2 value. To get another column’s value, call the e.GetListSourceColumnValue method with the ListSourceRowIndex1 and the column name as the parameters.

Note

When the PivotGridControl.CustomFieldSort event fires for the field values in the Filter Drop-Down, the ListSourceRowIndex1 and ListSourceRowIndex2 properties are always -1.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the ListSourceRowIndex2 property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

wpf-pivotgrid-customfieldsort-example/CS/Wpf-PivotGrid-CustomFieldSort-Example/MainWindow.xaml.cs#L45

object orderValue1 = e.GetListSourceColumnValue(e.ListSourceRowIndex1, "SalesPersonId"),
    orderValue2 = e.GetListSourceColumnValue(e.ListSourceRowIndex2, "SalesPersonId");
result = Comparer.Default.Compare(orderValue1, orderValue2);

VB.NET

wpf-pivotgrid-customfieldsort-example/VB/Wpf-PivotGrid-CustomFieldSort-Example/MainWindow.xaml.vb#L38

If e.SortLocation = FieldSortLocation.Pivot Then
    Dim orderValue1 As Object = e.GetListSourceColumnValue(e.ListSourceRowIndex1, "SalesPersonId"), orderValue2 As Object = e.GetListSourceColumnValue(e.ListSourceRowIndex2, "SalesPersonId")
    result = Comparer.Default.Compare(orderValue1, orderValue2)