I have problems with the workflow view filter
I have a few states and if I select that the node should be one of [a few marked]
the problems occur only on some combinations
I saw that if i use "is none of" works sometimes better then "is one of"
"is all of" is unnecessary in my opinion, because a node can only have on state.
I tracked one of the query generated by view with the devel module:
SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node.changed AS node_changed, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, workflow_states.state AS workflow_states_state FROM jf_node node LEFT JOIN jf_workflow_node workflow_node ON node.nid = workflow_node.nid LEFT JOIN shared_users users ON node.uid = users.uid LEFT JOIN jf_node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN jf_workflow_states workflow_states ON workflow_node.sid = workflow_states.sid WHERE (workflow_node.sid NOT IN ('8\',\'11')) ORDER BY node.changed DESC, node.changed DESC LIMIT 10, 10
the problem is the NOT IN ('8\',\'11') if you change it to NOT IN ('8','11') the query worked for me at phpmyadmin
I'm no SQL-expert so I need help
Thanks
Comments
Comment #1
merlinofchaos commentedI believe this was fixed by http://drupal.org/node/63700
Comment #2
Tobias Maier commentedit loos like this was fixed, thanks
but have a new problem :(
http://drupal.org/node/64103
Comment #3
Tobias Maier commentedComment #4
(not verified) commented