Search macros

When you define a custom "search" (Manage Keys/search/edit searches), you can use any of the macros in the table below in the SQL field. These macros are automatically replaced when the search is performed.

List of supported macros:

You can use + or - arithmetic operations within a macro. When using arithmetic operators the default unit is days. For example, the macro to [today_start+5] effectively means [today_start + 5 days].

The following units are available to control the increments: d (default), h (hours), m (minutes), s (seconds), and M (months - available as of QLM v16.0.2250.1)

Examples:

[today_start-5] is equivalent to 5 days ago.

[today_start+5] is equivalent to 5 days from today.

[today_start+5d] is equivalent to 5 days from today.

[this_month_start-3M] is equivalent to 3 months ago.