Export - CSV (All fields)
Export - CSV (Current fields)
PHPBB3-16245
Overflow in MSSQL attempting to manage attachments when collection > 2.1 GB
Invalid UTF-8 encoding on mssqlnative driver
mssqlnative driver object incompatible with PHP 7.2
mssql_odbc does not store utf8 stings as unicode
mssqlnative does not handle unicode text
PHP warning with MSSQL on PHP 7.2
Schema upgrade fails in 3.2.1 when using SQL Server
Error migrating from 3.0.12 to 3.2. MS SQL Server
$db->sql_fetchfield returns false with mssqlnative
[{"value":"affectedVersion","displayName":"affectedVersion","auto":"true","orderable":"true","searchable":"true","operators":["~","!~","=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["=","was not in","changed","is not","not in","was not","!=","in","is","was","was in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"category","displayName":"category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.ProjectCategory"]},{"value":"comment","displayName":"comment","searchable":"true","operators":["~","!~"],"types":["java.lang.String"]},{"value":"component","displayName":"component","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"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":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Development","displayName":"Development - cf[10440]","orderable":"true","searchable":"true","cfid":"cf[10440]","operators":[">",">=","=","<","<=","in","!~","not in","is","is not"],"types":["java.lang.Number","java.lang.String"]},{"value":"due","displayName":"due","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"duedate","displayName":"duedate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"environment","displayName":"environment","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Color\"","displayName":"Epic Color - cf[10245]","orderable":"true","searchable":"true","cfid":"cf[10245]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10242]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10242]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10244]","orderable":"true","searchable":"true","cfid":"cf[10244]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10243]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10243]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"filter","displayName":"filter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"\"Fix URL\"","displayName":"Fix URL - cf[10030]","orderable":"true","searchable":"true","cfid":"cf[10030]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":["was not in","in","<=","was in","=",">",">=","<","changed","is not","not in","was not","!~","!=","is","was","~"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"\"GitHub Pull Request URL\"","displayName":"GitHub Pull Request URL - cf[10020]","orderable":"true","searchable":"true","cfid":"cf[10020]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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.Number","java.lang.String","java.util.Date"]},{"value":"issueFunction","displayName":"issueFunction - cf[10340]","orderable":"true","searchable":"true","cfid":"cf[10340]","operators":["in","not in"],"types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issuetype","displayName":"issuetype","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"key","displayName":"key","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"labels","displayName":"labels","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"cf[10040]","displayName":"Labels - cf[10040]","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"lastViewed","displayName":"lastViewed","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"level","displayName":"level","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.security.IssueSecurityLevel"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"cf[10000]","displayName":"phpBB Import Key - cf[10000]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10140]","displayName":"phpBB Import Key - cf[10140]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10141]","displayName":"phpBB Import Key - cf[10141]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10142]","displayName":"phpBB Import Key - cf[10142]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10143]","displayName":"phpBB Import Key - cf[10143]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10145]","displayName":"phpBB Import Key - cf[10145]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10146]","displayName":"phpBB Import Key - cf[10146]","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["was not in","in","<=","was in","=",">",">=","<","changed","is not","not in","was not","!=","is","was"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"Rank","displayName":"Rank - cf[10240]","orderable":"true","searchable":"true","cfid":"cf[10240]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["=","was not in","changed","is not","not in","was not","!=","in","is","was","was in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["was not in","in","<=","was in","=",">",">=","<","changed","is not","not in","was not","!=","is","was"],"types":["com.atlassian.jira.issue.resolution.Resolution"]},{"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":"Sprint","displayName":"Sprint - cf[10241]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10241]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["=","was not in","changed","is not","not in","was not","!=","in","is","was","was in"],"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":"\"Story Points\"","displayName":"Story Points - cf[10246]","orderable":"true","searchable":"true","cfid":"cf[10246]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"summary","displayName":"summary","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"type","displayName":"type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"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":"areNotBlocked()","displayName":"areNotBlocked()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"commentedIssues(\"\")","displayName":"commentedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"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":"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":"issuesInEpics()","displayName":"issuesInEpics()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issuesParents(\"\")","displayName":"issuesParents(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesSubtasks(\"\")","displayName":"issuesSubtasks(\"\")","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":"linkedIssuesHasStatuses(\"\")","displayName":"linkedIssuesHasStatuses(\"\")","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":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"membersOfProjectRole(\"\", \"\")","displayName":"membersOfProjectRole(\"\", \"\")","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":"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":"relatedIssuesByField(\"\", \"\")","displayName":"relatedIssuesByField(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"relatedIssuesByQuery(\"\", \"\")","displayName":"relatedIssuesByQuery(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"transitionCount(\"\", \"\", \"\", \"\")","displayName":"transitionCount(\"\", \"\", \"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"transitionDate(\"\", \"\")","displayName":"transitionDate(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"transitionReporter(\"\", \"\")","displayName":"transitionReporter(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"transitionReporterGroup(\"\", \"\")","displayName":"transitionReporterGroup(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"unreleasedVersions()","displayName":"unreleasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"userCommentedIssues(\"\", \"\")","displayName":"userCommentedIssues(\"\", \"\")","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"]
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1585521537833},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1585521537834},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1585521537843},{"name":"Priority","id":"priority","key":"issue.field.priority","isShown":true},{"name":"Resolution","id":"resolution","key":"issue.field.resolution","isShown":true},{"name":"Creator","id":"creator","key":"issue.field.creator","isShown":true},{"name":"Affects Version","id":"version","key":"issue.field.affectsversions","isShown":true},{"name":"Fix Version","id":"fixfor","key":"issue.field.fixversions","isShown":true},{"name":"Component","id":"component","key":"issue.field.components","isShown":true},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true,"lastViewed":1585521537887},{"name":"Query","id":"text","key":"text","isShown":true},{"name":"Development","id":"customfield_10440","key":"com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary","isShown":true},{"name":"Epic Color","id":"customfield_10245","key":"com.pyxis.greenhopper.jira:gh-epic-color","isShown":false},{"name":"Epic Link","id":"customfield_10242","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true},{"name":"Epic Name","id":"customfield_10244","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true},{"name":"Epic Status","id":"customfield_10243","key":"com.pyxis.greenhopper.jira:gh-epic-status","isShown":false},{"name":"Fix URL","id":"customfield_10030","key":"com.atlassian.jira.plugin.system.customfieldtypes:url","isShown":false},{"name":"GitHub Pull Request URL","id":"customfield_10020","key":"com.atlassian.jira.plugin.system.customfieldtypes:url","isShown":true},{"name":"Labels","id":"customfield_10040","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Rank","id":"customfield_10240","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true},{"name":"Sprint","id":"customfield_10241","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true},{"name":"Story Points","id":"customfield_10246","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"issueFunction","id":"customfield_10340","key":"com.onresolve.jira.groovy.groovyrunner:jqlFunctionsCustomFieldType","isShown":true},{"name":"phpBB Import Key","id":"customfield_10000","key":"com.atlassian.jira.plugin.system.customfieldtypes:importid","isShown":false},{"name":"phpBB Import Key","id":"customfield_10140","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10141","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10142","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10143","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10144","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10145","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"phpBB Import Key","id":"customfield_10146","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"issue.field.created","isShown":true},{"name":"Updated Date","id":"updated","key":"issue.field.updated","isShown":true},{"name":"Resolution Date","id":"resolutiondate","key":"issue.field.resolution.date","isShown":true},{"name":"Due Date","id":"duedate","key":"issue.field.duedate","isShown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true,"lastViewed":1585521537886},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true}],"type":"PEOPLE","title":"People"}]},"values":{"issuetype":{"name":"Type","editHtml":"\n\n\n\n <div class=\"field-group aui-field-issuetype\" >\n <label for=\"searcher-type\">Type</label>\n <select class=\"select js-default-checkboxmultiselect\" id=\"searcher-type\" multiple=\"multiple\" name=\"type\"\n data-placeholder-text=\"Find Issue Types...\" size=\"5\">\n <optgroup>\n \n <option class=\" \"\n id=\"type_-2\"\n title=\"All Standard Issue Types\"\n value=\"-2\">All Standard Issue Types</option>\n \n <option class=\" \"\n id=\"type_-3\"\n title=\"All Sub-Task Issue Types\"\n value=\"-3\">All Sub-Task Issue Types</option>\n </optgroup>\n\n <optgroup label=\"Standard Issue Types\">\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12123&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_1\"\n title=\"Bug\"\n value=\"1\">Bug</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/images/icons/issuetypes/epic.svg\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10100\"\n title=\"Epic\"\n value=\"10100\">Epic</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12130&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_4\"\n title=\"Improvement\"\n value=\"4\">Improvement</option>\n \n <option class=\" imagebacked 10260 \"\n data-icon=\"/images/icons/issuetypes/exclamation.png\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10000\"\n title=\"Incident\"\n value=\"10000\">Incident</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12131&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_2\"\n title=\"New Feature\"\n value=\"2\">New Feature</option>\n \n <option class=\" imagebacked 10262 10263 \"\n data-icon=\"/images/icons/issuetypes/exclamation.png\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10001\"\n title=\"Security Issue\"\n value=\"10001\">Security Issue</option>\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12138&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_3\"\n title=\"Task\"\n value=\"3\">Task</option>\n </optgroup>\n\n <optgroup label=\"Sub-Task Issue Types\">\n \n <option class=\" imagebacked 10262 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12136&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_5\"\n title=\"Sub-task\"\n value=\"5\">Sub-task</option>\n </optgroup>\n </select>\n </div>\n ","validSearcher":true,"isShown":true},"project":{"name":"Project","editHtml":"\n <div class=\"field-group aui-field-project\" >\n <label for=\"searcher-pid\">Project</label>\n \n\n <select class=\"select js-default-checkboxmultiselect\" data-placeholder-text=\"Find Projects...\" id=\"searcher-pid\" multiple=\"multiple\" name=\"pid\" size=\"5\">\n <optgroup label=\"All Projects\">\n \n <option data-icon=\"/secure/projectavatar?pid=10046&size=small\"\n title=\"Customisations Database\"\n value=\"10046\">\n Customisations Database (CUSTDB)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10042&size=small\"\n title=\"Extension Security\"\n value=\"10042\">\n Extension Security (EXTSEC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10040&size=small\"\n title=\"Incident Investigation\"\n value=\"10040\">\n Incident Investigation (INCIDENT)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10041&size=small\"\n title=\"phpBB Security\"\n value=\"10041\">\n phpBB Security (SECURITY)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10010&size=small\"\n title=\"phpBB3\"\n value=\"10010\">\n phpBB3 (PHPBB3)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10043&size=small\"\n title=\"Support Team Tools\"\n value=\"10043\">\n Support Team Tools (STT)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10045&size=small\"\n title=\"Website\"\n value=\"10045\">\n Website (WEBSITE)\n </option>\n </optgroup>\n </select>\n </div>\n \n","validSearcher":true,"isShown":true},"assignee":{"name":"Assignee","editHtml":"\n \n <div class=\"field-group aui-field-userlist\" >\n <label for=\"searcher-assigneeSelect\">Assignee</label>\n <fieldset rel=\"assignee\" class=\"hidden user-group-searcher-params\">\n </fieldset>\n <select class=\"js-usergroup-checkboxmultiselect\" multiple=\"multiple\" id=\"assignee\" name=\"assignee\" data-placeholder-text=\"Enter username or group\">\n <optgroup>\n <option class=\"headerOption\" data-icon=\"https://tracker.phpbb.com/secure/useravatar?size=xsmall&avatarId=10143\" value=\"empty\" title=\"Unassigned\">Unassigned</option>\n </optgroup>\n <optgroup>\n </optgroup>\n </select>\n <input type=\"hidden\" name=\"check_prev_assignee\" value=\"true\">\n </div>\n \n","validSearcher":true,"isShown":true},"status":{"name":"Status","editHtml":"\n <div class=\"field-group aui-field-constants\" >\n <label for=\"searcher-status\">Status</label>\n \n <select class=\"select js-default-checkboxmultiselectstatuslozenge\" data-placeholder-text=\"Find Statuses...\" id=\"searcher-status\" multiple=\"multiple\" name=\"status\" size=\"4\" data-status-lozenge=\"true\">\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-open.png\" value=\"1\" title=\"Open\" data-simple-status=\"{"id":"1","name":"Open","description":"The issue is open and ready for the assignee to start work on it.","iconUrl":"/images/icons/phpbb-open.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-progress.png\" value=\"3\" title=\"In Progress\" data-simple-status=\"{"id":"3","name":"In Progress","description":"This issue is being actively worked on at the moment by the assignee.","iconUrl":"/images/icons/phpbb-progress.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Progress</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-unverified-fix.png\" value=\"5\" title=\"Unverified Fix\" data-simple-status=\"{"id":"5","name":"Unverified Fix","description":"A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.","iconUrl":"/images/icons/phpbb-unverified-fix.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Unverified Fix</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.","iconUrl":"/images/icons/phpbb-closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-awaiting-info.png\" value=\"10001\" title=\"Awaiting Information\" data-simple-status=\"{"id":"10001","name":"Awaiting Information","description":"Further information from the reporter is required to commence work.","iconUrl":"/images/icons/phpbb-awaiting-info.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Awaiting Information</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-unreviewed-patch.png\" value=\"10002\" title=\"Patch Awaiting Review\" data-simple-status=\"{"id":"10002","name":"Patch Awaiting Review","description":"A patch solving the issue has been proposed, but is awaiting review by a development team members.","iconUrl":"/images/icons/phpbb-unreviewed-patch.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Patch Awaiting Review</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/phpbb-awaiting-info.png\" value=\"10004\" title=\"Patch Needs Work\" data-simple-status=\"{"id":"10004","name":"Patch Needs Work","description":"A patch has been reviewed but needs further work before it can be merged.","iconUrl":"/images/icons/phpbb-awaiting-info.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Patch Needs Work</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10007\" title=\"Awaiting Team Input\" data-simple-status=\"{"id":"10007","name":"Awaiting Team Input","description":"Input from other team members is required.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Awaiting Team Input</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10008\" title=\"Reviewed\" data-simple-status=\"{"id":"10008","name":"Reviewed","description":"This issue has been reviewed and a solution provided. The ticket will remain open for a short period of time before closing.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Reviewed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10009\" title=\"Support Request\" data-simple-status=\"{"id":"10009","name":"Support Request","description":"This issue should be directed to the support forums and is not appropriate for this tracker.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Support Request</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/closed.png\" value=\"10010\" title=\"Done\" data-simple-status=\"{"id":"10010","name":"Done","description":"","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Done</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/open.png\" value=\"10011\" title=\"To Do\" data-simple-status=\"{"id":"10011","name":"To Do","description":"","iconUrl":"/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">To Do</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10012\" title=\"Review Later\" data-simple-status=\"{"id":"10012","name":"Review Later","description":"This issue will be reviewed at a later date.","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Review Later</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10105\" title=\"Blocked\" data-simple-status=\"{"id":"10105","name":"Blocked","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Blocked</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10106\" title=\"In Progress by OSUOSL\" data-simple-status=\"{"id":"10106","name":"In Progress by OSUOSL","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Progress by OSUOSL</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10107\" title=\"In Progress By Us\" data-simple-status=\"{"id":"10107","name":"In Progress By Us","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Progress By Us</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10205\" title=\"Confirmed\" data-simple-status=\"{"id":"10205","name":"Confirmed","description":"A bug which has been confirmed","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Confirmed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/generic.png\" value=\"10206\" title=\"Have regression test\" data-simple-status=\"{"id":"10206","name":"Have regression test","description":"A regression test has been implemented, committed and disabled","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Have regression test</option>\n </select>\n </div>\n \n","validSearcher":true,"isShown":true},"labels":{"name":"Label","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldlabels\">Label:</label><span id=\"fieldlabels\" class=\"fieldValue\">\n \n mssql\n</span></div>\n","editHtml":"\n <div class=\"field-group aui-field-labels\" >\n <label for=\"searcher-labels\">Labels</label>\n <select class=\"js-label-checkboxmultiselect\" multiple=\"multiple\" id=\"searcher-labels\" name=\"labels\" data-placeholder-text=\"Find Labels...\">\n <option value=\"mssql\" title=\"mssql\" selected=\"selected\">mssql</option>\n </select>\n </div>\n \n","jql":"labels = mssql","validSearcher":true,"isShown":true}}}
[{"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}]