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

[Robert G. Nadon]

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

[Robert G. Nadon · Accepted solution]

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) 

[Pablo Gamblin _ServiceRocket_]

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:

• https://ideas.atlassian.servicerocket.com/ideas/SFJC-I-25

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]

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]

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