Hi Experts, I am trying to do a table query on a wiki page to create a top ten list of biggest stories. Can I do a select top 10, or limit rowcount to, or something? I can't find the right syntax. Thanks!
Top N Results
Hi Experts, I am trying to do a table query on a wiki page to create a top ten list of biggest stories. Can I do a select top 10, or limit rowcount to, or something? I can't find the right syntax. Thanks!
Comments
5 comments
Hey Scot
What do you mean by biggest? Largest number "estimate" property?
Thanks
- Suzie
Thanks for the fast response! Largest number, but I have several "top 10" lists I would like to create. Top ten oldest issues, etc. I can "order by" what I want I just don't know the keyword to limit the return.
Hi Scot,
Unfortunately, there isn't a native way to do this using a table query. I have added your request to our story backlog.
In the meantime, you could accomplish this with a custom macro. The enhanced table macro might be a good reference / starting point for this type of macro.
Thanks,
Jay
I'd really like this also. I'm building a dashboard of defect activity, showing the most recent logged defects. In SQL, I would write something like: "select top 10 * and a ordby clause" In MQL, it might be:
{{ table query: SELECT top 10 number, name, 'Claimed by, owner, 'QA Platform', 'QAT Browser', whiteboard WHERE type = defect order by 'Added on' desc}}
This would give me a list of the last 10 opened defects.... As it is, I an do it by relative time (like last 2 days), but depending on activity, that really makes the list length accordion. I want to limit it to a specific size.
-stone
We'd like this too.. we have a table on our overview page with "highest effort cards" or similar, that we currently manually adjust the threshhold... would be nice to have it just get the top-n of them.
regards,
Mike
Please sign in to leave a comment.