Search

Search Issues

Last Updated: Mar 8, 2023

Articles

Use this function to search for the issues in JIRA using SQL query.

Syntax

Search Issues (token, url, username, project_key, SQL_query, Start_count, Max_count)

Parameters

Input Parameter Name Description
token JIRA API token
url JIRA URL
username JIRA username
project_key Key of the Issue
SQL_query JIRA Query to search for issues
Start_count Starting count of the ticket.
For example, if there are 20 tickets, to search from ticket number 5, provide 5 as the start count
Max_count Maximum number of issues to be searched

To know more about token, click here.

Returns

Return Value Description
Output
  • On Success returns 1 | key, summary, status, assignee for each Issue separated by | |
  • On Failure returns 0 | Error Message

Sample

Search Issues (ABCDCEF, https: //yourusername.atlassian.net, yourname@gmail.com, project = “XYZ” ORDER BY created DESC, 2, 40)

  • Uses the token ABCDEF to connect to JIRA with the url https: //yourusername.atlassian.net with the username yourname@gmail.com, searches for the issues based on the query project = “XYZ”.

To view all the JIRA functions, click here.

Did you find what you were looking for?