Granular Taxonomy-Based Publishing Workflow

You could do this by creating workflow states, but it seems a bit of an awkward fit. A better solution might be a taxonomy access control module such as

http://drupal.org/project/tac_lite

http://drupal.org/project/taxonomy_access

I'm also looking for a way to do something like this.

Taxonomy Role is helpful in doing one thing: When creating content, it will allow selecting terms that you are authorized for. So the sports person will only get taxonomy he/she is authorized for.

http://drupal.org/project/taxonomy_role

The second problem that I'm looking to solve is how can the workflow be based on the term selected?

So, if a Sports author is submitting content type News, the author will only be able to tag it with sports-related Taxonomy (e.g., Sports: Basketball or Sports:Tennis, etc.). Now the workflow should consider to send an email to the Sports Editor (as opposed to the Entertainment editor).

Similarly, if an Entertainment author is submitting content type News, the author will only be able to tag it with entertainment-related Taxonomy (e.g., Entertainment: Box Office or Entertainment:Night Life, etc.). Now the workflow should consider to send an email to the Entertainment Editor (as opposed to the Sports editor).

Ideas are greatly appreciated.

Thanx.

If it is possible for you to create a different Content-Type for each different article type, you might be able to accomplish this "out of the box" using the Revisionary module: http://drupal.org/project/revisionary

If this is not an option, you're probably going to have to figure out a way of implementing the permission check(s) yourself in a custom module. Again, Revisionary may help you here; figure out how they're doing it based on content-type, and modify it to work based on taxonomy instead.

I too would love to have this functionality... subscribing

I'd appreciate any feedback on this scenario:

I have a company intranet site where I’ve created a Category taxonomy. Every new node is classified to a category (which amounts to a content hierarchy). My workflow will be multi-step, with content owner reviewing first, then the communications manager reviewing for messaging, and finally myself reviewing that all the Drupal settings are appropriate (hopefully this step goes away). So, the content owner/expert changes depending on what section (Category taxonomy) of the site the content is assigned to. For purposes of routing new nodes (or edited nodes) to the appropriate content owner/expert for review, I was thinking it would be useful if I could assign a username to each category term. Then, when content is added/updated, the node would be routed to the correct person for review based on the category selected.

If anyone has any suggestions on how to accomplish this, I very much appreciate your thoughts.

Cam

To all the above...
Our customer, a university running a web site with many contributing authors and publishers, was dealing with very much the same issues.
To address them I first tried various existing modules, but none were very satisfactory. So I wrote a new module, Revisioning, which I feel could satisfy most of your needs.
Be the first to try it!
It comes with 3 very detailed step-by-step tutorials (links are on the Revisioning project page).
Good luck and I look forward to your feedback!

And: http://drupal.org/project/module_grants

Great documentation and looks good RdeBoer! Might be exactly what I need. Will test out Revisioning + Module Grants + Workflow + TAC combo (-AND-ing access grants rather than -OR-ing is a must for my project). Anyone already using this combination?

I have got a smilar task todo
http://stackoverflow.com/questions/2447092/drupal-workflow-action-access...

I would like to have users with roles (dep1 + editor), (dep2 + editor) and then analogue (dep1+ publisher) and so on.

For now it looks like i need dep1-editor, dep2-editor .... dep1-publisher.... etc... so for our 20 departments we would end up with 40 roles. Not that nice... but at least it would work i suspect.

Hmm.. I managed to do the desired functionality with TAC.
It was a bit of a struggle figuring out what to tick where... but at the end it was like that:

There is a vocabulary "resort" which contains terms like "sports", "baseball", "basketball", "business", "local news" all available to content type "Article". Someone with the role "Sportsreporter" can create content of type "Article" where there is a select field for the taxonomy, which only contains "sports", "baseball" and "basketball" ... and NOT "business" or "local news". A user with role "Businessreporter" has only available "business" in that taxonomy list, and so on. Of course, once a node is created, the edit permission stays with the roles assigned to the terms. (An admin could change term "sports" to "local news", and then all "Sportsreporter" would be unable to edit that node anymore.)

Works fine here. Of course: without moderation or version management.
If you want to have the content in moderation, then that's possible too ... if you have a all resorts moderator. Having different sports moderators or business moderators publishing the created unpublished versions of the reporters is not possible like that, I think.

Another thing I did not figure out is how to let articles with term "sports" be created and published WITHOUT moderation, but articles with term "business" only WITH moderation... I'm still trying to do that...

So long...

Use case scenario :

A complex workflow. Each node going though the workflow is associated with one of the 200 terms in the taxonomy. A moderator for each term. Actually, the way to do it would be creating 200 roles and using tac_lite to grant or restrict access. Doing it with rules would simply need a validation when a content in a specific state is going to be viewed... BUT I'm stuck at linking term to its moderator and generate a token from this...
I'm not trying to select a taxonomy for the user (user term, profile taxonomy, content profile) but to select a user to be associated to a term and then be able to use the token in rules.

With term fields I could do this by adding a field that would be the UID or the email address, but it's obviously not a great way of doing it....

With NAT, I could do it using CCK user reference, but then the token is associated to the node from NAT, not the term...

So, would their be any way to use CCK user reference with a term and grab this reference with rules to grant/restrict access ?

Going one step further...

I have a Vocabulary "Domain"
With taxonomy_node, I create a content type "domain" in which I can use CCK user reference to link my term to a specific Moderator

With content_taxonomy, I add a term to the content-type that needs to go through a workflow

With token_custom, I'm creating a node token which I'll use in rules

$nodeid = arg(1);
$domain = db_result(db_query("SELECT field_domain_value FROM {content_field_domain} WHERE (nid=%d) AND (delta=0)", $nodeid));
$taxonode = db_result(db_query("SELECT nid FROM {taxonomynode} WHERE (tid = %d)", $domaine));
$moderator = db_result(db_query("SELECT field_moderator_uid FROM {content_type_domain} WHERE (nid = %d)", $taxonode));
echo $moderator;

This code echoes the UID of the moderator for the term . Then, I'm able to validate with rules that when a node of a specific type is in a specific state is going to be viewed, if [node:toke_custom_moderator_domain]!=[user:uid] then do a Page redirect and Show a message " You don't have access".

This way, I don't need to create a role for each domain-moderator, but only for "moderator" ... one role instead of 200 seems a lot more manageable to me ;)

Hopefully, this might help others...

I keep working on this...

I would now need an event "If content is going to be edited"

Will track this : http://drupal.org/node/762450

And if you want to display a view filtered for current user, assuming you have already filtered by content-type and workflow state, and limited access to the view only for the role "moderator", this PHP code (viewsphpfilter) (which needs a bit of clean up and validation) might help :

global $user;
$uid=$user->uid;
$nids = array();
$nids2 = array();

$result1 = db_query("SELECT nid FROM {content_type_domain} WHERE (field_moderator_uid = $uid)");

while ($my_row = db_fetch_array($result1)) 
{
$nids[] = $my_row['nid'];
}

$key=0;
while (list($key, $value) = each($nids)) { 
$nids[$key] = db_result(db_query("SELECT tid FROM {taxonomynode} WHERE (nid = $value)"));
$result2 = db_query("SELECT nid FROM {content_field_domaine} WHERE (field_domain_value = $nids[$key])");

while ($my_row2 = db_fetch_array($result2))
{
$nids2[] = $my_row2['nid'];
}
} 

return ($nids2);

Since this request is over a year old, I'm going to assume a solution was found or you've moved on. If not, please get updated to the latest versions of all modules and make a request for it against Drupal 7 if the problem is still there and I'll be glad to take a look at it.

ITMT, in version 7.x.2.x, a new hook_..._alter() is introduced, where you can change the premitted transitions.
For example, you can limit the permitted transitions according to the user's profile.
See workflow.api.php for details.