Start a conversation

SQL Report - Count Cancelled Bookings by User

The SQL query below can be used to count how many cancelled bookings exist from a particular date, and give a total per user.


Simply cut/paste the query text below into the SQL tool, and give the query a NAME so that you can save it.

Query Text

SELECT BKNG_BOOK_TYPE, BKNG_CREATED_BY, COUNT(BKNG_UNIQ_ID) as'Qty' FROM BKNGTAB0001
WHERE BKNG_DATE>'2019-06-01' and BKNG_BOOK_TYPE like 'CA%'
GROUP BY BKNG_CREATED_BY


NOTE: The query above assumes that your CANCELLATIONS use a booking type of CAN (or anything else starting CA.... )

When using the query you would need to amend the booking dates shown (e.g. '2019-06-01') to show the date from which you want to see any cancellations.


Example Output





Choose files or drag and drop files
Helpful?
Yes
No
  1. Graeme Orchard

  2. Posted
  3. Updated

Comments