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?
-
anderslolk
- Support
- Sunday, May 12 2019, 09:16 PM
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.
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.
- Page :
- 1
There are no replies made for this post yet.
However, you are not allowed to reply to this post.
However, you are not allowed to reply to this post.