anybody here bought SEARCH OPERATOR add-on ? i'm wondering how to use it ?
More thorough documentation is on its way...but here is a basic example:
Field1: Text - first thing to test
Field2: Search Operator - [
Field3: Text - second thing
Field4: Search Operator " OR, AND "
Field5: Text - third thing
Field6: Search Operator -]
Field7: Search Operator "OR"
Field8: Text - fourth thing
So for nesting logic operations you will need a uniquly named bracket field on each side of the argument.
Hope that helps.
Randy
Search Operator:
Does it work on all field storage variants? Somehow, it sounds like it is build to work in "introtext" fields.
Storage shouldn't matter for the search operator.
Regarding examples...we agree!
thanks,
Randy
Hi
This operator field behaves strangely sometimes.
If we try to nest several OR, AND it may generates one extra or one missing ")" in the SQL query which breaks the query and provokes a 1064 SQL error.
For example if you write:
CCK
(
(
field1 > value
AND
field1 < value
)
OR
(
field2 < value
AND
field2 > value
)
)
some other fields ...
You will likely have a 1064 SQL error. Please display the SQL query that is generated to watch the error. For some reasons I don't understand the number of "(" or ")" you put in the search form is NOT what is written in the SQL query.
There must be a reason but who can explain it please ?
thanks
Cyril
I don't know the answer to your question but doesn't AND have precedence over OR ?
So isn't
((field1 > value AND field1 < value) OR (field2 < value AND field2 > value ))
equivalent to:
field1 > value AND field1 < value OR field2 < value AND field2 > value
No brackets required?
Hi
No because this while AND/OR/AND group is inserted whithin other fields so we need a global "(" ")"
Can someone test what I wrote and share his results please?
thanks
+1