You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Field: OrderNumber

Description

OrderNumber is a reference field for all entities and relates to the automatically assigned "order" number of the entity with in the tree view navigator.

Examples

Find everything with an Order Number equal to 100 (this would mean they are the 100th item in-order within the parent package/tree node:

OrderNumber = 100

Normally you would not query the OrderNumber directly, but use it sort results so they follow the same order as the tree - for instance when you are exporting them to CSV:

ORDER BY OrderNumber ASC

Supported Operators

=, <, >, <=, >=, IN, !=, NOT IN

Supported Indexes

Entity, Package

Supported Types

  • AgileRun
  • AutomatedTest
  • AutomatedTestAssignment
  • Requirement
  • RequirementPackage
  • TestExecutionPackage
  • TestScript
  • TestScriptAssignment
  • TestScriptPackage

Supported Features

FeatureSupported?
AggregationYes (Int32)
SortableYes
Sub-selectsNo

  • No labels