Project

General

Profile

Actions
Copy link

Feature #71558

closed

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

Added by Viktor Livakivskyi about 9 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Could have
Assignee:
-
Category:
Backend API
Target version:
-
Start date:
2015-11-13
Due date:
% Done:

0%

Estimated time:
PHP Version:
5.6
Tags:
Complexity:
Sprint Focus:

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.

Actions
Copy link

Also available in: Atom PDF