Muhammad Ramzan_Atlassian Certified Master_ Expert

Dear @Upendar i tried the query and its working perfectly. Please follow the steps as below 1) Install the plugin 2)Use this query issue in linkedByIssueProject("ServiceDeskProjectID") It will give you all issues list where a link of your service desk is created with other projects. 

I even tried the default settings, once project was created by atlassian command i just installed the plugin with same settings as it is but no success 

Thanks for your kind reply. Yes , plugin is enabled on Bamboo , i verified and in logs everything is fine. I crated using " atlas-create-refapp-plugin", its working on JIRA and i can access the rest url in JIRA. But in Bamboo i can't , i tried even using the Rest Browser plugin, but no url found.

To copy the project template, you can use jira project (shared option Go to projects Create new project and select the option "Create with shared configuration"

My bad, i missed this, updating my answer with your suggested answer.

In project permission change it as Browse project: any one For board to be as public , please follow steps as * Go to your board > Configure * Find the 'Shares' section and click 'Edit Filter Shares; * Add Viewers and select 'Public' * Click Add and Save Thanks @Thomas B for the reminder

this rest will copy the board in same project. How we can copy the board a new project?

If really its working as you explained then its really usefull but plesse correct me if i am wrong

Can you please explain how? I ised this plugin but its totally different. What my understanding is You are creating a local db which h2 ,here someone can write queries but as per the questions context, someone cannot run a sql query as jql or jql query on sql server

yes its possible, If you want to make one space public and other spaces private then make that space with anonymous access . If you want few pages inside one space public and few pages private, then make the whole space as anonymous and for those pages which you want private, apply the restrictions.

please note above links is to get issues from external website, not to display issues. 

Its possible to embed jira issues to your webiste using jira issue collector. please read the following article and you will get an idea. https://confluence.atlassian.com/adminjiraserver071/using-the-issue-collector-802592637.html

Try to use following query , it will give you all the results with least one issue from project you will mention. For example Following query will return all the issues which have atleast one link with project "test" issue in links("project = test") if you want to search issues by project and link type for example relates…

something like this

Why not to use the JQL to fetch is issues in an epic and in column add the story point epic. 

What i did is, i am using Jira service desk where i have created a permission request screen. User will fill the data, project, his/her role . once request is created it will come to the admin. Once admin , move to resolved, user will automatically get the required access to the project. How? there is a groovy script…

1) check your global mail setting are configured correctly 2 ) Go to service desk project setting 3) Go to " notification" tab and here you will see the notification scheme settings. check the settings there. i think those configurations are missing. 

you mentioned SQL, are you trying for jql or sql query?

You want to get records only or card colors

Following queries can help you to find the required results. Its not provided by default with JIRA but this plugin is helpful for such queries. All issues updated by a user, it will fetch all issues where user performed any update action issue in updatedByUser("username" Following query will get all issues, where the user…

please use following query project= "umbrellaprojectname" or sprint in openSprints()

you can use your won queries , what is the issue you are facing?

Right now there is no way to convert SQL into JQL , the above plugin you mentioned , i used it before its not about converting SQL to JQL, what they are doing is, for each session they are creating local H2 db , where you can run you queries as SQL queries but its not the actual database of the jira.

There is no straightforward way to do that, this plugin can help you to find the required results. Here is the query which will return the required results. issue in commentedBetween("2019-07-01", "2019-07-24") and issue in commentedByUser("membersOf(jira-administrators)") How to use issue in commentedBetween("startdate",…

Sorry for late reply , but here is the query which you are looking for , supported by plugin. issue in commentedByUser("membersOf(jira-users)" ) and issue in commentedBetween("2019-07-21", "2019-07-27") issue in commentedByUser("membersOf(groupname)" ) and issue in commentedBetween("startdate", "enddate") how to use There…

There is no straightforward way to do that, this plugin can help you to find the required results Following queries are very useful for scrum masters to get the releases as per their requirements. This will get the releases versions in a specific date range…

You need to do following steps 1) Edit the board filter of the project where you want to show service desk tickets and include the ticket types in filter. 2) after completing step 1, tickets will start appearing Now drag the tickets to required sprint or edit the ticket and select the sprint in ticket

This query will resolve your issue and you will get the issues where a person recorded hours during a day. The trick/key here is the function loggedTimeByUser provided by the plugin if a person recorded their hours, this function will return the issues , now to filter the issues you need the updated date, as when they…

did you recently changed the project key?

following query will give you the required results which you are looking for. issue in updatedByUser("username") and resolution was Done its offered by a third party plugin which i am using for my day to day queries They are a lot of extended queries and helped me a lot to resolve a lot of issues. here is the documentation…