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:
| Code Block |
|---|
|
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:
| Code Block |
|---|
|
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
| Feature | Supported? |
|---|
| Aggregation | Yes (Int32) |
| Sortable | Yes |
| Sub-selects | No |