Queries: Query Dates
Query Dates report elements let you report query activity by date. You can also use this information to calculate how long queries have been in a particular state.
| Report element | Description |
|---|---|
| Query Status Date |
Data type: Date Description: The date when a query was assigned its current status in the Oracle InForm application. Date type: System date (GMT). |
| First Candidate Date |
Data type: Date Description: The date when the query was first issued a Candidate status. Date type: System date (GMT). |
| Last Candidate Date |
Data type: Date Description: The date when the query was last issued a Candidate status. Date type: System date (GMT). |
| Opened Date |
Data type: Date Description: The date when the query was first opened in the Oracle InForm application. Date type: System date (GMT). |
| First Reissued Date |
Data type: Date Description: The date when the query was first reissued. Date type: System date (GMT). |
| Last Reissued Date |
Data type: Date Description: The date when the query was last reissued. Date type: System date (GMT). |
| First Answered Date |
Data type: Date Description: The date when the query was first answered. Date type: System date (GMT). |
| Last Answered Date |
Data type: Date Description: The date when the query was last answered. Date type: System date (GMT). |
| Closed Date |
Data type: Date Description: The date when the query was closed. Date type: System date (GMT). |
Parent topic: Query report elements