Produce a list of JSD tickets based on the JIRA project item status without having access to JIRA PR

[WTsdUser]

Is there a way to produce a list of Service Desk items on a confluence page that are derived from the JIRA project without having access to the JIRA project?

I would like to produce a list of Service Desk items based on a query that reads the data from the JIRA project where I do not have access to the JIRA project.

I have access to the confluence page, I have access to the JIRA Service Desk BUT do not have access to the underlying JIRA project. 

is there a way to use the result of a JIRA project query as the input for a JIRA Service Desk query? keep in mid that I do not have access to the JIRA project.

[WTsdUser]

Thank you for your prompt response I understand how to use issue filters in confluence, the issue that I have is I am not getting any results for the below where; Project msZZsd is the JIRA Service Desk and MSZZ is the underlying JIRA task project where I do not have access to MSZZ and therefore get an error "MSZZ either does not exist or I do not have permission to access MSZZ."

Below is the filter in JIRA Service Desk

project = msZZsd and  issuefunction in linkedissuesof( 'project = MSZZ and sprint in openSprints()  ')

[Brant Schroeder]

In Jira do you see any results?

[WTsdUser]

no not from JIRA Service Desk project msZZsd as the query contains a reference to project MSZZ

[Brant Schroeder]

As stated previously permissions in Jira are the same in Confluence.  If you are unable to see issues in Jira you will not see them in Confluence.

[Brant Schroeder]

You can use the Jira Issues Macro in Confluence to display Jira issues on a Confluence page.  You can create your own JQL in the Macro.  

You can find documentation here:  https://confluence.atlassian.com/doc/jira-issues-macro-139380.html

You will need to work with your Jira and Confluence administrator to ensure that an application link exists between Confluence and Jira.  

You stated that you have access to the Jira Service Desk but do not have access to the underlying project.   If you have access to query issues for that project in Jira using JQL you will be able to see them in Confluence.  The permissions in Confluence are inherited from Jira.