Atlassian Jira Project Management Software (v8.7.1#807001-sha1:03e3702) About Jira; Report a problem; Atlassian . Try Jira - bug tracking software for your team. JIRA, Have questions? If you've already registered, sign in. Atlassian Jira Project Management Software (v8.5.7#805007-sha1:ee371e2:node3) About Jira; Report a problem; Atlassian . I'd like to have a Quick Filter to see the tickets that were added after sprint started. Atlassian Jira Project Management Software (v8.13.9#813009-sha1:6b24593:node2) About Jira; Report a problem; Atlassian . Atlassian Jira Project Management Software (v8.13.9#813009-sha1:6b24593) About Jira; Report a problem; Powered by a free Atlassian Jira community license for Bayada Home Health Care. MCPE-146073 Boat dissapearence glitch. Atlassian Jira Project Management Software (v7.13.8#713008-sha1:1606a5c) About Jira; Report a problem; Atlassian . On the board i have all the tickets and their statuses. MC-195729 Resource pack boat paddle sounds keep playing and don´t wait until the last one ends; MC-130005 Shift-clicking items in inventory while in boat dismounts you. You can also write your own custom script JQL functions, but we don’t cover that here. Try Jira - bug tracking software for your team. For a role: in lastUpdated('inRole Role Name'). data sent in the header is "jql=issueFunction+in+addedAfterSprintStart(..)" I think they don't have a field for it so it's calculated based on sprint start and creation date. Atlassian Jira Project Management Software (v8.6.1#806001-sha1:b7cf80b) About Jira; Report a problem; Atlassian . Atlassian Jira Project Management Software (v8.13.4#813004-sha1:e00b0ab) About Jira; Report a problem; Atlassian . Export Tools Export - CSV (All fields) Export - CSV (Current fields) to connect, share, and learn with other Atlassian users and experts, including Adaptavist staff. When using separate boards with added after sprint and removed after sprint I do get the correct result but when I try to combine these 2 issue . Export Tools Export - CSV (All fields) Export - CSV (Current fields) There are two issues that block other issues in this Jira instance. Script JQL functions allow you to be more granular in your searches and obtain more detailed information about what is happening in your Jira instance and in your projects. Connect with like-minded Atlassian users at free events near you! ScriptRunner for Jira documentation has moved to. If you are a JIRA administrator managing small-to-medium JIRA instances and want to learn how to manage enterprise-scale instances, then this book will help you expand your knowledge and equip you with advanced skills. Script JQL functions allow you to extend your JQL capabilities with functions like addedAfterSprintStart, fileAttached, and hasComments . . Export - CSV (All fields) Export - CSV (Current fields) Choose a delimiter Comma (,) Semicolon (;) Vertical bar (|) Caret (^) Export. I have created a unified board to track the progress of 3 Teams that work together in 1 Program. Atlassian Jira Project Management Software (v8.5.5#805005-sha1:a6982cf) About Jira; Report a problem; Atlassian . If you think about standard JQL, you may look for something like project in ("project Sun", "project Stars") to look at issues in either the Sun project or the Stars project. Please consult eGain Jira FAQ for possible answers to questions regarding Jira at eGain. Try Jira - bug tracking software for your team. Atlassian Jira Project Management Software (v8.7.1#807001-sha1:03e3702) About Jira; Report a problem; Atlassian . We mentioned some words of caution earlier on in the course, so as a reminder…. To narrow it down, you could use additional JQL to search for a specific project or issues in a specific status. Atlassian Jira Project Management Software (v8.8.1#808001-sha1:e5cdcf9) About Jira; Report a problem; Atlassian . From the top ribbon, choose Issues>Search for Issues. Atlassian Jira Project Management Software (v8.13.13#813013-sha1:3ab5fbe) About Jira; Report a problem; Powered by a free Atlassian Jira community license for Health Level Seven International. Atlassian JIRA Project Management Software (v7.5.0#75005-sha1:fd8c849) About JIRA; Report a problem; Atlassian . Atlassian Jira Project Management Software (v8.5.1#805001-sha1:c5b54a7:se10cspsdjapp01) About Jira; Report a problem; Atlassian . I want to create a query where I can see all items added and removed from current sprint (scope changes). jira jql. Does anyone know if it is able to display the data for multiple sprints? using advanced queries, Jira uses its own Jira Query Language, known as JQL. Provides recommendations and case studies to help with the implementation of Scrum. Atlassian Jira Project Management Software (v8.5.3#805003-sha1:b4933e0) About Jira; Report a problem; Atlassian . Atlassian JIRA Project Management Software (v7.6.1#76002-sha1:21e6670) About JIRA; Report a problem; Atlassian . java.lang.NullPointerException when random_selector default . You can also use this search query to power a Software board or even in a Service Desk queue. In this book, Agile Alliance cofounder Mike Cohn discusses the philosophy of agile estimating and planning and shows you exactly how to get the job done, with real-world examples and case studies. There are several built-in JQL functions that you can use with ScriptRunner installed, which you can review here. So as an example, for an approver function, you could write approval=approver(kparker) in standard JQL. Take care with recursive searches in your JQL, as they can cause issues with your Jira instance, slowing it down. You only need to be an administrator to work with the custom script JQL functions or manage the script JQL functions in the UPM. Take time exploring the library of script JQL functions and if you feel comfortable with Groovy, you can always try and write your own. Atlassian Jira Project Management Software (v8.13.8#813008-sha1:0e9b72f:jira-software-prd-1) About Jira; Report a problem; Powered by a free Atlassian Jira evaluation license. Atlassian Jira Project Management Software (v8.10.1#810002-sha1:4e97f43) About Jira; Report a problem; Atlassian . This book provides a comprehensive explanation covering all major components of Jira, including Jira Software, Jira Core, and Jira Service Desk. To get here, you access the JQL Functions page of the Jira administration console (Administration>Manage Apps>JQL Functions). Sandy Greenberg Jul 03, 2018. Show in Detail View. MC-229299. Atlassian Jira Project Management Software (v8.8.1#808001-sha1:e5cdcf9) About Jira; Report a problem; Atlassian . Very long loading pause while booting the game ("Failed to add PDH Counter", caused by oshi) MC-228343. To power searches, dashboards, Software boards (etc.) This function can search based on the user, role, or group who last updated the set of issues. Join the community to find out what other Atlassian users are discussing, debating and creating. MCPE-146077 Data corruption. MC-228828. If your JQL is a viable search you see the green checkmark. You're one step closer to meeting fellow Atlassian users at your local event. Atlassian Jira Project Management Software (v8.3.4#803005-sha1:1f96e09) About Jira; Report a problem; Atlassian . Visit the Atlassian Community Cancel. If you can use JQL in your Jira instance, you can run script JQL functions in Jira as well. Most JQL queries like the internal number. Atlassian Jira Project Management Software (v8.13.1#813001-sha1:1f8e8da) About Jira; Report a problem; Atlassian . Use a limited version of JQL functions to make sure you don’t go too far down the rabbit hole. This JIRA instance is for Commercial Projects Only, not to be used for any ITAR or US Controlled data. To find the name of a Sprint, you can then click on the Board and click "Backlog" on the left of the screen. Auto Add Reviewers based on Request Type. Type the name of the field you want to search against. - igor. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Atlassian Jira Project Management Software (v8.13.8#813008-sha1:0e9b72f) About Jira; Report a problem; Atlassian . Atlassian Jira Project Management Software (v8.13.8#813008-sha1:0e9b72f:i-0493a835ac43850d9) About Jira; Report a problem; Atlassian . Whatâs the difference between a kanban board and a Scrum board? Why would I want to disable a script JQL function? However, there are some areas where you need to be careful with script JQL. It uses the name of the Sprint, not the Number of the Sprint. Atlassian Jira Project Management Software (v8.3.2#803003-sha1:c034048) About Jira; Report a problem; Atlassian . Atlassian Jira Project Management Software (v8.13.13#813013-sha1:3ab5fbe) About Jira; Report a problem; Atlassian . MC-190307 Endermen who've been looked at will no longer agro on endermites; MC-164080 Endermite/Silverfish when riding on Ghast is inside it; MC-112705 Endermites "vibrate" when turning; MC-117609 Silverfish and Endermites don't make footstep sounds or subtitles; MC-238400 Endermites can despawn when named in a minecart. For example, the ScriptRunner JQL function, hasLinkType() can find all issues with a particular link type by entering it, for example Blocks, in the parenthesis of the function to define that qualifier. Want to learn more? Blue axolotls can spawn naturally. For a specific user: in lastUpdated('by username'). ; MC-131080 NoAI-mob-passenger behavior in a boat [head not fixed]; MC-162159 Riding a boat above bubble column causes players to teleport up 2 blocks; MC-165259 Players break boat teleportation I tried "addedAfterSprintStart" but it looks like it only works for 1 board and 1 sprint only. Likewise, you can find information on issues added after a sprint starts with the addedAfterSprintStart and so on. When you are ready, press Search to see the results. A script JQL function takes a basic JQL function and powers it up with ScriptRunner, allowing you to extend your capabilities in areas where you can use JQL such as searches and Jira Software boards. JQL searches have a field, an operator and a function. This practical guide presents Lean and Agile principles and patterns to help you move fast at scale—and demonstrates why and how to apply these paradigms throughout your organization, rather than with just one department or team. Atlassian Jira Project Management Software (v8.5.11#805011-sha1:102a195) About Jira; Report a problem; Atlassian . Issue Navigator - Jira. How could one find out the name of the board? You must be a registered user to add a comment. Once you run your search, you can save the search if you want to create a filter, just like standard JQL. While you use JQL functions in several different places within Jira, let’s start with the administration side to see what script JQL functions you have available in your instance. Basically, taking JQL functions deeper by looking further into your Jira instance and digging up more specific information. Get answers to your question from experts in the community, Share a use case, discuss your favorite features, or get input from the community. [{"value":"category","displayName":"category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.ProjectCategory"]},{"value":"created","displayName":"created","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"createdDate","displayName":"createdDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"creator","displayName":"creator","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"filter","displayName":"filter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"id","displayName":"id","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue","displayName":"issue","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue.property","displayName":"issue.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.util.Date","java.lang.Number"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"key","displayName":"key","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"lastViewed","displayName":"lastViewed","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"resolutiondate","displayName":"resolutiondate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"resolved","displayName":"resolved","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"searchrequest","displayName":"searchrequest","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["not in","changed","in","is not","was not in","is","was not","!=","was in","was","="],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"updated","displayName":"updated","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"updatedDate","displayName":"updatedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"voter","displayName":"voter","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"votes","displayName":"votes","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]}], [{"value":"addedAfterSprintStart()","displayName":"addedAfterSprintStart()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"aggregateExpression()","displayName":"aggregateExpression()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"archivedVersions()","displayName":"archivedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"cascadeOption(\"\")","displayName":"cascadeOption(\"\")","isList":"true","types":["com.atlassian.jira.issue.customfields.option.CascadingOption"]},{"value":"childIssuesOf(\"\")","displayName":"childIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"closedSprints()","displayName":"closedSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"commented()","displayName":"commented()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"completeInSprint()","displayName":"completeInSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"componentMatch()","displayName":"componentMatch()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"dateCompare()","displayName":"dateCompare()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"deployedAndPreviousVersions()","displayName":"deployedAndPreviousVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"deployedVersions()","displayName":"deployedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"earliestUnreleasedVersionByReleaseDate()","displayName":"earliestUnreleasedVersionByReleaseDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"endOfDay()","displayName":"endOfDay()","types":["java.util.Date"]},{"value":"endOfMonth()","displayName":"endOfMonth()","types":["java.util.Date"]},{"value":"endOfWeek()","displayName":"endOfWeek()","types":["java.util.Date"]},{"value":"endOfYear()","displayName":"endOfYear()","types":["java.util.Date"]},{"value":"environments(\"\")","displayName":"environments(\"\")","isList":"true","types":["java.lang.String"]},{"value":"epicsOf()","displayName":"epicsOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"expression()","displayName":"expression()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"fileAttached()","displayName":"fileAttached()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"hasAttachments()","displayName":"hasAttachments()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasComments()","displayName":"hasComments()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasLinks()","displayName":"hasLinks()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasLinkType()","displayName":"hasLinkType()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasRemoteLinks()","displayName":"hasRemoteLinks()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasSubtasks()","displayName":"hasSubtasks()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"inactiveUsers()","displayName":"inactiveUsers()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"incompleteInSprint()","displayName":"incompleteInSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issueFieldExactMatch()","displayName":"issueFieldExactMatch()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issueFieldMatch()","displayName":"issueFieldMatch()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuePickerField()","displayName":"issuePickerField()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issuesInEpics()","displayName":"issuesInEpics()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issuesInPlan(\"\")","displayName":"issuesInPlan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesInProgram(\"\")","displayName":"issuesInProgram(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"jiraUserPropertyEquals()","displayName":"jiraUserPropertyEquals()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"lastComment()","displayName":"lastComment()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"lastUpdated()","displayName":"lastUpdated()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesOf()","displayName":"linkedIssuesOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfAll()","displayName":"linkedIssuesOfAll()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfAllRecursive()","displayName":"linkedIssuesOfAllRecursive()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfAllRecursiveLimited()","displayName":"linkedIssuesOfAllRecursiveLimited()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfRecursive()","displayName":"linkedIssuesOfRecursive()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfRecursiveLimited()","displayName":"linkedIssuesOfRecursiveLimited()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfRemote()","displayName":"linkedIssuesOfRemote()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"memberOfRole()","displayName":"memberOfRole()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"myActiveSession()","displayName":"myActiveSession()","types":["java.lang.String"]},{"value":"myProjects()","displayName":"myProjects()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"nextSprint()","displayName":"nextSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"overdue()","displayName":"overdue()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"parentIssuesOf(\"\")","displayName":"parentIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"parentsOf()","displayName":"parentsOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"portfolioChildrenOf()","displayName":"portfolioChildrenOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"portfolioParentsOf()","displayName":"portfolioParentsOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"previousSprint()","displayName":"previousSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"projectMatch()","displayName":"projectMatch()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasPermission(\"\")","displayName":"projectsWhereUserHasPermission(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasRole(\"\")","displayName":"projectsWhereUserHasRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"recentProjects()","displayName":"recentProjects()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"releaseDate()","displayName":"releaseDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"removedAfterSprintStart()","displayName":"removedAfterSprintStart()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"standardIssueTypes()","displayName":"standardIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"startDate()","displayName":"startDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"startOfDay()","displayName":"startOfDay()","types":["java.util.Date"]},{"value":"startOfMonth()","displayName":"startOfMonth()","types":["java.util.Date"]},{"value":"startOfWeek()","displayName":"startOfWeek()","types":["java.util.Date"]},{"value":"startOfYear()","displayName":"startOfYear()","types":["java.util.Date"]},{"value":"subTaskIssueTypes()","displayName":"subTaskIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"subtasksOf()","displayName":"subtasksOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"testsWithoutExecution(\"\")","displayName":"testsWithoutExecution(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"unarchivedVersions()","displayName":"unarchivedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"unreleasedVersions()","displayName":"unreleasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"updatedBy(\"\")","displayName":"updatedBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"versionMatch()","displayName":"versionMatch()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"votedIssues()","displayName":"votedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"watchedIssues()","displayName":"watchedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLogged()","displayName":"workLogged()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]}], ["explain","select","isnull","commit","isempty","when","rowid","output","number","character","identified","sqrt","delimiter","else","exclusive","lock","catch","join","strict","greater","if","between","order","having","in","byte","double","subtract","outer","index","raw","is","then","execute","input","as","defaults","field","size","left","unique","difference","returns","begin","modulo","object","trans","minus","access","increment","sum","long","into","uid","current","default","file","goto","min","audit","by","share","where","after","power","escape","connect","noaudit","table","validate","cf","set","break","initial","max","more","column","right","trigger","union","asc","rename","decrement","equals","fetch","char","exists","notin","to","first","return","transaction","checkpoint","date","privileges","declare","before","do","integer","float","while","empty","mode","view","whenever","prior","continue","function","intersection","limit","raise","create","from","collation","alter","group","add","all","last","like","resource","count","check","less","encoding","inner","rownum","collate","null","abort","immediate","true","decimal","exec","nowait","changed","desc","option","drop","next","string","session","values","for","distinct","insert","revoke","update","delete","not","synonym","avg","public","and","of","define","alias","divide","end","row","multiply","on","or","intersect","previous","false","go","start","was","rows","any","int","modify","with","inout","boolean","grant","remainder","user"], [{"id":-1,"name":"My open issues","jql":"assignee = currentUser() AND resolution = Unresolved order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false}].
Mastiff Puppies For Sale Birmingham, How Do Wind-powered Cars Work, Bottomless Brunch Newcastle-under-lyme, Observatory Telescope For Sale, Does Your Belly Grow With An Ectopic Pregnancy, Janaza Prayer Seekers Guidance, Treating Scabies In Pigs, Female Penguin Happy Feet,