function content_distribution_views_query_alter(&$view, &$query) {
  if ($view->name == 'content_distribution_queue') {
    $query->where[0]['clauses'][3] = "DATE_FORMAT((FROM_UNIXTIME(node.changed)), '%Y%m%%d%H%i') >= '%s'";
  }   
}

This is ugly -- surely a handler could implement this properly?

CommentFileSizeAuthor
#3 708094.content_distribution.add-views-handler-kill-query_alter.patch5.79 KBjoachim

Comments

greg.harvey’s picture

greg.harvey
Primary language English
Location Occitanie, France
commented

That must've been Graham....... ;-)

joachim’s picture

joachim commented

Hehe, likely story... ;)

Anyway, I have a working handler :)

AFAIK there's no nice way to get an update function to add/remove/changed views handlers. So that means a compatibility break.

joachim’s picture

joachim commented
Status: Active » Fixed
StatusFileSize
new 708094.content_distribution.add-views-handler-kill-query_alter.patch5.79 KB

Committing this patch.

I've added a note to the 6.x-2.x-dev release node about views needing changing.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.