PivotCustomFieldSortEventArgs.ListSourceRowIndex1 Property

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

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v19.1.dll

Declaration

C#

public int ListSourceRowIndex1 { get; }

VB.NET

Public ReadOnly Property ListSourceRowIndex1 As Integer

Property Value

Type	Description
Int32	An integer value that is the row index in the data source.

Remarks

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

The ListSourceRowIndex1 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.Value1 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 ListSourceRowIndex1 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#L44

{
    object orderValue1 = e.GetListSourceColumnValue(e.ListSourceRowIndex1, "SalesPersonId"),
        orderValue2 = e.GetListSourceColumnValue(e.ListSourceRowIndex2, "SalesPersonId");

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)