Buy Now
Sign in

Search results not using WHERE rules in data read

zest96 , September 16 2020, 23:05
Z
zest96 36
September 16 2020, 23:05 #393915
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)
WhatsApp_Image_2020-09-17_at_01.50.41.jpg
WhatsApp_Image_2020-09-17_at_01.52.06.jpg
admin 32
September 17 2020, 14:11 #393928
The searchable list is wrong, it only takes fields names!
All the conditions do not work ?
Z
zest96 36
September 17 2020, 19:58 #393949
 1
 Answer
Found it!
Took me some time to figure out the right syntax and it wasn't obvious.
Here is the working stuff:
note the only difference is the ( ) brackets at the beginning and end of rules list.
now not only list shows the filtered rows but the search keeps these filters.
WhatsApp_Image_2020-09-17_at_22.51.22.jpg
WhatsApp_Image_2020-09-17_at_22.51.55.jpg
Attachments
WhatsApp_Image_2020-09-17_at_22.51.22.jpg
WhatsApp_Image_2020-09-17_at_22.51.22.jpg
(34.01 KiB)
120 Downloads/Views
WhatsApp_Image_2020-09-17_at_22.51.55.jpg
WhatsApp_Image_2020-09-17_at_22.51.55.jpg
(37.5 KiB)
119 Downloads/Views
WhatsApp_Image_2020-09-17_at_22.51.55.jpg
WhatsApp_Image_2020-09-17_at_22.51.55.jpg
(37.5 KiB)
153 Downloads/Views
WhatsApp_Image_2020-09-17_at_22.51.22.jpg
WhatsApp_Image_2020-09-17_at_22.51.22.jpg
(34.01 KiB)
154 Downloads/Views
Z
zest96 36
September 20 2020, 21:36 #393987
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
W
webbusteruk 158
October 11 2020, 19:04 #394303
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.
admin 32
October 16 2020, 22:33 #394359
please use v7 as the conditions settings are clearer to setup and do not need guessing about the syntax!
A
attiliomilli 2
January 10 2021, 16:41 #395638
Search results don't use WHERE rules in data read when I search %.
I have the same problem!
problem.jpg
[div][div]
[/div][/div]
Attachments
problem.jpg
problem.jpg
(138.2 KiB)
27 Downloads/Views
admin 32
January 13 2021, 07:39 #395650
what does the debug show ?