By angel.h on

Is there such kind of monster and if yes where it is hiding? I look at View UI and I am wondering why there are no more flexible filtering system. Quick example - there is no way to define relations between the filters. No way to define filter value using PHP (only using the UI).

Right now I am suffering from the fact that i cannot use filter grouping - I want to have in the where clause something like "where ..... and ((date_1 = '2009-10-02') and (date_2 = now or date_2 is null))". Instead Views is generating "where ..... and ((date_1 = '2009-10-02') or (date_2 = now ) or ( date_2 is null))". BTW does someone know how to achieve the first where clause????

Does someone know if this is going to be implemented or not?

Comments

WorldFallz’s picture

WorldFallz commented

There's nothing hidden in the views ui-- it is what is is. There are some contribs that enhance filters. A couple you may want to look at are http://drupal.org/project/views_filtergroup, http://drupal.org/project/views_or, and http://drupal.org/project/viewsphpfilter.

angel.h’s picture

angel.h
Primary language English
Location Plovdiv
commented

I will take a look. I guess those will do the thing.

angel.h’s picture

angel.h
Primary language English
Location Plovdiv
commented

or at least a good 3-4 hours. Thanks a log again. The Views Or did the job. Very useful module.

WorldFallz’s picture

WorldFallz commented

Excellent-- glad it worked.