ArcGIS Pro 3.4 API Reference Guide
ArcGIS.Core.Data Namespace / QueryFilter Class / Offset Property
Example

In This Topic
    Offset Property (QueryFilter)
    In This Topic
    Gets or sets the positional offset returned by the query.
    Syntax
    public int Offset {get; set;}
    Public Property Offset As Integer
    Remarks
    Some datastores support pagination only through an SQL postfix clause; in these cases, the PostfixClause property should be used in conjunction with Offset.
    Example
    Pagination in QueryFilter
    public void QueryFilterWithPagination(Table table, List<long> objectIDs)
    {
        int rowsPerBatch = 100;
        int offset = 0;
    
        // Query filter
        // Some datastores support pagination only through an SQL postfix clause
        QueryFilter queryFilter = new QueryFilter()
        {
            ObjectIDs = objectIDs,
            PostfixClause = "ORDER BY OBJECTID"
        };
    
        // Fetch rows in a batch from a table
        for (int index = offset; index <= objectIDs.Count; index += rowsPerBatch)
        {
            // Set number of rows to return from a table
            queryFilter.RowCount = rowsPerBatch;
    
            // Set positional offset to skip number of rows from a table 
            queryFilter.Offset = index;
    
            using (RowCursor cursor = table.Search(queryFilter))
            {
                while (cursor.MoveNext())
                {
                    using (Row row = cursor.Current)
                    {
                        Console.WriteLine(row.GetObjectID());
                    }
                }
            }
        }
    }
    
    Requirements

    Target Platforms: Windows 11, Windows 10

    ArcGIS Pro version: 3.3 or higher.
    See Also