Can you string two table query's together?

Follow

Comments

2 comments

  • Avatar
    Cliff Morehead

    Hi Bryan,


    As long as your DEFECT Card Type has a "Date Created" property, the table query should work.  It might look something like:


    {{ table query: SELECT number, name WHERE type = Defect and 'Date Created' IS TODAY }}


    You can assign the existing "Date Created" property to the DEFECT card type by editing it in Project Admin | Card Properties, or you can create a new property for this purpose.


    Also, you'll want to ensure that for the DEFECT card, the "Date Created" property has a default value of (today).  You can do this be editing the card defaults for the DEFECT card type.  Let us know if this answers your question, thanks! -Cliff

  • Avatar
    Suzie Prince

    Bryan


    Try:


    {{ table query: SELECT number, name WHERE type = Defect AND 'Date Created' IS TODAY }} or {{ table query: SELECT number, name WHERE type = Defect AND 'Created on' IS TODAY }}


    This assumes stories and defects are different card types. If they are not you'll need to restrict in the properties that distinguish stories and defects. More help on MQL is available here.


    Let us know how that goes.


    - Suzie

Please sign in to leave a comment.