Benjamin_tmh9yg Community Champion

Just in time. Adaptavist ScripRunner has posted an example in their library: https://library.adaptavist.com/entity/display-sql-results-from-an-external-database-macro?_ga=2.80182935.1498145943.1664401883-1216766160.1598983343 This should get your what you need. -Ben

HI @Romy Meyers , Would have been great if it was extended to other types of DB. Perhaps you can use a Power BI connector to extract the data for Analytics. Maybe a worthwhile approach: https://marketplace.atlassian.com/apps/1224059/microsoft-power-bi-connector-for-jira?tab=overview&hosting=cloud -Ben

hola @Albert Ferney Rojas A. Esa no es una característica que sea parte de JSM. Puede haber complementos del mercado que puedan proporcionar la capacidad de poner todas las respuestas en mayúsculas. o necesitaría un script para hacer la conversión de texto.

HI @Steven Baynes You might want to submit a ticket with the vendor to double check. https://jqlsearchextensions.atlassian.net/servicedesk/customer/portal/2 Usually custom fields don't have these options. -Ben

HI @vishalp1 , Should be able to use a query like this. Issuetype in (story, sub-task) See example post below: https://community.atlassian.com/t5/Jira-questions/I-am-looking-for-a-JQL-to-list-all-stories-and-subtasks-similar/qaq-p/1227382 Thanks, Ben

Hi @bstinson , Not aware a feature like this out of the box for the Jira side. For the portal side, there is the option to only share with members within a customer organization. You may want to look into extension for Jira Service Management add-on to see if there's is that level of granularity. Thanks, Ben

Hi @Jean Bisson , The issue you are encountering seems similar to this KB article. Might want to take a look : https://confluence.atlassian.com/jirakb/imap-fails-with-a3-bad-user-is-authenticated-but-not-connected-error-in-jira-server-integrated-with-office365-665420269.html -Ben

HI @Romy Meyers , This Jira Cloud marketplace connector may help you with the problem you are facing: https://marketplace.atlassian.com/apps/1221074/database-exporter-for-jira-cloud?tab=overview&hosting=cloud This will allow to export the data and send it over to your desired DB. -Ben

Hi @Carla Valdegas , ScriptRunner is one way of doing it. There's a number of add-ons that helps display SQL data in confluence as well in the market place. For example, this one below: https://marketplace.atlassian.com/apps/225/sql-for-confluence-pro-edition?tab=overview&hosting=datacenter -BEn

Hi @Jesús Rafael Martínez Jiménez Here's a video good video tutorial to help with this: https://www.youtube.com/watch?v=iSEJ6ZUYLrE -Ben

Hi @wendy seemann Left, Center and Right alignment is there when editing. If you need justify, there's work arounds posted by the community. Here's a few articles: https://community.atlassian.com/t5/Confluence-questions/How-to-left-align-for-pages-in-confluence/qaq-p/1016722…

Hi @sampsasaarela , Here's the Atlassian documentation : https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-remote-links/#api-group-issue-remote-links This can only be done by issue ID. You may be better off using a JQL to grab all issues related to a version.…

HI @Zero Zhang , Would recommend clearing the cache. I find this helps with stale data in the browser. I have JSM as well and I don't see this issue. Perhaps you may want to note down the platform and/or version you are using. Maybe someone else may have experience the same issue on the same version. Thanks, Ben

Hi @Derek , Would recommend to tail or to trace the log when attempting the connection to get further details on what issue you encountering for the failure. The failure could be for any number of reason. Usually, its the fail handshake. Also, recommend to open a Atlassian support ticket at the same time and attach the…

アドオンのこのオプションは表示されませんでした。ドキュメントは次のとおりです: https://docs.ricksoft-inc.com/wbs-gantt-chart-for-jira-data-center-and-server-0914/これに対する解決策があるかどうかを確認するために、ベンダーにチケットを発行することをお勧めします。https://ricksoft-support.atlassian.net/servicedesk/customer/portal/3

@Kavya Shankarappa - There is no option to change sizing for the panel macro this includes the title portion. You can use some like page section to reduce the panel width. Here's a guide on how to do that: https://confluence.atlassian.com/doc/page-layouts-columns-and-sections-275188613.html -Ben

Welcome to the community!

Thanks for sharing the version. It maybe worth to do the upgrade to get these options and any new features that come with the latest version. -Ben

That seems reasonable. Would suggest investigating your jira logs and your browser developer console to see if anything else is happening besides login transactions. Possibly errors that it is trying to self correct or timeouts. -Ben

Thanks for the clarification. Here's the documentation to configure what you need. Created date is supported. https://confluence.atlassian.com/servicemanagementserver/configuring-request-view-1095250690.html

Sound good. Make sure to test everything out with stage server instance and a sandbox cloud environment before moving everything over. Good luck with your migration. 

Hi @lzp , I have several instances where I don't have issue with slow login. Perhaps there is some network congestion. How long is the sync when you try to sync the users from AD manually? -Ben

Hi @Campo Vicens , Insight is commonly the way to go in terms of integrations. But there are alternatives in the market place. For example: https://marketplace.atlassian.com/apps/1222692/asset-management-for-jira?tab=overview&hosting=cloud -Ben

Correct. That is the distinction between server and cloud. Cloud unique identifier for users is by e-mail. As long as the e-mail matches up from server to cloud, then it should align your data when migrating over. -Ben

@Mohamed Saad Taha , The create date value is system generate. It is not editable. -Ben 

Hi @Fuwang Chen , you can limit scope: https://developer.atlassian.com/cloud/confluence/modules/webhook/?_ga=2.76567581.927094752.1578391387-1080961822.1564054573 or you can use an add-on to manage your Webhooks: https://marketplace.atlassian.com/apps/1222102/webhook-manager-for-confluence-cloud?tab=overview&hosting=cloud…

Hi @Alexey Gusev, Should be the same. Could be a bug. Would recommend contacting ScriptRunner support: https://productsupport.adaptavist.com/servicedesk/customer/portal/2/user/login?destination=portal%2F2 -Ben 

Hi @Carlos Ceballos , Here's a documentation on Jira Align for user stories: https://help.jiraalign.com/hc/en-us/articles/115005732267-Manage-stories The Jira Board column status may not match exactly to the actual status. Make sure to inspect the board configuration to see what status is mapped to the Done column. -Ben 

Hi @joecline , Probably not. Based on what is mention, it sounds like a non-standard Atlassian approach to archiving. If you can, start jira and confluence data up, you maybe able to save the data. Please keep in mind, you may need to be on minimum version in order to migrate the data to Cloud or DC platform. -Ben

Hi @Boyd K , Here's s documentation that may point you in the right direction: https://bigbrassband.com/overview.html -Ben