Hi all,
I have been trying to solve this problem but I can´t. I guess there is something wrong with the syntax but I can´t figure out the solution.
I think the code snippet is self explanatory.
I´am trying to select a property (Start Date) from the Current Iteration Project variable to be displayed in a Wiki page.
Any of you know how to do that?
Thanks in advance,
Ariel.
Code Snippet
value query: SELECT COUNT(*) WHERE Type = Iteration AND Iteration = (Current Iteration)
Comments
5 comments
That looks really close. Try changing COUNT(*) to "Start Date" in the MQL.
Hi Jay,
I think that not fix my problem. For example the Count(*) query is always returning 0. I think the problem resides in the where clauses.
WHERE Type = Iteration AND Iteration = (Current Iteration)
that kind of query works very good for stories... for example:
WHERE Type = Story AND Iteration = (Current Iteration)
Thoughts?
Thanks again,
Ariel.
I see. I misunderstood your initial intention. Currently there is no way in MQL to use a card project variable to get values for the card that is assigned to the project variable. (Which is just a long way of saying that we can't get the start date for the current iteration.) I've added that story to our project backlog.
For now your best options are to either to type in the date directly (if you only need that in one place) or create a project variable that contains either the start date or the iteration card number (if you need that start date in more than one place).
I realize those are not ideal solutions, hopefully they are acceptable for now.
Hi Jay, thanks for your help with this.
Supose that you have the following tree: Release-->Iteration-->Story
I think you can use a project variable in MQL. The following query is working pretty good:
{{ value query: SELECT COUNT(*) WHERE Type = Story AND Iteration = (Current Iteration)}}
If I did something like this it works perfect too:
{{ value query: SELECT COUNT(*) WHERE Type = Iteration AND Release= (Current Release)}}
The problem is that the Iteration doesn´t have a Property called Iteration and I think that´s why the query is failing
{{ value query: SELECT COUNT(*) WHERE Type = Iteration AND Iteration= (Current Iteration)}}
What I am not sure, based on what you said is that something like this could work:
{{ value query: SELECT COUNT(*) WHERE Type = Iteration AND number= (Current Iteration Number)}}
Yes, your last example should work Ariel.
Please sign in to leave a comment.