[{"value":"canvas-colour","displayName":"canvas-colour","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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":["is","not in","in","was not","was in","!=","=","is not","was not in","changed","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":"cascadeOption(\"\")","displayName":"cascadeOption(\"\")","isList":"true","types":["com.atlassian.jira.issue.customfields.option.CascadingOption"]},{"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":"company()","displayName":"company()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"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":"componentsMetadata(\"\", \"\")","displayName":"componentsMetadata(\"\", \"\")","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":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"earliestUnreleasedVersionByReleaseDate()","displayName":"earliestUnreleasedVersionByReleaseDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"employeeType()","displayName":"employeeType()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"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":"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":"groupsMetadata(\"\", \"\")","displayName":"groupsMetadata(\"\", \"\")","isList":"true","types":["com.atlassian.crowd.embedded.api.Group"]},{"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":"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":"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":"parentsOf()","displayName":"parentsOf()","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":"projectsMetadata(\"\", \"\")","displayName":"projectsMetadata(\"\", \"\")","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":"statusOffendingEpics()","displayName":"statusOffendingEpics()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"structure()","displayName":"structure()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"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":"usersMetadata(\"\", \"\")","displayName":"usersMetadata(\"\", \"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"versionMatch()","displayName":"versionMatch()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsMetadata(\"\", \"\")","displayName":"versionsMetadata(\"\", \"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsStarted()","displayName":"versionsStarted()","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}]