Post

1 follower Follow
0
Avatar

Problem with business rule (select specific tasks/pick list values)

For our sprint planning sessions, I have created a business rule that sets the start date and due dates of tasks added to the sprint to be set manually as the same start and due dates of the parent item. It has been working well so far.

However, I have seen that it may have some ill effects when a task is actually a customer meeting (or other types of tasks to come) which must take place exactly at a specific date.

The evaluation criteria is the following:

Not(IsNull($Milestone)) && $Milestone.MilestoneType='Sprint' && $State<>'Completed' && Not(In($TaskType, 'Meeting','Sprint'))

All has been working well for the general rule, except I cannot get the rule not to run on tasks of specific types (section in bold). Does anyone have any hints?

BTW, we use a custom action that adds a task in the sprint an creates an shortcut in its original place.

Peter Fjelsten Answered

Please sign in to leave a comment.

5 comments

0
Avatar

Can you try && $TaskType<>'Meeting' (exclude the Sprint part) and lets see if that works. 

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

I have already tried this. This works. I need to create a rule where several of the Task Types should not trigger the it.

Peter Fjelsten 0 votes
Comment actions Permalink
0
Avatar

Try && $TaskType<>'Meeting' && $TaskType<>'Sprint'

It's not elegant but I want to see if it works for you.

Josh Santos 0 votes
Comment actions Permalink
0
Avatar

It does, thanks. Now, is there a more elegant way of coding this (as I tried to create above)? :-)

Peter Fjelsten 0 votes
Comment actions Permalink
0
Avatar

Lets try using the Case() function: $TaskType <> Case('Meeting','Sprint')

You can use commas to add more values in there. I think this may be the best solution.

Josh Santos 0 votes
Comment actions Permalink