How do we filter stories which are without Sub-task by using JQL?

[Anh Le]

I searched and found some old answers but wonder whether there is any solution without using the plugin?

[Muhammad Ramzan(Atlassian Certified Master) · Accepted solution]

Unfortunately till now , no luck without plugins.

Just updating my answer, here is the plugin  JQL Search Extensions for Jira & reports  example if interested to use 

type = story and subtasksCount < 1

[Anh Le]

Hi,

The problem is, I'm using JQL in Google Sheets add-on. So I cannot use plugin.

[Daniel Turczanski - JQL Search Extensions]

Hi Anh,

JQL Search Extensions is our app and it integrates well with Jira's native search. Feel free to reach out to our support for help. Thanks!

[Alexander Bondarev]

Hi, @Daniel Turczanski - JQL Search Extensions !

Thank you for the app, it is really useful!👍

[Alexander Bondarev]

Hi, @Anh Le !

Like told @Muhammad Ramzan(Atlassian Certified Master) this is not possible.

Here you can check all the available JQL features in the Jira Cloud.

[Anh Le]

Hi,

The problem is, I'm using JQL in Google Sheets add-on. So I cannot use plugin.