symphonists
Weird pagination results
As soon as I use a second "where" with "SymQL::DS_FILTER_OR", the number for "total-entries" in the pagination get's totally messed up.
I think this might even be a bug in the core (EntryManager or whatever), because I tried a different solution to my problem with Union Datasource instead of using SymQL in a custom datasource, and it also returned a wrong number for "total-entries".
Any ideas?
Were both wrong results the same? If so, then yes this could well be a bug in the EntryManager class. Do you have an easily replicable test case perhaps?
It's been a while, but I'll try and tell you something about my usecase. I ended up using Union Datasource and the issue still exists, but you can easily recreate the issue with SymQL as well.
I implemented a basic frontend search, where articles (entries of section "articles") are filtered by title OR tags. I used a regular expression for the datasource filtering that I learned about in the forum: regexp:{$query:$url-q}.
Since OR conjunktion didn't seem to be possible with a native datasource, I tried to achieve it with SymQL (and later Union Datasource) instead.
Does this help? Or do you need more details?