Support

  1. jimbo
  2. Support
  3. Saturday, August 15 2015, 01:17 AM
Hi,

I've made a select field with I've made searchable. It targets a company_name column so users can search by company.

It works well but lists duplicate entries if more than one user works for the same company.

Is there a way to stop duplicate entries showing? Any help with the correct Sql WHERE parameter to use would be much appreciated.

Thank you.
Accepted Answer
admin Accepted Answer
Admin
Hi,
try with
id>0 GROUP BY company_name
  1. more than a month ago
  2. Support
  3. # Permalink
jimbo Accepted Answer
Basic
I thought this might work but still no good:

company_name IN (SELECT DISTINCT company_name FROM #__jsn_users)
  1. more than a month ago
  2. Support
  3. # 1
jimbo Accepted Answer
Basic
Content Protected
  1. more than a month ago
  2. Support
  3. # 2
admin Accepted Answer
Admin
no idea how - but it works!
SQL where write filter directly on DB query, "GROUP BY" MySql statement is used to group the result-set by one or more columns.
  1. more than a month ago
  2. Support
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

Request Support

Support is currently Online

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.