Stream: JIRA/Confluence
Topic: Jira ballot filter?
Paul Denning (Nov 20 2019 at 17:24):
How can I find ballot comments submitted for the Sept 2019 ballot?
Joshua Procious (Nov 20 2019 at 18:08):
Hello Paul, I will defer to @Lloyd McKenzie on this generally speaking. However, was there a specific balloted item you were looking for comments on?
Joshua Procious (Nov 20 2019 at 18:18):
@Paul Denning Here is a query that pulls all Change Requests (to include comments) from the 2019 Ballot Cycle. You can use the "Contains Text" search to drill down further. https://jira.hl7.org/browse/FHIR-23612?jql=project%20%3D%20FHIR%20AND%20issuetype%20in%20(%22Change%20Request%22%2C%20%22Technical%20Correction%22)%20AND%20created%20%3E%3D%202019-08-09%20AND%20created%20%3C%3D%202019-09-09
Paul Denning (Nov 20 2019 at 18:27):
so basically just the created date is during the comment period for the ballot?
Lloyd McKenzie (Nov 20 2019 at 18:36):
There's a better way, but I don't have time to dig tonight. I'll post something tomorrow - and perhaps start a page documenting common queries.
Joshua Procious (Nov 20 2019 at 19:55):
(deleted)
Paul Denning (Nov 21 2019 at 20:30):
Just noticed https://confluence.hl7.org/display/HL7/Changes+from+gForge which says Ballot-related fields (Ballot, Ballot Weight) are no longer tracked as part of the Specification feedback issue. Instead, they're managed as children of the Ballot Submission issues
Lloyd McKenzie (Nov 21 2019 at 20:35):
Yes, but there are links from the ballot vote to the item, so it's still possible to filter. I'm sorry I haven't posted the solution yet. DevDays has been keeping me hopping :(
Lloyd McKenzie (Nov 22 2019 at 21:37):
I've finally gotten to this. I'm pretty sure I can make it work, but it's too ugly to be practical for most people, so I'm going to try putting together a custom JQL function that will make it much easier. It may take a day or two to get that finished. I'm sorry for the delay (and sorry for not having a solution already in place for performing such a common function).
May Terry (Dec 08 2019 at 18:30):
@Lloyd McKenzie - have we come up with the filter so I can see the ballot and ballot weight? Right now, I'm comparing an old export of GForge issues (which I had done before GForge FHIR issue navigation was shutdown) with a current export in JIRA by ticket to figure this out and it's pretty cumbersome. :-(
Lloyd McKenzie (Dec 12 2019 at 03:40):
@Paul Denning @May Terry (and everyone else). Sorry this has taken so long. I finally have a function that will provide a list of issues that are tied to ballot comments. It works like this:
issueFunction in InBallot("2019-Sep - FHIR IG CDex R1 STU")
That will return all of the FHIR (and eventually other product family) issues that are referred to by the specified ballot. (You can see the ballot codes either in the BALDEF records or in the BALLOT records). You can add additional filters such as status, submitter, grouping and other things too if you like - It acts as a filter on the list of issues like any other filter.
I hope to have a variant of the function that allows you to filter to only those things that have negative votes or 'open' (i.e. non-withdrawn) votes, but that's still a work in progress.
@May Terry I'll next be working on a ballot reconciliation spreadsheet export that should give you everything you're looking for.
Lloyd McKenzie (Dec 13 2019 at 04:52):
Josh fixed a couple of things in Jira and the enhanced functionality now works. To filter for only issues that have negative votes for a given ballot:
issueFunction in InBallot("2019-Sep - FHIR IG CDex R1 STU", "NEG")
To search for 'open' ballots (those not withdrawn or otherwise resolved)
issueFunction in InBallot("2019-Sep - FHIR IG CDex R1 STU", "OPEN")
To search for negative and open ballots:
`issueFunction in InBallot("2019-Sep - FHIR IG CDex R1 STU", "NEG,OPEN")
If you want to you can search for AFFIRM or AFFIRM,OPEN too
If you have questions, holler
Last updated: Apr 12 2022 at 19:14 UTC
