Support

  1. anderslolk
  2. Support
  3. Sunday, May 12 2019, 09:16 PM
  4.  Subscribe via email
Hi.

I've several menu items type "Users list (table)". In one of them, there are a total of 9 SQL custom where parameters. The search function doesn't work in this menu item. When I make a search all users are showed.

I the other menu items there are only 1 SQL custom where parameter and the search work fine there.

How can I make the search function work in the menu item with many SQL Parameters?
admin Accepted Answer
Admin
Hi,
fixed, for a query like this with "AND" and "OR" at the same level the solution is to use a syntax like this:
"(your sql where)". Basically add "(" and ";)".

For example, with a custom where like "a = 1 OR a = 2" then the query was build with something like this:

SELECT .... FROM .... WHERE a = 1 OR a = 2 AND search_field = "my_search_word"

so search results will be filtered results with a = 2 plus all results when a = 1.
  1. more than a month ago
  2. Support
  3. # 1
anderslolk Accepted Answer
Pro
Great, thanks :)
  1. more than a month ago
  2. Support
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Request Support

Support is currently Offline

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.