ArcGIS Pro 3.7 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 Property Offset As Integer
    public int Offset {get; set;}
    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
    {
      // Must be called within QueuedTask.Run
      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 Home, Pro, Enterprise (64 bit)

    ArcGIS Pro version: 3.3 or higher.
    See Also