?
avatar nuria-sanchez
nuria-sanchez
31 Aug 2018

Steps to reproduce the issue

Users/Manager/search for a last name that I know is part of the DB

Expected result

The user or users with that last name should display

Actual result

Doesn't show any results, because it seems that the feature only searches for first names, not last names, unless the last name is part of the username

System information (as much as possible)

version: Joomla 3.8.6
Operating systems: OS and Windows

Additional comments

I have around 1500 users and I am constantly using the SEARCH feature, therefore, this bug is really annoying. Would be awesome if you can fix it. Thanks!

Votes

# of Users Experiencing Issue
1/1
Average Importance Score
5.00

avatar nuria-sanchez nuria-sanchez - open - 31 Aug 2018
avatar joomla-cms-bot joomla-cms-bot - labeled - 31 Aug 2018
avatar brianteeman
brianteeman - comment - 31 Aug 2018

There is only a single name field in joomla. Not two separate fields for last name and first name.

avatar nuria-sanchez
nuria-sanchez - comment - 31 Aug 2018

So, there is no way to search for a last name?

On Aug 30, 2018, at 5:18 PM, Brian Teeman notifications@github.com wrote:

There is only a single name field in joomla. Not two separate fields for last name and first name.


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub #21931 (comment), or mute the thread https://github.com/notifications/unsubscribe-auth/Ao3iC-rZomynWjKNBhI6_8SFQZV7YOeqks5uWIDUgaJpZM4WUaL8.

avatar brianteeman
brianteeman - comment - 31 Aug 2018

Screenshot showing search of a.last name.
screenshot_20180831-012510 2

avatar nuria-sanchez
nuria-sanchez - comment - 31 Aug 2018

Hmm…
Look at this, I will search for Maria Banda, that you can see that her name displays if I just type Maria:

But I have 150 Marias on my DB. I would need to be able to find that specific Maria easier:

So, I necessarily have to type Maria and then go manually through the whole results list to find her.
I am a web developer, but this is the only site that I manage now that has users, so I don’t have another one to compare to. My programmer, and the client, also complain about the same issue.

Am I missing something and doing something wrong?? Or any ideas why is not working for us?
Would really appreciate any help.

On Aug 30, 2018, at 5:27 PM, Brian Teeman notifications@github.com wrote:

Screenshot showing search of a.last name.
https://user-images.githubusercontent.com/1296369/44886218-02c40f80-acbd-11e8-9aa7-d769271bb494.png

You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub #21931 (comment), or mute the thread https://github.com/notifications/unsubscribe-auth/Ao3iCwIgZ0FLT-wa7IGsPc4murKRiW-4ks5uWIL8gaJpZM4WUaL8.

avatar brianteeman
brianteeman - comment - 31 Aug 2018

Did you intend to post a screenshot?

avatar nuria-sanchez
nuria-sanchez - comment - 31 Aug 2018

Yes, a few, through replying to your email.
Is that not possible?

Nuria Sanchez / President
Phone 702-222-1880
Las Vegas, NV
iworldclassdesign@gmail.com

On Aug 30, 2018, at 5:49 PM, Brian Teeman notifications@github.com wrote:

Did you intend to post a screenshot?


You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub #21931 (comment), or mute the thread https://github.com/notifications/unsubscribe-auth/Ao3iCw0HQF7jgpu0g6xV8oNrCHzSbni8ks5uWIgOgaJpZM4WUaL8.

avatar brianteeman
brianteeman - comment - 31 Aug 2018

Not via email. You will need to do it on the web site

avatar nuria-sanchez
nuria-sanchez - comment - 31 Aug 2018

Ok, here it goes again:

Look at this, I will search for Maria Banda, that you can see that her name displays if I just type Maria:
screen shot 2018-08-31 at 00 51 53

But I have 150 Marias on my DB. I would need to be able to find that specific Maria easier:
screen shot 2018-08-31 at 00 52 43screen shot 2018-08-31 at 00 52 44screen shot 2018-08-31 at 00 52 46screen shot 2018-08-31 at 00 52 47

So, I necessarily have to type Maria and then go manually through the whole results list to find her.
I am a web developer, but this is the only site that I manage now that has users, so I don’t have another one to compare to. My programmer, and the client, also complain about the same issue.

Am I missing something and doing something wrong?? Or any ideas why is not working for us?
Would really appreciate any help.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/21931.

avatar franz-wohlkoenig franz-wohlkoenig - change - 31 Aug 2018
Status New Discussion
avatar franz-wohlkoenig franz-wohlkoenig - change - 31 Aug 2018
Category Administration Administration com_finder com_search
avatar brianteeman
brianteeman - comment - 31 Aug 2018

As can be seen by the following screenshots on a clean install of Joomla I cannot replicate the problem

chrome_2018-08-31_08-00-30

chrome_2018-08-31_08-00-39

chrome_2018-08-31_08-00-46

chrome_2018-08-31_08-01-12

The only "debug" thing I can think of is to go to global configuration and enable debug. Go back to users and try a search. Scroll to the bottom and click on database queries to show the queries that have been performed. You should see one that looks like

SELECT a.*

  FROM `y7deo_users` AS a

  WHERE (a.name LIKE '%banda%' OR a.username LIKE '%banda%' OR a.email LIKE '%banda%')

  ORDER BY `a`.`name` ASC 
  LIMIT 20
avatar nuria-sanchez
nuria-sanchez - comment - 31 Aug 2018

Thank yo very much for taking the time to test it, I really appreciate it.
We will do what you suggest and let you know.

Have a great day!!!

On Aug 31, 2018, at 12:05 AM, Brian Teeman notifications@github.com wrote:

As can be seen by the following screenshots on a clean install of Joomla I cannot replicate the problem

https://user-images.githubusercontent.com/1296369/44897618-2fdfe480-acf4-11e8-995c-d2f622dd0276.png
https://user-images.githubusercontent.com/1296369/44897619-2fdfe480-acf4-11e8-85b8-a587b2f27cdc.png
https://user-images.githubusercontent.com/1296369/44897620-30787b00-acf4-11e8-9233-d789d09e4010.png
https://user-images.githubusercontent.com/1296369/44897623-31111180-acf4-11e8-843f-5f75a9a371e1.png
The only "debug" thing I can think of is to go to global configuration and enable debug. Go back to users and try a search. Scroll to the bottom and click on database queries to show the queries that have been performed. You should see one that looks like

SELECT a.*

FROM y7deo_users AS a

WHERE (a.name LIKE '%banda%' OR a.username LIKE '%banda%' OR a.email LIKE '%banda%')

ORDER BY a.name ASC
LIMIT 20

You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub #21931 (comment), or mute the thread https://github.com/notifications/unsubscribe-auth/Ao3iC-0gebJPpwNvPFQxSk_PN-a46ltUks5uWOBEgaJpZM4WUaL8.

avatar franz-wohlkoenig franz-wohlkoenig - change - 31 Aug 2018
Status Discussion Closed
Closed_Date 0000-00-00 00:00:00 2018-08-31 16:26:15
Closed_By franz-wohlkoenig
avatar joomla-cms-bot joomla-cms-bot - change - 31 Aug 2018
Closed_By franz-wohlkoenig joomla-cms-bot
avatar joomla-cms-bot joomla-cms-bot - close - 31 Aug 2018
avatar joomla-cms-bot
joomla-cms-bot - comment - 31 Aug 2018
avatar franz-wohlkoenig
franz-wohlkoenig - comment - 31 Aug 2018

closing as issue seems resolved. I needed, Issue can always reopened.


This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/21931.

Add a Comment

Login with GitHub to post a comment