Help Contents
-
Getting Started
-
Installation and Upgrade Guide
-
Administrator Guide
-
User Guide
-
Duette User Guide
-
Searching & TQL
-
Simple Search
-
Advanced Search
-
Testing Query Language (TQL)
-
Aggregation
-
Fields
-
Accumulated Actual Duration
-
Actual Duration
-
Affected Version
-
Agile Runs Count
-
All Packages
-
AllParents
-
Assigned To
-
Assignee
-
Assignment
-
Assignment Id
-
Assignments Count
-
Attachment Count
-
Automated Tests Count
-
Blocked
-
Change Comment
-
Comment
-
Component
-
Created At
-
Created By
-
Description
-
Destination
-
Difficulty
-
Difficulty Level
-
Directly Related To
-
Editor
-
Editors
-
Entity Type
-
Errors
-
Estimated Duration
-
Estimated Less Actual Duration
-
Execution Totals
-
Failed
-
Fields / Organisation
-
Fields / Package
-
Fields / Project
-
Fields / Relationship
-
Fields / Relationships
-
Fields / Relationship Type
-
Fields / Script
-
Finished At
-
Fixed Version
-
Has Agile Runs
-
Has Assignments
-
Has Attachments
-
Has Automated Tests
-
Has Coverage
-
Has Incidents
-
Has Requirements
-
Has Scripts
-
Id
-
Imported At
-
Incident Count
-
In Progress
-
Iterations
-
Key
-
Last Comment
-
Last Synchronized At
-
Last Updated At
-
Last Updated By
-
Name
-
Notes
-
NotRun
-
Number
-
Objective
-
Order Number
-
Parent
-
Parent And This Package
-
Parent Package
-
Passed
-
Post Condition
-
Pre Condition
-
Priority
-
Provides Coverage
-
Query
-
Raised By
-
Related To
-
Related To All Packages
-
Related To All Parents
-
Related To Entity Type
-
Related To Fields
-
Related To Id
-
Related To Organisation
-
Related To Package
-
Related To Parent
-
Related To Priority
-
Related To Project
-
Related To Status
-
Related To Type
-
Relationship Depth
-
Relationship Direction
-
Relationship Id
-
RelationshipTypeKey
-
Remaining Estimate
-
Requirements Count
-
Resolution
-
Run By
-
Run Number
-
Script Id
-
Script Priority
-
Script Status
-
Script Step Count
-
Script Type
-
Skipped
-
Source
-
Started At
-
Status
-
Step Actual Results
-
Step Data
-
Step Description
-
Step Expected Result
-
Step Notes
-
Summary
-
Test
-
Test Id
-
Test Scripts Count
-
Text
-
Ticket Id
-
Ticket Key
-
Ticket Url
-
Total Nodes
-
Total Results
-
Tracker
-
Type
-
Undetermined
-
Version Number
-
Warnings
-
Accumulated Actual Duration
-
Functions
-
Indexes
-
Operators
-
Order By
-
SET
-
TQL For JQL Users
-
Types
-
Values
-
Aggregation
-
Simple Search
-
API
-
Troubleshooting
-
Latest Version of this Documentation
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
Supported Types
- AgileRun
- AutomatedTest
- AutomatedTestAssignment
- Requirement
- RequirementPackage
- TestExecutionPackage
- TestScript
- TestScriptAssignment
- TestScriptPackage
Supported Features
Feature | Supported? |
---|---|
Aggregation | Yes (Int32) |
Sortable | Yes |
Sub-selects | No |