Mixing filters of the same type in the DataSources
This is an open discussion with 3 replies, filed under General.
Search
Well, theoretically you could build a helper DS with the not:
filter, outputting the IDs to the param pool, then filter your DS using these IDs. The problem here is: You can not paginate the helper datasource, so this will probably have performance implications with large datasets.
Hmm, so basically this means: write your own datasource, you lazy bastard? :)
Yeah, I am not aware of any other solution. But I know your SQL fu. You can do it.
Create an account or sign in to comment.
This is quite a tricky question, so I'll try to be as precise as possible: there are articles that have labels (Interview, Column, Blog, Video, etc) and the site is split into two parts: opinions (interviews, columns) and scientific (thesis, publications) based on these labels.
So, when I go to
website.com/opinions
I'd like to list all articles that have a label of theopinion
type, and the same forscience
. By simply filtering the label field on these values, this is rather easy.But now for the tricky bit: there are labels I do not want to list in either one of these pages, not even if they also have a label that woud make them listed. For instance, the label
Video
should never be shown on these pages, as they will get their own space.Easy, you say: just add another filter:
not: video
and you're done. Well: no. It is not possible to mix thenot:
syntax with the normal IN filters, and adding another filter of the same type is also not possible (the select is grayed out, and the old filters is overwritten if I do try it;)).So my question is: is this possible without writing a custom datasource?