JQL to include all Updates to all Projects and Tasks

Question

I recently integrated Jira with SharePoint and I am trying to write a JQL query that would update Sharepoint with any updates if there are any new tasks or subtasks created in any epics within any of the projects in Jira.

So basically ALL/NEW tasks in ALL/NEW epics in ALL/NEW Projects.

It works when I specify just one project like JQL: PROJECT = "Sample Project "

Issue link

* created
* deleted

Comment

* created
* updated
* deleted

Issue

* created
* updated

But I want it to apply to all projects. All updates for all Projects

Jack Brickey · Answer

first I would advise against deleting ANY issues in Jira. You cannot query on any deletions. That said, if your webhook works to update SP then you should be able to use any JQL so if you create the JQL I mentioned above it should provide you updates to existing issues. You can add more to the JQL to meet your needs.

Melvin Elendu · Answer

I appreciate you reaching out, I have created a page on my Sharepoint site to show all project updates from Jira. I would like a scenario where any changes (New Tasks/ Issues/ Epics/ Subtasks, Deleted Tasks/ Issues/ Epics/ SubTasks, etc) to projects in Jira are shown in Sharepoint.

At this point, the JQL in the webhook I created is Project = "Sample project", which is a project I created to test the integration. But that only works for New Tasks/ Issues/ Subtasks (Tested), but does not update for Deleted Tasks/ Issues Epics/ SubTasks, etc, regardless of the selections I made in the webhook for related events.

I would like updates on SharePoint for all events applying to all projects.

I hope that provides more clarity. Thanks

Jack Brickey · Answer

how is your JQL going to update Sharepoint? You mention new issues created but then further in you mention any updates at all. What is your actual goal? can you provide the JQL that you say works for you w/ single project as a starting point?

you could create a filter and subscription to run daily to show update w/in the past day, e.g.

updated >= startOfDay("-1d")