How to Search Specific Content in Jira Tickets

In Jira, you can search for specific content within a ticket, including text in the description, comments, and other fields. This is typically done using Jira Query Language (JQL) or the Jira interface. Below, we cover how to search using these methods.

1. Jira Query Language (JQL)

JQL allows you to create custom searches by writing queries that look for text within specific fields such as the description or comments of a Jira issue.

Search by Description Content

You can search for issues that contain specific words in the description using the description field:

        description ~ "search term"
    

This query will return all tickets where the description contains the phrase "search term".

Search by Comment Content

If you want to search for text in the comments, use the comment field:

        comment ~ "search term"
    

This will return all tickets where the comment section contains the term "search term".

Search Across All Text Fields

If you want to search for a term in multiple text fields (like the summary, description, and comments), use the text ~ operator:

        text ~ "search term"
    

This will search across several fields in the Jira ticket, including summary, description, and comments.

Combination of Multiple Criteria

You can also combine multiple search criteria. For example, to find tickets with the term in both the description and comments, you can use:

        description ~ "search term" AND comment ~ "another term"
    

2. Using Jira's Advanced Search UI

If you're not familiar with writing JQL, Jira provides a user-friendly Advanced Search UI where you can filter by specific fields:

• Go to Issues > Search for Issues.
• Select the Advanced Search option to input JQL directly.
• Use the queries as mentioned above to search.

3. Using Jira's Quick Search

The Quick Search bar at the top right can be used to perform simple searches. Just type the term you're looking for, and Jira will attempt to find matching tickets. However, it may not allow you to specify specific fields like comments or descriptions.

4. Third-Party Add-ons

Jira supports third-party add-ons (such as ScriptRunner or Jira Misc Custom Fields) that can enhance search capabilities. These tools allow:

• Searching in additional fields like attachments, custom fields, and more.
• Advanced filtering and searching across historical changes in tickets.

5. Using the Jira REST API

If you prefer programmatically searching for text in Jira, the Jira REST API allows you to search for specific content in comments or descriptions. Here's an example of how you can use it to search for a term in comments:

        GET /rest/api/2/search?jql=comment~"search term"
    

This will return issues that contain "search term" in the comments.

Summary

To search for content in Jira tickets:

• Use JQL for advanced searches in fields like description, comments, and others.
• Utilize the Advanced Search UI for a more intuitive query experience.
• Try Quick Search for simple queries.
• Consider using third-party add-ons for extended functionality.
• Use the REST API for programmatic searching.

Note: Make sure you have the appropriate permissions to search through comments and other fields, as access may vary depending on your role in Jira.

Create or Insert a New Module in VBE

In this tutorial, we are going to explain you how to Insert or Create a New Module in the Visual Basic Editor (VBE).

To Insert or Create a New Module, please follow the beneath steps:

1. Open the workbook in which you want to insert the Module.
   
2. Press Alt+F11 key from your keyboard to open the Visual Basic Editor (VBE) window.
3. Click on the Insert tab in the VBE, and click on the Module option
   
   
   
   
   
4. At the Right Side of the Project Explorer Window, A code window will be opened. You can Enter your new code or Copy-Paste any of your existing code there.

How to Insert a Command Button

In this tutorial we are going to explain how you can Insert the Command Button in the Microsoft Excel.

To place a command button into your worksheet, execute the following steps:

1. In the Developer tab, click on Insert option.
2. In the ActiveX Controls group, click on Command Button.
   
   

   

   Insert Command Button Control
   

   
   
3. Drag a command button on your worksheet.

How to Show Developer Tab

In this tutorial we are going to explain how you can turn on the Developer Tab in the Microsoft Excel.

To turn on the Developer tab, execute the following steps.

1. Right click anywhere on the ribbon, and then click Customize the Ribbon (as shown in the below screenshot).
   
   

   

   Customize Ribbon
   

   Alternatively, you can go to File Menu then Click on Options and then click on Customize the Ribbon option shown in the left pane of the Excel Options window, the same window will open as shown you in the below image.
   
   
2. Under Customize the Ribbon, on the right side of the dialog box, select Main tabs (if necessary).
3. Check the Developer check box.
   
   

   

   Turn On Developer Tab
   

4. Click OK.
5. You can find the Developer tab next to the View tab.
   
   

   

   Developer Tab
   

How to Open Visual Basic Editor

In this tutorial we are going to explain how you can open the Visual Basic Editor in the Microsoft Excel.

To open the Visual Basic Editor, Go to the Developer tab and then click on Visual Basic. OR Press Alt+F11 key from your keyboard.

Open Visual Basic Editor

The Visual Basic Editor appears.

Visual Basic Editor

All Excel Keyboard Shortcuts at One Place

We have gathered all the Keyboard Shortcuts of Microsoft Excel at one place. To easy access of yours, we have categorized all the shortcuts. Now, you can find the required category and can easily access the list of shortcuts by clicking on the links listed below and increase your productivity.

Note: Here, You can find the shortcut keys for Mac & Windows both the platforms.

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Excel Cell Navigation Shortcuts For Mac & Windows

Formula Shortcuts For Mac & Windows

Increase Productivity using these Top Excel Keyboard Shortcuts

Excel Cell Navigation Shortcuts For Mac & Windows

To do this action	Press in Windows	Press in Mac
Cycle Through Text Boxes / Images	Ctrl+Alt+5
Enter the End Mode	End	Fn+→
Exit Navigation of Text Boxes / Images	Esc	Esc
Extend Selection of Cells to Last Used Cells	Ctrl+Shift+End	Fn+⌃ +⇧ +→
Move One Cell Down	↓	↓
Move One Cell Left	←	←
Move One Cell Right	→	→
Move One Cell Up	↑	↑
Move One Screen Down in a Worksheet	Pg Dn	Fn+↓
Move One Screen Left in Worksheet	Alt+Pg Up	Fn+⌥ +↑
Move One Screen Right in Worksheet	Alt+Pg Dn	Fn+⌥ +↓
Move One Screen Up in a Worksheet	Pg Up	Fn+↑
Move to Beginning of a Worksheet	Ctrl+Home	Fn+⌃ +←
Move to Cell in the Upper Left Corner	Home+Scr Lk	Fn+⌃ +←
Move to Left Edge of Data Region	Ctrl+←	⌃ +←
Move to Right Edge of Data Region	Ctrl+→	⌃ +→
Move to Top Edge of Data Region	Ctrl+↑	⌃ +↑
Move to Bottom Edge of Data Region	Ctrl+↓	⌃ +↓
Move to Last Cell on a Worksheet	Ctrl+End	Fn+⌃ +→
Move to the Next Cell (Right Side)	Tab	Tab
Move to the Previous Cell	Shift+Tab	⇧ +Tab
Move to the Next Sheet in Workbook	Ctrl+Pg Dn	Fn+⌃ +↓
Move to the Previous Sheet in Workbook	Ctrl+Pg Up	Fn+⌃ +↑
Open List of Choices (Drop-down) on a Cell	Alt+↓	⌥ +↓
Show "Go to" Dialog	Ctrl+G	⌃ +G

For More Shortcuts (Click on the links below):

Excel Ribbon Tab Shortcuts for Windows

Shortcuts to Make Selections in Excel

Formatting Cell Shortcuts in Excel

Inside the Ribbon Shortcuts in Excel

Frequently Used Keyboard Shortcuts For Mac & Windows in Excel

Formula Shortcuts For Mac & Windows

Create a LOG file using Notepad

You can use the below mentioned Notepad Trick to create a log-type file that adds an automatic timestamp (i.e. current date and time) each time the Notepad file is opened.

Below is the step-by-step process to create a LOG file in the Microsoft Notepad:

Step 1: Open Notepad (Go to Start then Choose Programs and then Accessories)

OR

Press Window Key + R to open run command and then type Notepad and then Press OK

Step 2: Type .LOG into Notepad

Note: .LOG must be in capital letters and also at the very beginning / first line (as shown in the below screenshot)

Step 3: Save this file by Save option in the File menu

Step 4: Close Notepad

Step 5: Open the saved file. Notepad automatically inserts current date and time after last line. (as shown in the below screenshot)

Step 6: You can type your data there for that time and date and Press Enter Twice (Enter is required to show the Date & Time with some line gaps as shown in the above screenshot)

Step 7: Save the file again.

Note : If you put a space before (.LOG) then this trick won't work.

Create a Custom Function in Excel - UDF

You can create your very own functions that do whatever you want it to; are called User Defined Functions or UDF and they are amazing.

To make these functions; we just need a little bit of VBA Coding since they are basically macros.

Steps to Create a UDF in Excel

1. Hit Alt + F11 to go to the VBA Editor window




2. Go to Insert > Module



You should now see a window that looks like this:




3. In that window type Function and the name of your function and then an open and closing parenthesis and then hit Enter. I named my function CountCharacters

You can give your function basically any name that is not already used for functions.

Once you do this, the window will automatically add End Function to the window and it should look something like this:






4. Put some code within the function to make it do something.

Here, I will simply set a variable equal to some text that I would like to output.


outputText = "This is output."



5. Now, we need to put the output of our function into a variable that has the SAME name as our function.

To do this, I add this line of code to the bottom of the function's code:


CountCharacters = outputText




6. Hit Alt + F11 to go back to Excel and input the new function into a cell.



Notice that when I start typing the name of the function it appears in the function list drop-down for Excel.

When you finish entering the function hit Enter like you would with a regular function.


7. That's it! Here is the final result.



In this example, I created the simplest form of a UDF or User Defined Function.

Every UDF that you create will follow the basic structure outlined in this example, which is:

1. Functions must start with Function and then the name you want to give that function and an open and closing parenthesis. Arguments can go into the parenthesis, as discussed below in another example.
2. Functions must end with the text End Function, which the Excel VBA window will usually input for you.
3. To generate the output for the function and send it back to Excel, you must assign the output of the function to a variable that has the exact same name as your function.

Adding Arguments to the Function

Let's now add an argument to the function in order to make it more useful.

Arguments are the parts of a function where you can input data, or select a cell that has data, that you want your function to use. Arguments are the way you get data into your function.

It's actually very simple; we just input text in-between the parenthesis after the name of the function, and that text will be the argument.

Let's start with the example we made above:



Now, add text in the parenthesis:



I put input_value as the argument. Note that you can't use spaces for the names, instead, separate words using underscores.

Now that we have input_value as an argument, we can use it within the function. This is how we get data from the user into the function.

To make this function more dynamic, since it currently only outputs the hardcoded text "This is output.", I will set the variableoutputText equal to the new argument input_value.



Go back to Excel (hit Alt + F11) and let's try this function on another cell.



Here is the result:



This simple function now outputs whatever text is given to it, in this case, the text from cell A1.

Multiple Arguments

You can have multiple arguments, just separate each one with a comma like this:

Function MyFunctionName(Argument_1, Argument_2, Etc.)

Using VBA within the Function

We are creating this function using VBA (Visual Basic for Applications), which is the same thing we use for regular macros. As such, we can do many interesting and powerful things. Now, functions can't do everything that a regular macro can do, because the goal of a function is to return a result back to the cell, but you can still do a lot.

Let's finish the function we started to create and make it count all of the characters that are in a cell.

To do this, we add the len VBA function, which is used to count the length of the value that you put inside of it.

I want to count the input to this function, which is provided through the input_value variable and so I need to put that inside the len function.

This:

outputText = input_value

Will become this:

outputText = len(input_value)

Since the rest of the function is already setup to output the value stored in the outputText variable, I don't need to change anything else.

Here is the final Function code:



Go back to Excel and try it now.



Output is:


We now have a function that counts how many characters are in a cell and gives us the result.

The Final Result: Custom Excel Function

This was a very simple example using VBA to create a function but you can include many lines of code depending on the complexity of what you are trying to do. In this example, I tried to keep things simple to help give you an idea of how everything works so you can build upon it.
Here is the final version of the code that was created:

Function CountCharacters(input_value)  
   
   outputText = Len(input_value)  
   
   CountCharacters = outputText  
   
 End Function

Notes

Custom Excel functions, or UDFs, are simply awesome. They are one of my favorite aspects of Excel because it allows you to easily create a function that does almost whatever you could want it to do. When you have repetitive tasks that take many steps or require a complex formula that is hard to remember, you can create a custom function to do the work for you.

The example that I created above is not a useful custom function on its own since there is already a LEN() function in Excel, but it should help you to understand how custom functions are made and used.

UDFs are only available in the workbook in which you have them or when that workbook is open and you are referencing them using the correct cross-workbook method, with is rather annoying. In another tutorial I will show you how to make them available everywhere.

How to Save a PowerPoint Slide as a Picture or Image

In this blog, I will show you How you can Save a PowerPoint Slide as a Picture or Image. I have demonstrated the same in the video as well where I have used PowerPoint (PPT) 2016 which is a part of the Microsoft Office 365 package.


This method of saving a PPT slide as an image is particularly useful if you’re saving a slide for your YouTube video thumbnail.

In order to save a PowerPoint slide as a picture, follow the below-mentioned steps sequentially:

1. Go to the FILE menu 
2. Choose EXPORT option 
3. Next, choose CHANGE FILE TYPE option 
4. Then, choose the image file format, JPEG or PNG as per your requirement 
5. Click the SAVE AS button 
6. Browse the location path where you wanted to save the image file 
7. Give a name to your file 
8. And finally, it will give you an option to save just "one slide" or "all the slides" as a picture. You can choose any one of them as per your requirements. 

Hurray! Now you can check your location path where you have saved the exported Image File. You can find the converted Image there.

VLOOKUP Function in MS Excel

In this tutorial we are going to explain you how you can use the VLOOKUP Function in Microsoft Excel

Purpose

When you need to find things from a big table or a range by row. VLOOKUP searches for a value in the first column of a table. At the match row, it retrieves a value from the specified column.

Return Value

The matched value from a table.

Syntax

=VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup])

Arguments

• lookup_value - The value to look for in the first column of a table.
• table_array - The table from which to retrieve a value.
• col_index_num - The column in the table from which to retrieve a value.
• range_lookup - [optional] TRUE or 1 = approximate match (default). FALSE or 0 = exact match.

Note: Recommended [range_lookup] as 0 or FALSE, as mostly required exact output. 

Simplifying above Syntax and Arguments

=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted)

The ItemToFind is a single item specified by the user.
The RangeToLookIn is the range of data with the row headings at the left hand side.
The ColumnToPickFrom is how far across the table the function should look to pick from.
The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes, FALSE for no.

Note: Recommended [range_lookup] as 0 or FALSE, as mostly required exact output.

Example:

Show a Processing Window While Macro Runs

Step-by-step process to show a processing window While Macro Runs in excel:

1. Start a new workbook in Microsoft Excel 97, 2003, 2007, 2010, 2013, 2016. (or a new document in Microsoft Word 97, 2003, 2007, 2010, 2013, 2016, 2019, Office365).
2. Press ALT+ F11 to activate the Visual Basic Editor.
3. On the Insert menu, click Module to insert a module into the project.
4. Press F4 to display the Properties window.
5. Change the Name property of the module to Processing_Code.
6. In the Processing_Code module window, type or copy-paste the following code:

Public Processing_Message As String
Public Macro_to_Process As String

Sub StartProcessing (msg As String, code As String)
     Processing_Message = msg    'Set the message that is displayed
                                 'in the dialog box
     Macro_to_Process = code     'Set the macro that is run after the
                                 'dialog box is active
     Processing_Dialog.Show      'Show the Dialog box
End Sub



7. On the Insert menu, click UserForm to add a UserForm to the project.
8. Press F4 to display the Properties Window. Change the UserForm properties to the following settings.
   
   
   
   
   

Property           Setting
-------------------------------------
Name               Processing_Dialog
Caption            Please Wait...
StartUpPosition    2-CenterScreen

9. Add one Label control to the UserForm. Change the Name property of the label to lblMessage.
10. Select the UserForm. On the View menu, click Code. In the code window, in the Procedure list, select the Initialize event, and then type the following in the Code window:

Private Sub UserForm_Initialize()
    lblMessage.Caption = Processing_Message  'Change the Label Caption
End Sub

11. In the Code window, click Activate event in the Procedure list, and type the following:

Private Sub UserForm_Activate()
      Me.Repaint                         'Refresh the UserForm
      Application.Run Macro_to_Process   'Run the macro
      Unload Me                          'Unload the UserForm
End Sub



12. On the Insert menu, click Module. Type the following code in the Code window:
    
    
    
    
    

Sub MyMacro()
      For x = 1 to 5000
          Application.StatusBar = x   '5000 Iterations Changing StatusBar
      Next
      Application.StatusBar = False  'Reset the StatusBar
End Sub 

 Sub Main()
      'Call the StartProcessing procedure to show the Processing_Dialog
      'with the label "Processing, Please Wait..." and execute
      'MyMacro.
      StartProcessing "Processing, Please Wait...", "MyMacro"
End Sub

13. Press ALT+ Q to leave the Visual Basic Editor and return to Microsoft Excel (or Microsoft Word).
14. On the Tools menu, point to Macro, and click Macros. Select the Main macro and click Run. The Processing_Dialog dialog box appears.

While the dialog box is shown, the status bar text in the application increments from 1 to 5000--the changing status bar text is the indication that your macro is running while the dialog box is on the screen.

How to Use the Processing Dialog Box in Other Workbooks

To use this "Processing, Please Wait" dialog box with macros in other workbooks or documents, do the following:

1. Activate the Visual Basic Editor. On the View menu, click Project Explorer.
2. Select the project that you created in the previous steps.
3. Right-click the "Processing_Dialog" UserForm and click Export File. Save the UserForm as "Processing_Dialog.frm."
4. Right-click the "Processing_Code" Module and click Export File. Save the module as "Processing_Code.bas."
5. Return to Microsoft Excel and open the workbook in which you would like to use the "Processing, Please Wait" dialog box.
6. Activate the Visual Basic Editor.
7. On the File menu, click Import File, select the "Processing_Dialog.frm" file, and click Open.
8. On the File menu, click Import File. Select the "Processing_Dialog.bas" file, and click Open.
9. On the Insert menu, click Module, and type the following code in the Code window:

Sub Main()
         StartProcessing "<message text>", "<macro name>"
End Sub

Where the <message text> argument is the text string that you want to display in the Processing_Dialog dialog box and <macro name> is the macro that you would like to run after the dialog box appears. To show the dialog box and run the macro indicated by "<macro name>", run the macro Main.

Separate Strings through VBA Code

In this tutorial we are going to explain you how you can separate the strings using the VBA Macro Code in Microsoft Excel.

Below Is the Situation in which you need to separate the Full Name string to the First Name and the Last Name string:

You can place a command button on your worksheet (as shown in the above screenshot) And add the following code lines: 

1. We Declare a variable called Full_Name of Type String, a variable called Comma_Position of Type Integer, And a variable called i of Type Integer.

    Dim Full_Name As String, Comma_Position As Integer, i As Integer

The problem we are dealing With Is that we need To tell Excel VBA from where we want To separate the string. In Case of Smith, Mike the comma is at position 6 While in Case of Williams, Janet the comma is at position 9. 






2. We use a loop to execute the operations on each name entered in Excel. First, we initialize the variable Full_Name. Next, we use the Instr function to find the position of the comma.

    For i = 2 To 7
    Full_Name = Cells(i, 1).Value
    Comma_Position = InStr(Full_Name, ",")

Note: Currently this code is working from Row No. 2 to 7. You can modify it as per your requirement.


3. Now, we want to write the part after the comma to Column B and the part in front of the comma to column C. You can achieve this by adding below mentioned lines in you code:

Cells(i, 2).Value = Mid(Full_Name, Comma_Position + 2)
Cells(i, 3).Value = Left(Full_Name, Comma_Position - 1)

Mid(Full_Name, Comma_Position + 2) means we want the part of Full Name starting at character 'Comma_Position + 2' (this is exactly the first name).

Left(Full_Name, Comma_Position - 1) means we want the part of Full Name starting at the beginning until character 'Comma_Position - 1' (this is exactly the last name).


4. Now, close the loop.

    Next i




5. Final Code will look like below:
   

Sub Separate_Strings()

    Dim Full_Name As String, Comma_Position As Integer, i As Integer

    For i = 2 To 7 'You can modify it as per your requirement.
        Full_Name = Cells(i, 1).Value
        Comma_Position = InStr(Full_Name, ",")
    
    Cells(i, 2).Value = Mid(Full_Name, Comma_Position + 2)
    Cells(i, 3).Value = Left(Full_Name, Comma_Position - 1)
    
    Next i

End Sub

6. To test the program, Add six names separated by a comma and space to Range("A2:A7") as shown in the above screenshot.
   
7. Test the program.

Result: