Page History

...

Option

Description

Name

The name of your custom report.

Query

The SQL query to be executed when your report is requested.

Info

Fields can be used within a query using the colon syntax. For example:

Code Block

language	sql

SELECT `id` FROM `users` WHERE `username`=:username;

Where a field exists with the name username.

Fields

Option

Description

Label

The label shown for this field when generating this report.

Name

The name of the field for us use in query substitution.

Type

The type of field.

Option	Description
Text	A text input field.
Select	A select menu, with the provided options.
Date	A date picker.

Required

Whether or not the field is required.

Options	Description
No	The field is not required.
Yes	The field is required to have something specified. For select field types, one of the specified options must be selected.
Custom Regex	The value for the field must pass this regular expression.

...

Page tree