J3 Issue ?
avatar PhilETaylor
PhilETaylor
15 Oct 2018

Steps to reproduce the issue

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

Expected result

List of actions with "logged in" in their Action text.

Actual result

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)

avatar PhilETaylor PhilETaylor - open - 15 Oct 2018
avatar joomla-cms-bot joomla-cms-bot - change - 15 Oct 2018
Labels Added: ?
avatar joomla-cms-bot joomla-cms-bot - labeled - 15 Oct 2018
avatar PhilETaylor PhilETaylor - change - 15 Oct 2018
The description was changed
avatar PhilETaylor PhilETaylor - edited - 15 Oct 2018
avatar brianteeman brianteeman - change - 16 Oct 2018
Labels Added: J3 Issue
avatar brianteeman brianteeman - labeled - 16 Oct 2018
avatar mbabker
mbabker - comment - 17 Oct 2018

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.

avatar PhilETaylor
PhilETaylor - comment - 17 Oct 2018

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

avatar PhilETaylor
PhilETaylor - comment - 19 Oct 2018

Apparently there is a tooltip that explains what you can search for...

So is this is wont fix ?

avatar PhilETaylor PhilETaylor - change - 10 Feb 2019
Status New Closed
Closed_Date 0000-00-00 00:00:00 2019-02-10 21:34:27
Closed_By PhilETaylor
avatar PhilETaylor PhilETaylor - close - 10 Feb 2019

Add a Comment

Login with GitHub to post a comment