Displaying the list of events with a relative and absolute calendar period

The display of the list of events in the table in the Events section depends on the selected event filtering period: relative or absolute.

When a relative period is selected, the display is as follows:

• If a certain value is specified for the LIMIT variable in the SQL query, the number of displayed events corresponds to this value.

  Example SQL query: SELECT * FROM `events` ORDER BY Timestamp DESC LIMIT 10.

• If the LIMIT value is not specified in the SQL query, 250 events are displayed by default.

  Example SQL query: SELECT * FROM `events` ORDER BY Timestamp DESC.

If a relative period is selected, all events are displayed on the same page.

If an absolute period is selected, the display is as follows:

• If the value of the LIMIT variable in the SQL query is less than or equal to 49, and more than 49 events are found, to view additional rows in the table, you need to click the Show more button.

  Example SQL query: SELECT * FROM `events` ORDER BY Timestamp DESC LIMIT 48.

• If the value of the LIMIT variable in the SQL query is greater than 49, and more than 49 events are found, additional events are loaded into the list automatically.

  Example SQL query: SELECT * FROM `events` ORDER BY Timestamp DESC LIMIT 50.

Page top