Workflow Filters in Views [#126069]

The operator in the view's exposed filters does not appear to be correct. In my view_filter table, the record with the workflow_node.sid field has an operator of 'OR' which results in the query '... WHERE (node.type IN ('ppp')) AND (workflow_node.sid OR '18'). ' This filter does not filter the result set. In the view's exposed filters block, i have:

Optional=checked, Filter settings Default= unchecked, Force Single=checked, and Lock Operator=checked

changing the operator manually in the db to '=' seems to resolve the problem, but i could not find in the code where this value is set.

Ryan

Comment	File	Size	Author
#2	workflow.module.views_.patch	436 bytes	buchanae
#2

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

d0t101101 CreditAttribution: d0t101101 commented 6 July 2007 at 02:27

Version:

5.x-1.0

» 5.x-1.1

This is still a problem with v1.1. It seems checking 'force single' inside the views exposed filter settings breaks the filter, showing all workflow states. Unchecking 'force single' fixed the problem.

Comment #2

buchanae CreditAttribution: buchanae commented 17 July 2007 at 20:02

File	Size
workflow.module.views_.patch	436 bytes

this patched fixed it for me

Active

» Reviewed & tested by the community

Seems good from my end

Comment #6

JacobSingh CreditAttribution: JacobSingh commented 1 January 2008 at 13:47

Status:

Reviewed & tested by the community

» Patch (to be ported)

Committed to DRUPAL-5

Comment #7

deekayen CreditAttribution: deekayen commented 6 June 2009 at 17:56

Status:

Patch (to be ported)

» Fixed

This patch applied to workflow_views_tables(), which in Views2 changed to workflow_views_data() and a very different array declaration that makes the upgrade of this patch void.