JIRA Query for top 50 ranked issues

sarahjohn.s388's Avatar


23 Sep, 2017 09:16 AM

I would like to set up a Kanban board where my todo column consists of the top 50 ranked issues with the Open status. Is there a
JIRA(https://mindmajix.com/jira-training) JQL statement that can accomplish that?

  1. Support Staff 1 Posted by Richard Parslow on 23 Sep, 2017 12:33 PM

    Richard Parslow's Avatar

    Hello Sarah

    Thanks for your inquiry.

    Yes: in Goalscape Online you can upload a CSV file containing a hierarchy of goals (or 'issues', or any other data) as a Goalscape project. So if your source tool can export a CSV file you can import it into Goalscape as a visual representation of your 'Open issues' breakdown.

    The source CSV file must have a column for each level of goals: Main + at least 1 level of subgoals. The columns must be headed 'Main', 'L1', 'L2'... (so the data appears as an indented list).

    The attached screenshots show a basic hierarchy in a CSV file and how this will appear as a Goalscape project. The CSV file itself is also attached, so you can use it as a template when you create your own file.

    You can also include columns for any other attribute information supported by Goalscape: Importance, Progress, Due Date, Notes, etc. These columns are not mandatory, but if included they must have the correct header labels and the data must conform to the relevant Goalscape rules.

    You can see the full format and contents if you export a Goalscape project. All the requirements and rules are shown on this page of our Knowledge Base.

    Once you have uploaded your data into Goalscape Online you can use Goalscape's functionality to add detail: drag the goal slices (or use the slider) to change Importance, Color or Mark goals, set Dates, enter Progress, add Notes and Attachments, etc.

    There is no limit to the total number of goals you can have in your project, as long as each goal has a row to itself and its name appears in the correct column. Note though that if you are a Goalscape Free user, you will only be able to upload 1 project; and if it has more than 30 goals you will not be able to add any more (although you will be able to edit any of the attributes on all the existing goals).

    Note too that in Goalscape Online you can Share projects with any number of others. So if you are giving a course you can share it with all the students privately. You can even give Free users Edit access to a shared project (and if you buy an Unlimited subscription you can create a personalised project for each student and share it only with that student). You can also make a project Public, so anyone with the project URL can access it and read all its contents (View only), without needing to sign in to Goalscape Online.

    If you have not yet tried Goalscape Online you can register for a Free User account.

    The 'Import Goalscape CSV' function is not yet available in Goalscape Desktop; it will however be in the next Goalscape Desktop updates, due to be released tomorrow (Sunday, September 24).

    If I have misunderstood what you are asking here, or if you have any other questions, please post again.

    Enjoy the journey!


  2. Support Staff 2 Posted by Richard Parslow on 07 Oct, 2017 12:55 PM

    Richard Parslow's Avatar

    Hello Sarah

    Quick follow-up: the full requirements for the CSV source file are now in our Knowledge Base and we have made a short video (1' 37") about it.

    Keep achieving great goals!


Discussions are closed to public comments.
If you need help with Goalscape please start a new discussion.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac