1. yTools Avatar yTools
  2. Untitled project
  3. pioneers-youtoolspt

Wiki

Clone wiki

pioneers-youtoolspt / Home

View History

Alt text

JQL Functions on 1.0.0v:

  • GotAttachmentsInJQL("JQL STATEMENT")

  • HasCommentsByUserInJQL("JQL STATEMENT","USER")

  • IsParentOf("JQL STATEMENT")

  • IsSubTaskOf("JQL STATEMENT")

Filters Math

  • InterceptionOfFilters("FILTER ID","FILTER ID")

  • SubtrationOfFilters("FILTER ID","FILTER ID")

  • UnionOfFilters("FILTER ID","FILTER ID")

Linked Filters

  • Linked2FilterByCustomFieldValue("FILTER ID","Name of Custom Field","Value of custom field")

  • Linked2FilterByInwardsLinkType("FILTER ID","INWARDS LINK TYPE")

  • Linked2FilterByLinkType("FILTER ID","LINK TYPE")

  • Linked2FilterByOutwardsLinkType("FILTER ID","OUTWARDS LINK TYPE")

  • Linked2FilterByPriority("FILTER ID","PRIORITY")

  • Linked2JQLByStatus("JQL STATEMENT","STATUS")

Worklog

  • WorklogStartedOn("JQL STATEMENT","DATE",[USER])

  • WorklogLoggedOn("JQL STATEMENT","DATE",[USER])

  • WorklogLoggedBetween("JQL STATEMENT","DATE","DATE",[USER])

  • WorklogStartedAfter("JQL STATEMENT","DATE",[USER])

  • WorklogStartedBefore("JQL STATEMENT","DATE",[USER])

  • WithTimeSpentInStatusInJQL("JQL STATEMENT","STATE","OPERATOR","TIME")

  • WasMovedFromJQL("JQL STATEMENT")

Changes

  • WasChangedByUserAfter("USER","DATE",[PROJECT])

  • WasChangedByUserBefore("USER","DATE",[PROJECT]))

  • WasChangedByUserInJQL("JQL STATEMENT","USER")

  • WasChangedByUser("USER",[PROJECT]))

Comments

  • HasCommentsByUserInJQL("JQL STATEMENT","USER")

  • WasCommentedByUserInJQLAfter("JQL STATEMENT","DATE","USER")

  • WasCommentedByUserInJQLBefore("JQL STATEMENT","DATE","USER")

Status

  • AfterStatusInJQL("JQL STATEMENT","STATE")

  • BeforeStatusInJQL("JQL STATEMENT","STATE")

  • BetweenStatusInJQL("JQL STATEMENT","STATE","STATE")

  • userLeadingComponents("USER")

For good results using this "status" functions you need to order your status. You an re-order them following : https://confluence.atlassian.com/display/JIRA/How+to+re-order+statuses

SQL

  • executeQuery("SQL STATEMENT")

Only user menber of jira-sql-runners group can run this query.JIRA administratores will have to create group and associate users. SQL query must return only id of issue!Extra information use filter column configuration.

New in 1.2.0

Attachments

NOTES:

  • Field "OPERATOR" can be ">","=","<"

  • [] Indicates a optional field

New in 2.0.0

PIONEER is expanding to new worlds, and have just arrived to Workflows! This is just the beginning!:)

Workflow Conditions

LinkedIssueTypeInStatus

  • Condition status over linked issues of a given Issue Type

ParentIssueStatus

  • Condition over Parent Status

ParentIssueType

  • Condition over Parent Issue Type

SubtaskIssueStatus

  • Condition over status of sub-tasks

  • Only Assignee of Issue or Parent

SubtaskIssueType

  • Condition over Issue Type of sub-tasks

Workflow Validators

HasComments

HasSubTasks

HasAttachments

HastTimeSpent

HasIssueLinkTypes

Workflow PostFunctions

Perform Transitions In Linked Issues

Perform Transitions In Linked Issues Whith Issue Type​

Perform Sub Task Transition

Set Assignee As Parent Watcher

Updated