Issue Feature Closed

#71558Allow SQL expressions in "DB Check"->"Full Search"

Viktor Livakivskyi 11/13/15, 14:12 updated 01/15/20, 21:55

Description

Hi, developers.

The story is, that customer wants to see a list of online FE users in BE.

My intention was to use sys_action extension with pre-defined query, instead of developing a BE module just for this case.
The query should select all fe_users, who have ‘is_online’ field greater than “current_time – 20 min”. Unfortunately, query builder in BE doesn’t allow me to put such an expression (in correct SQL form) in input field, but only to select a date and time with datetime-picker.

It would be nice to have some “raw mode” at least for query parts, which allows to put raw sql.

From a security aspect, such a mode may be available for admin-users.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.