Users/Manager/search for a last name that I know is part of the DB
The user or users with that last name should display
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
version: Joomla 3.8.6
Operating systems: OS and Windows
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!
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.
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.
Did you intend to post a screenshot?
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.
Not via email. You will need to do it on the web site
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:
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.
Status | New | ⇒ | Discussion |
Category | Administration | ⇒ | Administration com_finder com_search |
As can be seen by the following screenshots on a clean install of Joomla I cannot replicate the problem
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
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 likeSELECT a.*
FROM
y7deo_users
AS aWHERE (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.
Status | Discussion | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-08-31 16:26:15 |
Closed_By | ⇒ | franz-wohlkoenig |
Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/21931
closing as issue seems resolved. I needed, Issue can always reopened.
There is only a single name field in joomla. Not two separate fields for last name and first name.