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

CommentFileSizeAuthor
#2 workflow.module.views_.patch436 bytesbuchanae

Comments

d0t101101’s picture

d0t101101 commented
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.

.

buchanae’s picture

buchanae commented
StatusFileSize
new workflow.module.views_.patch436 bytes

this patched fixed it for me

buchanae’s picture

buchanae commented

this patched fixed it for me

boaz_r’s picture

boaz_r commented

Patch #2 worked for me as well.
Any chance getting this in officially?
Thanks.

JacobSingh’s picture

JacobSingh commented
Status: Active » Reviewed & tested by the community

Seems good from my end

JacobSingh’s picture

JacobSingh commented
Status: Reviewed & tested by the community » Patch (to be ported)

Committed to DRUPAL-5

deekayen’s picture

deekayen commented
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.

Status: Fixed » Closed (fixed)

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