Joomla 3.9rc1
Think like a regular everyday Joomla super admin (and not like a developer/contributor)
in Action logs admin, a normal Joomla super admin will assume the search box allows them to - erm - actually search for something...
ok, so I wanted to search for "logged in" to see what users have logged in today
List of actions with "logged in" in their Action text.
No results
The actual sql run is only searching on usernames
SELECT a.*, u.name
FROM ltm4b_action_logs AS a
INNER JOIN ltm4b_users AS u
ON a.user_id = u.id
WHERE (`u`.`username` LIKE '%logged%')
ORDER BY a.id DESC
in which case, the search is doing exactly the same as the user dropdown and is therefore useless for searching anything other than usernames (and even that fact is not communicated)
Labels |
Added:
?
|
Labels |
Added:
J3 Issue
|
Yup I get that. which basically makes this searchbox useless, as you can only search for username, and you already have a searchable dropdown for that selection anyway
Apparently there is a tooltip that explains what you can search for...
So is this is wont fix
?
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2019-02-10 21:34:27 |
Closed_By | ⇒ | PhilETaylor |
Doing this level of filtering in SQL won't work as the translation keys for messages are stored in the database. So, things here would have to be done similar to other components where you basically pull the full table into memory then apply filtering/pagination in PHP versus using SQL.