Calendar application displays query data in a full calendar.

Calendar application in DbFace

How to build Calendar Application?#

You can create calendar application in Drag & Drop mode and Script mode.

Calendar application in DbFace

STEP 1: select "Calendar Application" in Visualization section#

Please click the "Calendar Application" button to open the Calendar Application Builder.

STEP 2: Choose a base date field.#

Drag the date field from the left field list top the Date field. If your fields do not contain "Date" field, you can also format string field to "YYYY-mm-dd HH:ii:ss" to get correct result.

You can only drag one date column to the Date field.

STEP 3: Choose the data fields#

Drag the data fields from the left field list.

Calendar application in DbFace

Script mode#

You can also build calendar applications in Script mode.

Tap the "Script" checkbox to switch to Script mode, DbFace will try to generate correct query you already built.

Your SQL query's first column should be Date field or date formatted field.

e.g.

SELECT
  DATE_FORMAT(orderDate, '%Y-%m-%d') as `Date_of_orderDate`,
  `orderNumber`,
  `status`,
  `customerNumber`,
  `comments`
FROM
  `orders`