VERIFIED SOLUTION i

Understanding Enquiry dates in Confirm

Products affected: Confirm®
Product feature: Customer Services / Enquiries
The 'Logged' field on the Enquiry form below, highlighted in red, is an non-editable field and auto-generated by the system at the time of saving the record, initially, on the Enquiry screen. At database level the data is stored in a field named customer_time in the enquiry_customer table. The customer_time gets saved when either a new customer is added to a) any existing Enquiry or b) a new Enquiry.

The 'Logged' field on the Enquiry form below, highlighted in blue, is another non-editable field and auto-generated by the system. At database level the data is stored in a field named enquiry_time in the central_enquiry table. It is enquiry_time that gets set when the enquiry lands in the system. 

Customer Enquiry form

At database level there is also a field named logged_date in the central_enquiry table. This is the current Status's logged date and used internally. This date can be seen on the Status Log screen.

On the Enquiry filter screen we see the fields 'Logged from' and 'to' in the bottom half of the  form (below, highlighted in green).

Enquiry Filter form

These fields limit upon the enquiry_time column in the central_enquiry table. You can see this by performing the filter using those From and To fields then, when you're back on the Customer Enquiry form with the results set, you can do Edit > Copy SQL. Paste into a text editor and we can see the exact query that's been used, for example in the WHERE clause:

central_enquiry.enquiry_time >= TO_DATE('2018-04-01 00:00:00','yyyy-mm-dd hh24:mi:ss') AND central_enquiry.enquiry_time <= TO_DATE('2018-04-10 23:59:59','yyyy-mm-dd hh24:mi:ss')
UPDATED:  February 13, 2019