Andy Heinzer Atlassian Team

The following query will return records for work logged at 24+ hours? worklogDate <= -1d And this one for work logged not in the last 24 hours? NOT worklogdate > -1d So ANDing them, isn't that kind of saying the same thing? Technically no, it is not exactly the same thing. These queries will not always return the same list…

After searching a bit more I came across another existing KB that explains this better and provides the next steps to follow: Using Integrated Security with MsSQL for Jira. This article explains in even more detail how to make this work with your version of Jira and older versions of Jira as well. Andy

Hi Adam, I understand you are looking to use windows authentication when Jira connects to your MS SQL database. I am afraid that the KB article Alexey linked to was accurate for Jira at least up until the 7.5.0 release. In the 7.5 version, Jira changed what database driver it is using in order to connect to MS SQL…

The interesting parts of these logs to me is this: 2017-11-29 09:13:30,416 automation-queue-claimer:thread-1 WARN [c.c.j.p.automation.queue.JiraAutomationQueueExecutor] Queue claimer could not claim from queue yet due to SQL exception. This is most likely due to the active object tables not being initialised yet…

Hi Chris, Sorry about that, I didn't think about the single quotes in the JQL itself. For that reason, it's probably better to use the double quotes to encapsulate the entire URL like this: curl -D- -u "email:password" -X GET -H "Content-Type: application/json"…

Great, thanks for letting us know. Glad to hear it's working now. Andy

I think Daniel is on the correct troubleshooting path here. Jira licenses are stored in the Jira database, not the specific machine itself. I would just like to also add the following questions that I think might be helpful here: * What version are you upgrading from? * What version are you upgrading to? * Do you have Jira…

Hi Greg, The specific feature you are referring here to is known as Jira Core Boards. These boards can exist in Jira Cloud specifically in Business projects that do not necessarily require Jira Software features of a Kanban or Scrum board. Unfortunately, at this time, this specific feature (Core boards) only exists in Jira…

The issue details view appearing as a popup window is a Jira Labs feature that you should be able to disable if you choose to. Please see https://community.atlassian.com/t5/Jira-questions/How-do-I-turn-off-issue-detail-popups-on-JIRA-boards/qaq-p/663559 for details. Please try to check and see if you can disable this…

It is possible that the XML import process failed, but Jira still appears to work anyways. The logs from the time of the import though would indicate if there was a problem here. I'm expecting there is probably some kind of SQL exception that happens during this XML restore with more details. The XML import will have a…

Anytime you make a change to SQL for the sake of Jira, you usually have to stop Jira first in order to make sure that any caches of such data are expunged. You could also restart Jira now to do the same. Also I think Josh is on the right path there, but I would add that it's probably a good idea to follow the Further…

Hi Sairam, I would like to take a closer look at your logs from this instance in order to better understand the current problem. In order to do that I created a support request on your behalf. Please follow the steps in that case and upload these logs so we can investigate this problem further. Regards, Andy

Hi Chelsea, The query you have will order these issues by their rank value. I'm curious to learn more about what you're trying to do here. You mentioned exporting this data. I'm curious if you are maybe trying to export all theses sprint issues in order to then import them again either here or on another Jira instance. If…

There are some users that when visiting https://support.atlassian.com/contact get redirected here to community as opposed to creating a ticket with our standard or premier support teams. For cases like that, I would welcome users to post their detailed steps of how to reproduce a specific bug and someone from our Atlassian…

Hi Mykola, Sorry there was a problem with this download. We have taken the steps to notify our release team of this problem. At this time the download link in question has been updated and is working. Again sorry for the inconvenience, and thanks for reporting this. Also this appears to be a duplicate of post of…

I'm not sure what would have changed recently. So I walked through this same set of commands in my Cloud instance and using your syntax I was able to reproduce this same problem. I then went back to a few of the examples from our developer REST API Tutorials. In looking at these I noticed that your URL string was note in…

If you click the box in the top right corner of that gadget, there is a menu to Edit. From there you should see a menu like this: You will note there is an option to change the "Sort Direction". This data either descending or ascending. Once you make this change you do need to save this gadget in order for this to be…

Hi Doods, Sorry to hear about this problem. However I am not sure how we can try to troubleshoot this problem without seeing more information about the logs from your system when this happens. Since our Community site isn't really geared for this just yet, I created a support request on your behalf. I would request that…

Hi Elif, That's an unusual problem. I was able to reproduce this problem in my 7.6.0 Jira Server instance. As such I created a new bug for this, as I have not been able to find any other reports of this specific defect. Please follow https://jira.atlassian.com/browse/JRASERVER-66408 for updates on this. Thanks for bringing…

Hi Jens, The https://jira.atlassian.com is actually the correct site to use in order to file a new feature request. And you actually can create an issue type of Suggestion there. However you cannot create a bug report on that same project at this time. The ability to create Bug issue types is restricted to Atlassians and a…

Sorry about that, I edited my previous reply to fix the link, but here it is once more as well: How do you add a column to "Issues in Epic" panel

In regards to part #1, there is a problem with this approach. Jira's JQL is designed to search for Jira issues. Meaning that JQL is designed to return Jira issues. It's not designed to return the attachments contained within these issues natively. Jira's native JQL does have a "Attachments" field you can search in JQL. But…

Hi, Just wanted to let you know that our Crucible release team found a new problem because of this report and have since fixed this problem. Thanks for posting this, that download appears to be working now. Cheers, Andy

Hi Daniel, Sorry to hear that there have been intermittent problems in regards to customers getting notifications from Service Desk. I would recommend starting with the KB How to Troubleshoot email notifications in JIRA Service Desk. If you can walk through this, I suspect that you would need to enable some DEBUG level…

Hi Team, I will try to answer each of your questions: * Jira Service Desk is just a plugin for Jira itself. As such there are no other file locations, outside the ones mentioned in that document, that would be only of Service Desk. * More recent versions of Service Desk have allowed you to begin to customize the customer…

Hi John, This layout is something that changed in Jira Cloud back in January of 2017. There does not appear to be a means to alter the layout of these fields on the boards/backlogs at this time. There is an existing feature request to allow users to change this back in https://jira.atlassian.com/browse/JSWCLOUD-15521 I…

Hi Nick, Sorry to hear that you are seeing this problem, however I have not been able to find any other reported instances of this specific error message either publicly or in other support cases yet with Atlassian. The gist of this error is that there is some piece of data that cannot be stored to SQL due to constraints…

The only other way to restrict when an issue in Jira can have attachments added to it would be through the use of workflow properties. You could add a property such as jira.permission.attach.group = Group-name To all the statuses after a certain point in the workflow. When this is set, only users in that specific group can…

Hi Stephanie, I don't believe there is a way to customize this within Jira itself, at least not without changing some source code or using a plugin for Jira. However a related thread appears to have had some success with other users that might be able to use a script as a means to add an additional field for issues there.…

Hi Maria, I am afraid not. The version compatibility of JSD 3.9.0 is only compatible with Jira Server 7.6.0. This matrix of compatible versions is listed on https://marketplace.atlassian.com/plugins/com.atlassian.servicedesk.application/versions As such, in order to upgrade JSD, you would need to first upgrade Jira Core to…