Hello,
it's possible to change a AND to a OR in the search of 2 dynamic fields/option fields?
The Search Operator doesn't work for me for that.
Query:
ORDER BY t1.title ASC
I tried to use the search operator, but it inserts not the right Code in my query.
Is there a other way to change the query?
It shoudl insert the righjt code, what does it do for you? You need to palce it before the right field, in your case before second dynamic field.
Yes,
dynamic field
OR field
dynamic field
This inserts an AND before GROUP and breaks the query. If I uses parentheses it inserts more ANDs before GROUP, AND AND AND GROUP
My suggestion is that the search operator won't work with the match "any words"
You have an error in your SQL syntax ...
... AND t1.catid LIKE '%47%' AND GROUP BY t0.pk ORDER BY t1.title ASC
Seems there is a bug with multiples matching, I had similar problem on category search with Not in
Hi Aktinon,
Do you try to change the match on your fields with something like "any words exact"?
Thanks.
Yes, but doesn't change the problem.
I also think there is a bug with multiples matching.
Hi aktinon,
Before you talk about a bug, please ensure if there is really a bug.
Can you share with us the configuration of your search form? We need to know which field you use in the search form and which field you use in the site form to add article.
Based on the existing posts, I think you use a "select dynamic" field and its copy in the search form in order to retrieve all articles which have values 171 and 176.
I think you have a unique "select dynamic" field in the site form view of the content type you use.
My suggestion:
- try to use only one "select dynamic" field in the search form view of your search type.
- click on button "2" and fill value 171,176 in the live value column of the select dynamic field
- click on button "3" and select option "any word exact". Click on button "+" to add separator "," (comma)
I hope this response help you to solve your issue.
Regards,
Mehdi.
We need and use the combination of 2 dynamic select fields and for the where clause "any words".
The life value for both is the set to variable and multiple.
I can setup a virtual server with a copy of the website to see more.
Hi aktinon,
You said "3 days ago 0 Level 1 We need and use the combination of 2 dynamic select fields and for the where clause "any words"" OK. But, when i check the query resulted from your search type i read
For us, that's means you use 2 fields "select dynamic" with the same storage. Why? Because the query generates
In this case, you should use only one field and follow our suggestion in the previous post.
In other case, please send us screen shots for the configuration of your search type.
Regards,
Mehdi.