How can i add a column for or use JQL in a query to specify count of stories belonging to an epic?

[Deleted user]

I am interested in but cannot find a way to

1. expose the count of stories belonging to an epic as an attribute on Kanban cards and to select from fields to add as a column in a filtered view
2. use JQL to isolate epics that have no stories or have < some number of stories
3. use JQL to isolate stories that do not belong to an epic 

[Nic Brough -Adaptavist- · Accepted solution]

The easiest way to points 1 and 2 is to have a field that holds that number.

You'll need a scripted or automated field that can update on every new story, or change of epic link on existing stories.  Then you'll be able to do JQL like "epic story count < 32", put the number on the cards, and use it as a sortable column in filters.

Point 3 is already in place, if I have understood it correctly - you can say "Epic Link is empty and issuetype not in subTaskIssueTypes()"  (Sub-tasks take their Epic from their parent, but don't expose it to JQL, so you need the second clause to say to ignore them)