Using vote & comment counts from roadmap portal in JQL

Background

Jira service desk tickets are displayed as roadmap items on the customer facing roadmap portal. Any votes & comments are eventually associated with these tickets & roadmap boards.

It may be possible that you want to further your automation process by using number of votes/comments. In such scenarios, Roadmap portal lets you access this information via issue properties & custom fields.

Issue properties

Total count of roadmap portal comments can be accessed using the property roadmap_portal_comments. Below is an example of using this property in a JQL.

issue.property[roadmap_portal_comments].count >= 5 order by created DESC

Total count of roadmap portal votes can be accessed using the property roadmap_portal_votes. Below is an example of using this property in a JQL.

issuetype = 'feature' order by issue.property[roadmap_portal_votes].count desc

If one ticket is visible on multiple roadmap boards, these properties will show aggregate of all votes & comments on those boards.

Custom fields

Number of votes & counts on a ticket that are associated with a specific board can be accessed via custom fields. Each board when created in Roadmap portal app will also create 2 custom fields in that Jira project - one for maintaining count of votes & other for count of comments.

These custom fields can be found out from the board listing screen. Check the screenshot below:

These custom fields can be used in JQL queries.

Use cases

  • Sending an internal notification when number of comments on a roadmap item cross a threshold number.

  • Moving an item on the roadmap portal from column to the other depending on number of votes.

  • Creating an issue in a Jira software project when number of votes exceed on a roadmap portal card.

  • etc