Code to live

How to replace the last or first character of the string in excel?

May 13, 2023 1 minute read

There are various use cases to remove the tail end character, like replacing the alias name, ex: 16 seconds or 16s to 16. It can be trimmed using the excel i...

How do I detect a browser or tab closing using router deactivate in Angular?

April 25, 2023 1 minute read

There is no built-in way to detect when the browser or tab is closed in Angular, but you can use the window object’s ‘beforeunload’ event to trigger an event...

How do I detect a browser or tab closing using hostlistener in Angular?

April 25, 2023 1 minute read

There is no built-in way to detect when the browser or tab is closed in Angular, but you can use the window object’s ‘beforeunload’ event to trigger an event...

How to enable or disable the windows and anonymous authentication in Microsoft Visual Studio 2019?

April 15, 2023 less than 1 minute read

To enable or disable Windows and anonymous authentication in Visual Studio 2019, you need to modify the properties from the project property window or from t...

How to merge two arrays in angular and typescript?

March 19, 2023 1 minute read

We will see how to merge one or more arrays using TypeScript. The concat() method returns a new array by concatenating two or more arrays, while the spread o...

How to find locked tables and kill the session in Microsoft SQLServer?

February 25, 2023 1 minute read

Open SQL Server Management Studio (SSMS). Connect to the SQL Server instance. Open a new query window. Execute the following query to find the sessi...

How to update the Jira issue description field using the custom listener and grovvy script?

October 8, 2022 1 minute read

Are you looking to update the Jira issue description field in an automated manner? If yes, the below script will help you update the description field. If th...

How to use a JIRA custom listener to copy comments from the parent issue to subtasks and vice versa?

October 1, 2022 3 minute read

You can copy the comment added in the parent issue to all the associated sub tasks and also copy the comment entered in the subtask to the parent issue using...

How to use a JIRA custom listener to copy comments from the parent issue to all sub tasks?

October 1, 2022 1 minute read

You can copy the comment added in the parent issue to all the associated sub tasks using the JIRA custom listener and grovvy script. All you need to do is to...

How do I use a JIRA custom listener to copy comments from the subtask to the parent issue?

October 1, 2022 1 minute read

You can copy the comment added in the sub task to it’s parent issue using the JIRA custom listener and grovvy script. All you need to do is to setup the cust...

How to assign the subtask to the reporter after it is closed?

August 28, 2022 1 minute read

Usecase: The jira admin creates a subtask in the parent issue and assigns it to the ‘developer 1’. The subtask needs to be automatically assigned back to the...

How to prevent closing the parent issue before closing all sub tasks in Jira script runner using Groovy script?

August 20, 2022 2 minute read

The developers sometimes forget to close their sub tasks, and someone closes the parent issue without checking the sub task status. You can prevent closing t...

Making custom fields is required in a workflow transition in Jira (ScriptRunner)

August 14, 2022 1 minute read

This post describes what to make a custom field requires during a work flow transition. If you are using Script Runner for Jira, you can use the Field(s) req...

JIRA - How to set custom field value in script runner using groovy script?

August 6, 2022 1 minute read

Jira allows you to create a custom field and the value can be set during the transition, so when you view or edit the issue, then the custom value will be di...