Articles in this section

See more

[Implemented-3.3] Wiki Page Query Syntax

Avatar
Sbarton
Updated
Follow 

Hi Experts -

Another syntax question for you...  This time I want to have a list of all the cards where the planned iteration is in the past.  What I would like to do is get the "end date" value of the iteration card that is assigned to the story using a planning iteration tree.  I have seen some similar posts talking about getting parent properties for children cards, but most are talking about queries on card descriptions not wikis using "This card" or PROPERTY.  Any thoughts?  I pasted some code that doesn't work, but has the idea of what I am trying to do.  Hopefully, I just have the syntax wrong, thanks.

Code Snippet

 table query: SELECT number WHERE 'Planning Tree - Iteration'.'end date' < TODAY

Comments

6 comments

Sort by Date Votes
  • Avatar
    Ian Bridson

    Scot, I am not aware of a query syntax that will let you reference a relationship of property on a related card of differnt type, but i think the following snippet may give you what you want by comparing the story card's iteration with a project variable (current iteration) to give a list of open stories that are past their planned iteration.


    {{ table query: SELECT name,number WHERE Type =story AND 'Story Status' <'Awaiting sign off' and iteration < (Current iteration)}}

    0
    Comment actions Permalink
  • Avatar
    Sbarton

    I tried that, but it says:


    Comparing between property ‘Planning Tree – Iteration’ and project variable (Current Iteration) is invalid as they are not associated with each other


    Any thoughts?

    0
    Comment actions Permalink
  • Avatar
    Ian Bridson
    Ok, I think you have to make the project variable available for that property, so go into Project variables and edit the (current Iteration). At the bottom put a check against the 'Planning Tree -itaration' property, and save. Then they should be associated.
    0
    Comment actions Permalink
  • Avatar
    Sbarton

    Awesome, I totally missed that, thanks!  It works perfectly now.

    0
    Comment actions Permalink
  • Avatar
    Huimin Li

    Hi Scott:


    Right now there is no mql syntax supported by Mingle to query child cards directly by property of their parents. However we do have story planned to support this, and hopefully it will come soon.  We will let you know when it is available.


    Thanks.

    0
    Comment actions Permalink
  • Avatar
    Jay Mitchell

    Hi All,

    We have added a beta feature to get children cards based on properties of parent cards in Mingle 3.3. This is rather technically referred to as "nested IN."

    Scot, If I understand your post correctly, your table query would be something like:



    {{ 
      table
        query: SELECT number, name 
                   WHERE type=Story 
                   AND 'Planning Tree - Iteration' IN (SELECT number WHERE 'end date' < TODAY)
    }}

    Note: I have split the query over multiple lines for readability. The query should be on a single line in Mingle.


    Thanks,
    Jay

    0
    Comment actions Permalink

Please sign in to leave a comment.