Articles in this section

See more

How to sort tables by name rather than card #?

Avatar
Michael Green
Updated
Follow 

Hi folks,

  How can I sort the "Defect Reported in Sprint" by the name of the card, rather than the card number?

 

Here is the MQL:

                
                  table
                    query: SELECT 'Defect Reported in Sprint', count(*), SUM('Defect Estimate'), SUM('Actual Effort') WHERE 'Type' IN ('Defect') 
                
  

 

regards,

 

Mike

Code Snippet


table
query: SELECT 'Defect Reported in Sprint', count(*), SUM('Defect Estimate'), SUM('Actual Effort') WHERE 'Type' IN ('Defect')

Comments

3 comments

Sort by Date Votes
  • Avatar
    Suzie Prince

    Hi Mike


    You can use ORDER BY.


    {{ 


    table
    query: SELECT 'Defect Reported in Sprint', count(*), SUM('Defect Estimate'), SUM('Actual Effort') WHERE 'Type' IN ('Defect') ORDER BY name


    }}


    Hope that helps.


    - Suzie

    0
    Permalink
  • Avatar
    Suzie Prince

    Oh actaully I just looked closer at that... I'm not sure if that is going to work because the property value is the number and the name.


    You could acheive that by creating the table differently like this:


    {{ 


    table
    query: SELECT 'name', count(*), "Sum of Defect Estimate", "SUM of Actual Effort" WHERE Type = Sprint ORDER BY name


    }}


    This assumes that Sprints and Defects are related in a tree structure and that you can created two aggregates called "Sum of Defect Estimate" and "SUM of Actual Effort'". This will give you a list of the sprints (sorted by name) with column for count and the two aggregates. 


    I hope that makes sense.


    - Suzie

    0
    Permalink
  • Avatar
    Michael Green

    Hi Suzie,


       Here's what I get with that... 


     


    thanks,


    Mike


     


    0
    Permalink

Please sign in to leave a comment.