Jira on-prem JQL search function needed to query issues that has a specific Exalate sync status in a specific connection

Originally asked by Michael Mohr on 05 July 2023 (original question)


To allow users from the business that does not have Jira system admin permissions and also no Jira DB access to view in a dashboard Jira issues that has currently a sync error for a Exalate connection that they are from business side responsible, a JQL function is needed that allows to search for issues that are under Exalate sync for a specific connection and have a specific Sync status, e.g. Error.

Currently we only know a JQL that allows normal users to search for issues that are sync_stuck, but that does not include issues with a sync error. So similar JQL function that reports issues under sync error for a connection would solve our request…Or even better a more general JQL that allows a connection and a set of Sync statuses as argument.


Answer by Mathieu Lepoutre on 15 September 2023

Hi

Please try:

issue in under_sync_by_connection("Connection name")

and

issue in sync_stuck("Connection name")

The stuck will have the same functionality than a connection in error.

Thank you.

Kind regards,
Mathieu Lepoutre


Answer by Michael Mohr on 21 September 2023

Hi Mathieu,

sorry but according to my knowledge issue in sync_stuck(“Connection name”) does not cover all existing error use cases and so does not fulfill our requirement.

Regards Michael


This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.