Ramakrishnan Srinivasan_irs0rl Specialist

Hi, We are measuring some data on Merged Pull requests and developed user macros in Confluence. In Bitbucket GUI I see the line ".... remotely merged the pull request from branch A to branch B" for auto merged pull requests. But I could not find a way to get that from REST API or from SQL queries. Can anyone help me on how…

Hi, We have many platform products which uses SQL dB and developers commit the SQL schema files to Bitbucket. The product managers were requesting whether we can show the code diff between versions of specific SQL files using two tags or between tag and a branch. I could not find any API to compare only a single files in a…

Hi, I need some help in disabling Cascading Select Parent Options by running the script monthly once. Lets say I have two cascade select fields Field 1 with parent options 'Dec'-19', 'Jan-19', 'Feb-19','Mar-19 Field 2 with parent options ' 'Dec'-19', 'Jan-19', 'Feb-19','Mar-19 Requirement is * Field 1, except for Dec-19, I…

Hi, Before upgrading to 7.4.11, we had user macros with enum values as options with "&" symbol and they were working fine. But after upgrade we observe that user macro is not working when user selects the option with & symbol like "name&product". When user selects "all" enum option in the macro below, it works fine and…

Hi, I tried to get user name from email using ScriptRunner for Confluence. I tried the following code in scriptrunner console, import com.atlassian.sal.api.component.ComponentLocator import com.atlassian.confluence.user.UserAccessor def userAccessor = ComponentLocator.getComponent(UserAccessor) def users =…

Hi, I need some help in Custom Cascade Field, I have created a Cascade Custom Field with * parent options = 'Jan-19' , 'Feb-19', 'Mar-19' * child options = '0%', '25%', '50%', '75%', '100%' I know that for parent option, 'None' is one of the options. I know how to get the value of selected parent option like Map p1m0 =…

Hi, I have made some customization of pdf export of a Confluence page. Sharing my approach here for others to try/benefit. My Setup: * Confluence Server - 7.3.2 * Script Runner for Confluence - 6.2.0-p5 * Table Filter and Charts for Confluence - 5.3.25 * Confluence has HTML macro enabled My Approach: * Create Custom Menu…

Hi, I am sharing this information for others to benefit. All our Atlassian products are in Server deployment. All applications are linked with Applink configuration. Requirement: * Develop a Confluence Script Runner macro for user to select JIRA Project* JIRA Projects listed using SQL query and HTML Select * Map selected…

Hi, I need help in getting SQL query matching a REST API call and its output. We have Tag Maker add-on installed in out Bitbucket Server instance (v5.15.0 version) My Bitbucket REST API is https://domain/bb/rest/api/1.0/projects/MYPROJECT/repos/xyz/tags/XYZ-C_3_5_17_0 The output is…

Hi, I am trying to get SQL query to work to map branches and tags. I have these two REST APIs to same Project and slug, giving same json output .../bb/rest/api/1.0/projects/<PROJECT_X>/repos/<slug_y>/commits/71f5cc3eb287bad159abb68bd695b7972f706f8a…

Hi, I need some help in a use case. We have a Multi Select Custom Field named 'Program'. We keep adding new options to this custom field when new programs are initiated in our production. I want to create a new Issue whenever there is a new option added to this custom field but without any issue context. Is this possible…

Hi, Need some help in hiding issue link type options by name. I have "Easy Links for JIRA" add-on deployed in our JIRA 7 server. It allows to pick multiple issues as links. I have to create multiple such fields. Now, I want users to use only the issue selection custom field and should not be able to add the custom link…

Hi, I need some help. We have "Feature Request" issue type which addresses customer requirements. So, I have 15 Custom project pickers and one Single Select Branch field associated for each of those project pickers. These Branch fields are with 2500+ options in each (15 x 2500). When the Project picker value changes, I am…

Hi, I have tried some methods and could not succeed, I need some help in creating the new issue using script runner script console. The use case is I have to create issues in project 'POWN' with a project picker and user picker values set - both are single selects. Without these two custom fields I am able to create the…

Hi, I need some help in displaying only part of the option string to the user. Let's say I have a Single Select with options Test_CGMS 10.0, Test_CGMS 11.0. I understand these options have their unique IDs. So, in the GUI, is it possible for me only to display CGMS 10.0, CGMS 11.0 to the user. If possible, how do I do…

Hi, I need some help, I am able to filter project picker list with this behavior script given below But, after I get the filtered list, the "None" option is not present. I need to have the None option and it has to be the first option. Can anyone please help me on how to add None at the top of the project options import…

Hi, I need some help, I have a user macro and using the Velocity template code like the one below I am getting the last month and current month. When my colleagues try in Shanghai, it is not giving correct result, their local character is shown in the Postgreqsql error message like '一月-19' and I am not sure what I have to…

Hi, I need some help in work flow step Linked Status configuration. Lets say I create an issue and there is a custom field radio button "Fast Track" with Yes and No option. User selects either Yes or No; No is default. * If flag is 'No' I want Linked Status to the 'Create' work flow step to be 'PLM : Review'* The…

Hi, I need some help in adding one primary project and variable list of secondary projects to one issue. I am familiar with custom field creations and so on. I am configuring JIRA to take new customer feature requirements and start the work flow with engineering. Our company is providing solutions and one requirement…

Hi, I have six custom fields to get the total of six pairs of other fields. So, the logic is same to get the total. So I want to write the condition where * if the script is running inside a scripted field with name 'Total Field X', get the total of respective fields belonging to X * if the script is running inside a…

Hi, I need some help in setting up dynamic maintenance of Cascade Select field month on month. Our JIRA version is 7.12.3 with Postgresql I do not have write permission to dB so back-end update is not possible. Say I have a cascade field with parent option = "Dec-18", "Jan-19","Feb-19","Mar-19" each with Child Options =…