Feature #71558
closed
Allow SQL expressions in "DB Check"->"Full Search"
0%
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.
Updated by Susanne Moog almost 5 years ago
- Status changed from New to Closed
Due to low demand / low priority I'm going to close this issue now. If anyone takes time to implement it, simply open a new issue please. Thanks.