Forums

Hi,
I have this in my data read and that in my searchable fields
The table view shows records as expected.
But search results shows records without respect for the WHERE rules.
​
How can I make the search respect those rules?
(please don't give me just hints, cause i tried too many combinations in searchable fields)
​
​

​

The searchable list is wrong, it only takes fields names!
​
All the conditions do not work ?

it didn't work until I added the brackets.
do you mean I shouldn't have put the MODEL ?
which is correct?
this? (in which the debug query looks correct, and the results are as expected)
(
Model.field_name
OR
Model.field_name
)
​
or this?
(
field_name
OR
field_name
)
​
or this?
​
field_name
OR
field_name

You need to add the brackets and OR in the top part, not the multiline list. Click on the "+ operator" button and change to "(" , ")" and "OR", and arrange it accordingly.
​

(
Model.field_name
OR
Model.field_name
)

(
field_name
OR
field_name
)

Both should work.

please use v7 as the conditions settings are clearer to setup and do not need guessing about the syntax!

Search results don't use WHERE rules in data read when I search %.
​
I have the same problem!
​

what does the debug show ?