Is there a way to find all Open Jiras linked to a closed Salesforce ticket?

Robert G. Nadon
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 2, 2019

Hi all,

I am looking for some sort of tool to run, preferably from a command line, that will give me all Jira issues that have a Salesforce Issue link to a salesforce Issue that is closed.  From there I can figure out through the CLI if the Jira is in a status that we consider open.  And if so send a report of the Jiras that need to be cleaned up.

Is this a possible thing to do?

Thanks!

Robert

2 answers

1 accepted

2 votes
Answer accepted
Robert G. Nadon
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 16, 2019

It appears this command does basically what I am looking for:

"Salesforce Case Reference" in remoteObjects("Status", "Closed") and Status != Closed

Though this command is not returning all of the hits I believe that is because of the caching issue with the plugin and I can increase that (at the possible expense of performance) 

0 votes
Pablo Gamblin _ServiceRocket_ April 11, 2019

Hi Robert,

 

Reporting on Jira issues associated to a Salesforce object is not possible using the Connector.  However this has been one of our most requested feature over at our ideas page at the following lik:

 

When you view the request and have a registered account, you may vote on the feature as well as leave a comment explaining your use case and/or why this would be an important feature to have. 

 

Best Regards,

 

Pablo Gamblin

ServiceRocket APps Support

Robert G. Nadon
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 26, 2019

Hi @Pablo Gamblin _ServiceRocket_

Thanks but that link states about generating a salesforce.com report about related Jira issues.   That is not really what I am trying to do.  More of the opposite from Jira a report of all issues that have a salesforce reference.  with that Status of the salesforce issue.   So possibly something like remoteObjects() that will list all Jiras that have a salesforce object link and the status of the salesforce reference is closed.

Thanks,

Robert

Duy Tran Quang April 10, 2024

hi @Pablo Gamblin _ServiceRocket_ 
the link you shared is broken, what is the latest status of the feature request ? 
thank you 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events