Hi, folks,
Had a question on syntax for an MQL filter. What I'm trying to do is grab all the cards for a release that have not been assigned an iteration (which by our convention is cards that are candidates for review for the iteration).
I want to set up an MQL filter to grab these cards with a format like (Release = 7 AND Iteration = (not set)). Yes, I know I can do this without MQL filters, but the actual set of cards I need is more complex, so I need MQL filters to get it right.
My problem is the "Iteration = (not set)" piece. I can't seem to find a format the MQL filters like that will do what I want. The format above hits a parse error on '(not'. A slightly different formulation "Iteration = '(not set)'" tells me (not set) isn't numeric and so I am not allowed to compare it to Iteration (which is a numeric property for us). "Iteration !> 0" yields a parse error. "Iteration < 13" doesn't match (not set).
My current workaround is something like "Release = 7 AND (Iteration != 14 AND Iteration != 15 AND Iteration != 16....", which is exceedingly ugly, and is fragile if someone adds an iteration, but actually gets the cards I want.
Is there a better way to match (not set) for a numeric in an MQL filter I'm not thinking of?
MQL Filter question for (not set)
Comments
2 comments
Hi Mike
The syntax for the MQL filter would be: Iteration = NULL or Iteration IS NULL.
This syntax is valid both if your Iteration property is a numeric property or if it is a card/tree property.
More information can be found in our help under the MQL section.
hope this helps
-jen
Exactly what I wanted--thanks!
Please sign in to leave a comment.