Wiki
Clone wikipioneers-youtoolspt / Home
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
-
AttachmentsWithSize("JQL STATEMENT","OPERATOR","VALUE(in bytes)")
-
AttachmentsWithExtension("SQL STATEMENT","EXTENSION")
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