Skip to main content

IMPORTANT - Product End of Life Statement - IMPORTANT

Request RE, Survey, and Calendar 1.5 Support Ending December 31, 2020
Contact Kinetic Data Support with Questions
Kinetic Community

Aging Report - Kinetic Request CE

  1. Last updated
  2. Save as PDF
  1. Overview
  2. Action Enabled
  3. Sample Report
  4. Report Definition
    1. Database Table:  
    2. Search Criteria:  
    3. Fields Displayed:  
    4. Calculated Fields:
  5.  
  6. Related

Overview

The Aging report will show a listing of all Submissions that are in an "Open" Status and display Confirmation Number, Form Name, Status, Age, Create Date, and Updated Date.

Action Enabled

The action enabled by this report will allow you to apply more resources to the "Old" submissions.

Sample Report

 

Report Definition

Database Table:  

services

Search Criteria:  

'l_Status' = "Draft" or 'l_Status' = "In Progress" or 'l_Status' = "Pending Approval"

Fields Displayed:  

Form - c_formSlug 

Status - l_Status

Submitted - c_submittedAt

Updated - c_updatedAt

Calculated Fields:

Confirmation # - To display the Confirmation # I built a Calculated Field to display the last six characters of the c_id field:

Age (Days) - To display the Age (Days) I built a Calculated Field to display the difference between the current date and the c_submittedAt date:

 

Related

Topics
Kinetic Survey Customer Survey ER Diagram
An ER Diagram of the Kientic Survey submitted survey.
Kinetic Survey Template ER Diagram
An ER Diagram of Kinetic Survey.
Hitchhiker's Guide to the Request Data Galaxy
Kinetic Request: the final frontier. These are the voyages of the Kinetic Request data. Your mission: to explore strange new databases, to seek out new data and new information, to boldly build reports that no one has seen before.
Reporting with Kinetic Request CE
Reporting
This document will discuss Reporting in the Kinetic Request and Task Applications.  Below you will find information discussing Why Reports are Needed, the Out of the Box Reports, and also how you can Build your own Custom Reports.
Kinetic Request Customer Submission ER Diagram
An ER Diagram of the Kinetic Request Submission process
Kinetic Request Service Item ER Diagram
An ER Diagram of Kinetic Request
Business Objects Universe - Kinetic Request and Task
This page will help you determine which Kinetic Request and Kinetic Task forms can be used to build your Business Objects Universe.
Power Reporting With Kinetic Request And Kinetic Survey
Other