Contents[Hide]

Attachments

Function Description

issues jqlx.issuesWithAllAttachmentsCreatedAfter(string jqlQuery, datetime date [, string extension])

Returns the issues, for which all their attachments were created after the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If all these attachments’ creation dates are higher than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAllAttachmentsCreatedBefore(string jqlQuery, datetime date [, string extension])

Returns the issues, for which all their attachments were created before the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If all these attachments’ creation dates are lower than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAllAttachmentsCreatedByUser(string jqlQuery, string user [, string extension])

Returns the issues, for which all their attachments were created by the specified user.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If all these attachments were created by the user, specified in the user parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • user – user login name to be compared to the attachments’ creator names. Example: ‘admin’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAllAttachmentsCreatedOnDate(string jqlQuery, datetime date [, string extension])

Returns the issues, for which all their attachments were created on the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If all these attachments’ creation dates are equal to the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAnyAttachmentsCreatedAfter(string jqlQuery, datetime date [, string extension])

Returns the issues, for which any of their attachments were created after the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If any of these attachments’ creation dates are higher than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAnyAttachmentsCreatedBefore(string jqlQuery, datetime date [, string extension])

Returns the issues, for which any of their attachments were created before the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If any of these attachments’ creation dates are lower than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAnyAttachmentsCreatedByUser(string jqlQuery, string user [, string extension])

Returns the issues, for which any of their attachments were created by the specified user.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If any of these attachments were created by the user, specified in the user parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • user – user login name to be compared to the attachments’ creator names. Example: ‘admin’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAnyAttachmentsCreatedOnDate(string jqlQuery, datetime date [, string extension])

Returns the issues, for which any of their attachments were created on the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • If any of these attachments’ creation dates are equal to the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAttachmentCountEqualTo(string jqlQuery, long count [, string extension])

Returns the issues, for which the number of attachments with specified extension is equal to the specified number.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • Counts the amount of such attachments and checks if this number is equal to the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ attachments. Example: 1;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAttachmentCountGreaterThan(string jqlQuery, long count [, string extension])

Returns the issues, for which the number of attachments with specified extension is greater than the specified number.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • Counts the amount of such attachments and checks if this number is greater than the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ attachments. Example: 1;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

issues jqlx.issuesWithAttachmentCountLessThan(string jqlQuery, long count [, string extension])

Returns the issues, for which the number of attachments with specified extension is less than the specified number.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the extension parameter is specified, then for each issue takes the attachments, which have one of the extensions, specified in the extension parameter. Otherwise, for each issue takes all attachments of this issue.
  • Counts the amount of such attachments and checks if this number is smaller than the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ attachments. Example: 1;
  • [optional] extension – comma-separated list of extensions. Example: ‘jpeg, png’.

Comments

Function Description

issues jqlx.issuesWithAllCommentsCreatedAfter(string jqlQuery, datetime date)

Returns the issues, for which all their comments were created after the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If all these comments’ creation dates are higher than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’.

issues jqlx.issuesWithAllCommentsCreatedBefore(string jqlQuery, datetime date)

Returns the issues, for which all their comments were created before the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If all these comments’ creation dates are lower than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’.

issues jqlx.issuesWithAllCommentsCreatedByUser(string jqlQuery, string user)

Retu Returns the issues, for which all their comments were created by the specified user.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If all these comments were created by the user, specified in the user parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • user – user login name to be compared to the comments’ creator names. Example: ‘admin’.

issues jqlx.issuesWithAllCommentsCreatedOnDate(string jqlQuery, datetime date)

Returns the issues, for which all their comments were created right at the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If all these comments’ creation dates are equal to the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’.

issues jqlx.issuesWithAnyCommentsCreatedAfter(string jqlQuery, datetime date)

Returns the issues, for which any of their comments were created after the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If any of these comments’ creation dates are higher than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’.

issues jqlx.issuesWithAnyCommentsCreatedBefore(string jqlQuery, datetime date)

Returns the issues, for which any of their comments were created before the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If any of these comments’ creation dates are lower than the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’.

issues jqlx.issuesWithAnyCommentsCreatedByUser(string jqlQuery, string user)

Returns the issues, for which any of their comments were created by the specified user.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If any of these comments were created by the user, specified in the user parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • user – date to be compared to the comments’ creation dates. Example: ‘2020-01-01’.

issues jqlx.issuesWithAnyCommentsCreatedOnDate(string jqlQuery, datetime date)

Returns the issues, for which any of their comments were created right at the specified date.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • If any of these comments’ creation dates are equal to the date, specified in the date parameter, adds an issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • date – date to be compared to the attachments’ creation dates. Example: ‘2020-01-01’.

issues jqlx.issuesWithCommentCountEqualTo(string jqlQuery, long count)

Returns the issues, for which the number of comments is equal to the specified number.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • Counts the amount of these comments and checks if this number is equal to the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ attachments. Example: 1.

issues jqlx.issuesWithCommentCountGreaterThan(string jqlQuery, long count)

Returns the issues, for which the number of comments is higher than the specified number.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • Counts the amount of these comments and checks if this number is higher than the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ attachments. Example: 1.

issues jqlx.issuesWithCommentCountLessThan(string jqlQuery, long count)

Returns the issues, for which the number of comments is lower than the specified number.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes the comments of this issue.
  • Counts the amount of these comments and checks if this number is lower than the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ attachments. Example: 1.

Date and Time

Function Description

datetime jqlx.date(long year [, long month, long day])

Returns the datetime value for the specified year, month and day of month.

How it works:

  • This function just converts specified parameters into a datetime value. Hours, minutes, seconds and milliseconds are set to zeroes.

Parameters:

  • year – a year value. Example: ‘2020’;
  • [optional] month – a 1-based month number. If not specified, 1 (January) is taken. Example: 1;
  • [optional] day – a 1-based day of month. If not specified, 1 is taken. Example: 1.

datetime jqlx.endOfHalfYear([datetime date])

Returns the datetime value for the last day of the half year of the specified date.

How it works:

  • If date parameter is specified, takes this date. Otherwise takes current date.
  • Calculates the last month and the day of month of the half year, containing this date.
  • Initializes the returned value with the year of the specified date, calculated month and day of month. Hours, minutes, seconds and milliseconds are set to zeroes.

Parameters:

  • [optional] date – a date, which should be inside the found period. If not specified, current date is taken. Example: “2020-01-01”.

datetime jqlx.endOfQuarter([datetime date])

Returns the datetime value for the last day of the quarter of the specified date.

How it works:

  • If date parameter is specified, takes this date. Otherwise takes current date.
  • Calculates the last month and the day of month of the quarter, containing this date.
  • Initializes the returned value with the year of the specified date, calculated month and day of month. Hours, minutes, seconds and milliseconds are set to zeroes.

Parameters:

  • [optional] date – a date, which should be inside the found period. If not specified, current date is taken. Example: “2020-01-01”.

datetime jqlx.startOfHalfYear([datetime date])

Returns the datetime value for the first day of the half year of the specified date.

How it works:

  • If date parameter is specified, takes this date. Otherwise takes current date.
  • Calculates the first month and the day of month of the half year, containing this date.
  • Initializes the returned value with the year of the specified date, calculated month and day of month. Hours, minutes, seconds and milliseconds are set to zeroes.

Parameters:

  • [optional] date – a date, which should be inside the found period. If not specified, current date is taken. Example: “2020-01-01”.

datetime jqlx.startOfQuarter([datetime date])

Returns the datetime value for the first day of the quarter of the specified date.

How it works:

  • If date parameter is specified, takes this date. Otherwise takes current date.
  • Calculates the first month and the day of month of the quarter, containing this date.
  • Initializes the returned value with the year of the specified date, calculated month and day of month. Hours, minutes, seconds and milliseconds are set to zeroes.

Parameters:

  • [optional] date – a date, which should be inside the found period. If not specified, current date is taken. Example: “2020-01-01”.
Function Description

issues jqlx.blockersOf(string jqlQuery)

Returns blockers for the issues conforming to the specified JQL query.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes all linked issues and takes such of them, which are linked with ‘blocks’ link type.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’.

issues jqlx.clonesOf(string jqlQuery)

Returns clones for the issues conforming to the specified JQL query.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes all linked issues and takes such of them, which are linked with ‘clones’ link type.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’.

issues jqlx.duplicatesOf(string jqlQuery)

Returns duplicates for the issues conforming to the specified JQL query.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes all linked issues and takes such of them, which are linked with ‘duplicates’ link type.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’.

issues jqlx.epicsOf(string jqlQuery)

Returns epics for the issues conforming to the specified JQL query.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue takes all linked issues and takes such of them, which are linked with ‘epic of’ link type.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’.

issues jqlx.issuesWithLinkCountEqualTo(string jqlQuery, long count [, string linkTypes])

Returns all issues having equal number of links of specified type to the specified amount

Returns all the issues conforming to the specified JQL query, which have the same number of links as specified.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the linkTypes parameter is specified, then for each issue takes the links of the types, specified in the linkTypes parameter. If this parameter is not specified, takes all the links of this issue.
  • Counts the amount of these links and checks if this number is equal to the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ links. Example: 1;
  • [optional] linkTypes – comma-separated list of link types. Example: ‘blocks, duplicates’.

issues jqlx.issuesWithLinkCountGreaterThan(string jqlQuery, long count [, string linkTypes])

Returns all the issues conforming to the specified JQL query, which have bigger number of links than specified.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the linkTypes parameter is specified, then for each issue takes the links of the types, specified in the linkTypes parameter. If this parameter is not specified, takes all the links of this issue.
  • Counts the amount of these links and checks if this number is bigger than the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ links. Example: 1;
  • [optional] linkTypes – comma-separated list of link types. Example: ‘blocks, duplicates’.

issues jqlx.issuesWithLinkCountLessThan(string jqlQuery, long count [, string linkTypes])

Returns all the issues conforming to the specified JQL query, which have smaller number of links than specified.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the linkTypes parameter is specified, then for each issue takes the links of the types, specified in the linkTypes parameter. If this parameter is not specified, takes all the links of this issue.
  • Counts the amount of these links and checks if this number is smaller than the number, specified in the count parameter.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • count – number to be compared to the number of issues’ links. Example: 1;
  • [optional] linkTypes – comma-separated list of link types. Example: ‘blocks, duplicates’.

issues jqlx.issuesWithLinksOfTypes(string jqlQuery, string linkTypes)

Returns all the issues conforming to the specified JQL query, which have at least one link of the specified types.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • For each issue checks if it contains at least one link of the types, specified in linkTypes parameter. If it does, adds this issue to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • [optional] linkTypes – comma-separated list of link types. Example: ‘blocks, duplicates’.

issues jqlx.linkedIssues(string jqlQuery [, string linkTypes[, string linkFields]])

Returns all the linked issues for the issues conforming to the specified JQL query, taking into account link types.

How it works:

  • Takes issues conforming to the JQL query, specified in the jqlQuery parameter.
  • If the linkTypes parameter is specified, then for each issue takes all issues, linked with one of the link types, specified in the linkTypes parameter of specified linkField and adds it to the result. If this parameter is not specified, adds all linked issues to the result.

Parameters:

  • jqlQuery – query to select an initial set of issues. Example: ‘Project=TST’;
  • [optional] linkTypes – comma-separated list of link types. Example: ‘blocks, duplicates’. Either inward, outward descriptions, or link names may be specified
  • [optional] linkFields – link field to be checked, one of the following: “Inward”, “Outward”, “Name” or “Any”. Specify this parameter if only one of the field types should be checked, for example for the case when link name and inward description are the same. If this parameter is not specified, any field is taken.

Note: If you need to add any other function or operand, feel free to contact our support team.