Export - CSV (All fields)
Export - CSV (Current fields)
MDEV-21282
Assertion 'mariadb_table' failed in gcol.innodb_virtual_debug_purge
MariaDB 10.3.10 When referring to bigint to generate timestamp data in the virtual generated column, the value of the generated column does not change when the time zone changes
Wrong result or failed assertion upon SELECT under READ UNCOMMITTED with index on virtual column
DROP Virtual Column crashes MariaDB
Assertion `type.vers_sys_end()' failed in dfield_t::vers_history_row
Table corruption or Assertion `btr_validate_index(index, 0, false)' failed in row_upd_sec_index_entry with virtual column and EMPTY_STRING_IS_NULL SQL mode
[ERROR] InnoDB: tried to purge non-delete-marked record and Assertion `0' failed in row_purge_remove_sec_if_poss_leaf
ASAN SEGV in get_prefix upon modifying base column type with existing indexed virtual column
AddressSanitizer: heap-use-after-free in my_strnncollsp_simple or my_strnncoll_binary upon SELECT with partitions and virtual columns
Assertion `col.vers_sys_end()' failed in dict_index_t::vers_history_row
Server crashes in mem_heap_dup / innobase_get_computed_value or InnoDB: Record in index was not found on update
Signal 8 in row_search_with_covering_prefix with prefix_index_cluster_optimization
Assertion `0' failed or `btr_validate_index(index, 0, false)' in row_upd_sec_index_entry or error code 126: Index is corrupted upon DELETE with TIME_ROUND_FRACTIONAL
InnoDB: Failing assertion: field->prefix_len > 0 with innodb_prefix_index_cluster_optimization=ON
Assertion `0' or Assertion `btr_validate_index(index, 0)' failed in row_upd_sec_index_entry or error code 126: Index is corrupted upon UPDATE with TIMESTAMP..ON UPDATE
MariaDB server crash
If you have an INVISIBLE VIRTUAL column, SHOW CREATE TABLE doesn't list it as INVISIBLE
Assertion `len <= col->len || ((col->mtype) == 5 || (col->mtype) == 14)' failed in row_merge_buf_add
Generated column's index not updated from RBR events (both Galera and async replication)
innodb.innodb-virtual-columns-debug failed in buildbot with wrong result
Server crashes in dict_col_t::detach upon creating a table with FK on virtual column
Assertion `!in_use->is_error()' failed in TABLE::update_virtual_field
Query with virtual columns are stored in query cache even when in expression of virtual columns exists CURRENT_TIMESTAMP()
Bug in WSREP/Galera with virtual columns (keeps crashing on startup)
REPLACE on table with virtual_field can cause crash in set_ok_status()
Server crashes in ha_innobase::commit_inplace_alter_table upon dropping virtual column
MDEV-19619
Variety of test cases and stack traces which are likely to be related to MDEV-17005 and need to be re-checked after the fix
Replace mysql_version check with frm_version for virtual columns inside InnoDBMDEV-19597
Refactor TABLE::vers_update_fields() via stored virtual columns
InnoDB: Failing assertion: !cursor->index->is_committed() with virtual columns / indexes, WITHOUT foreign keys and temporary tables
Assertion `marked_for_read()' failed in Field_long::val_int
InnoDB: Failing assertion: !cursor->index->is_committed()
Assertion `marked_for_read()' failed in Field_blob::val_str with virtual columns and views
Virtual column type cannot be converted from one to another - unhelpful error message
Server Crash When Using a Trigger With A Number of Virtual Columns on INSERT/UPDATE
Assertion `pos < table->n_def' failed in dict_table_get_nth_col or Assertion `col_nr < table->n_def' failed in dict_table_get_col_name upon TRUNCATE after upgrade from 10.1
gcol.innodb_virtual_debug failed in buildbot with Assertion `n_fields > 0' failure
Assertion failures in dtuple_get_nth_field or row_merge_read_clustered_index or row_merge_buf_add after normal upgrade from 10.1
Better handling of system versioning for generated stored columns
Assertion `file->s->base.reclength < file->s->vreclength' failed in ha_myisam::setup_vcols_for_repair
Possible corruption when using FOREIGN KEY with virtual columns
Assertion `!omits_virtual_cols(*form->s)' failed after upgrade from 10.0/10.1 with PERSISTENT generated column
Assertion `(templ->is_virtual && !field) || (field && field->prefix_len ? field->prefix_len == len : templ->mysql_col_len == len)' failed row_sel_field_store_in_mysql_format_func
ASAN heap-buffer-overflow in strmake_root on temporary table with indexed virtual column
Server crashes in l_find, ASAN heap-use-after-free in Field_long::reset upon INSERT into temporary MyISAM table with indexed persistent virtual column
ASAN heap-use-after-free upon update of blob column pointed by virtual column
Server crash in Item_field::register_field_in_read_map upon modifying column into a blob
Corruption (?) with multi-value insert and stored virtual column index
ASAN unknown-crash in my_copy_fix_mb / ha_mroonga::storage_inplace_alter_table_add_column
ASAN heap-use-after-free in innobase_get_computed_value / row_purge
[{"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 in","was not in","was","was not","in","is not","!=","=","not in","is","changed"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"\"Business Value\"","displayName":"Business Value - cf[10106]","orderable":"true","searchable":"true","cfid":"cf[10106]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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[11700]","orderable":"true","searchable":"true","cfid":"cf[11700]","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/Theme\"","displayName":"Epic/Theme - cf[10103]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10103]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Colour\"","displayName":"Epic Colour - cf[10603]","orderable":"true","searchable":"true","cfid":"cf[10603]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10600]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10600]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10601]","orderable":"true","searchable":"true","cfid":"cf[10601]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10602]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10602]","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":"\"Fixing Priority\"","displayName":"Fixing Priority - cf[11801]","orderable":"true","searchable":"true","cfid":"cf[11801]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":["!~","~","was not","in","is not","=","not in","is","changed","was in","was not in",">","was","!=","<=",">=","<"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"Flagged","displayName":"Flagged - cf[10102]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10102]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Global Rank\"","displayName":"Global Rank - cf[10000]","orderable":"true","searchable":"true","cfid":"cf[10000]","operators":["is","is not"],"types":["java.lang.Number"]},{"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":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueLinkType","displayName":"issueLinkType","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.link.IssueLinkType"]},{"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":"jqltField","displayName":"jqltField - cf[11300]","orderable":"true","searchable":"true","cfid":"cf[11300]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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":"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":"\"NRE Approved\"","displayName":"NRE Approved - cf[11405]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11405]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"NRE Projects\"","displayName":"NRE Projects - cf[11404]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11404]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"originalEstimate","displayName":"originalEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"\"Original story points\"","displayName":"Original story points - cf[11602]","orderable":"true","searchable":"true","cfid":"cf[11602]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"Other-Reporter","displayName":"Other-Reporter - cf[11402]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11402]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Parent Link\"","displayName":"Parent Link - cf[11301]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11301]","operators":["=","in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["was not","in","is not","=","not in","is","changed","was in","was not in",">","was","!=","<=",">=","<"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"progress","displayName":"progress","orderable":"true","operators":[],"types":["java.lang.Object"]},{"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 (Obsolete)\"","displayName":"Rank (Obsolete) - cf[10300]","orderable":"true","searchable":"true","cfid":"cf[10300]","operators":["is","is not"],"types":["java.lang.Number"]},{"value":"Rank","displayName":"Rank - cf[10700]","orderable":"true","searchable":"true","cfid":"cf[10700]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"\"Release Version History\"","displayName":"Release Version History - cf[10109]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10109]","operators":["~","!~","=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"remainingEstimate","displayName":"remainingEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["was in","was not in","was","was not","in","is not","!=","=","not in","is","changed"],"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","is not","=","not in","is","changed","was in","was not in",">","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[10400]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10400]","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 in","was not in","was","was not","in","is not","!=","=","not in","is","changed"],"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[10105]","orderable":"true","searchable":"true","cfid":"cf[10105]","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":"\"Support case ID\"","displayName":"Support case ID - cf[11500]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11500]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Target end\"","displayName":"Target end - cf[11601]","orderable":"true","searchable":"true","cfid":"cf[11601]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Target start\"","displayName":"Target start - cf[11600]","orderable":"true","searchable":"true","cfid":"cf[11600]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"Team","displayName":"Team - cf[11403]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11403]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"timeestimate","displayName":"timeestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timeoriginalestimate","displayName":"timeoriginalestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timespent","displayName":"timespent","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"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":"worklogAuthor","displayName":"worklogAuthor","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"worklogComment","displayName":"worklogComment","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"worklogDate","displayName":"worklogDate","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.util.Date"]},{"value":"workratio","displayName":"workratio","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]}]
[{"value":"archivedVersions()","displayName":"archivedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"assigneesList(\"\")","displayName":"assigneesList(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachedByUser()","displayName":"attachedByUser()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"commentedAfterDate(\"\")","displayName":"commentedAfterDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedBeforeDate(\"\")","displayName":"commentedBeforeDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedByUser()","displayName":"commentedByUser()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedOnDate(\"\")","displayName":"commentedOnDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"componentLeads()","displayName":"componentLeads()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"componentMatches(\"\")","displayName":"componentMatches(\"\")","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"componentsFromProject(\"\")","displayName":"componentsFromProject(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"componentsList(\"\")","displayName":"componentsList(\"\")","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"coveredBy(\"\")","displayName":"coveredBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"coveredByTestCasesHavingField(\"\", \"\")","displayName":"coveredByTestCasesHavingField(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"currentVersionsByDate()","displayName":"currentVersionsByDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"currentVersionsBySeq()","displayName":"currentVersionsBySeq()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"dueVersions()","displayName":"dueVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","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":"epicsWhereIssueIn(\"\")","displayName":"epicsWhereIssueIn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"epicsWithIssues()","displayName":"epicsWithIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"groupMatches(\"\")","displayName":"groupMatches(\"\")","isList":"true","types":["com.atlassian.crowd.embedded.api.Group"]},{"value":"groupsOfUser()","displayName":"groupsOfUser()","isList":"true","types":["com.atlassian.crowd.embedded.api.Group"]},{"value":"hasAllLastTestResults(\"\")","displayName":"hasAllLastTestResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAllLinkedTestCyclesWithAllLastTestExecutionResults(\"\")","displayName":"hasAllLinkedTestCyclesWithAllLastTestExecutionResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAllLinkedTestRunsWithAllLastTestResults(\"\")","displayName":"hasAllLinkedTestRunsWithAllLastTestResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAnyLastTestResults(\"\")","displayName":"hasAnyLastTestResults(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAnyLinkedTestCycleWithAnyLastTestExecutionResult(\"\")","displayName":"hasAnyLinkedTestCycleWithAnyLastTestExecutionResult(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAnyLinkedTestRunWithAnyLastTestResult(\"\")","displayName":"hasAnyLinkedTestRunWithAnyLastTestResult(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasAttachments()","displayName":"hasAttachments()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasCommits()","displayName":"hasCommits()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasComponents()","displayName":"hasComponents()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasFailingBuilds()","displayName":"hasFailingBuilds()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasLinkedTestCycle()","displayName":"hasLinkedTestCycle()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasLinkedTestRun()","displayName":"hasLinkedTestRun()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasLinks()","displayName":"hasLinks()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasOpenPRs()","displayName":"hasOpenPRs()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasOpenReviews()","displayName":"hasOpenReviews()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasPRs()","displayName":"hasPRs()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasRemoteLinks()","displayName":"hasRemoteLinks()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasReviews()","displayName":"hasReviews()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasSameValues(\"\", \"\")","displayName":"hasSameValues(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasSameVersions()","displayName":"hasSameVersions()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasSubtasks()","displayName":"hasSubtasks()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasTestCoverage()","displayName":"hasTestCoverage()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasTestResult()","displayName":"hasTestResult()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"hasVersions()","displayName":"hasVersions()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"impactsTestResult()","displayName":"impactsTestResult()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"inactiveUsers()","displayName":"inactiveUsers()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"issuesWhereEpicIn(\"\")","displayName":"issuesWhereEpicIn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"labelsList(\"\")","displayName":"labelsList(\"\")","isList":"true","types":["com.atlassian.jira.issue.label.Label"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"lastLoginOf(\"\")","displayName":"lastLoginOf(\"\")","types":["java.util.Date"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedAllIssues(\"\")","displayName":"linkedAllIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesByDepth(\"\", \"\")","displayName":"linkedIssuesByDepth(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesHasStatus(\"\")","displayName":"linkedIssuesHasStatus(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInComponent(\"\")","displayName":"linkedIssuesInComponent(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInComponentByName(\"\", \"\")","displayName":"linkedIssuesInComponentByName(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInFilter(\"\")","displayName":"linkedIssuesInFilter(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInProject(\"\")","displayName":"linkedIssuesInProject(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInQuery(\"\")","displayName":"linkedIssuesInQuery(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInVersion(\"\")","displayName":"linkedIssuesInVersion(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesInVersionByName(\"\")","displayName":"linkedIssuesInVersionByName(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"membersOfGroups(\"\")","displayName":"membersOfGroups(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"movedIssues()","displayName":"movedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"openVersions()","displayName":"openVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"overDueVersions()","displayName":"overDueVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"parent(\"\")","displayName":"parent(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"parentIssuesOf(\"\")","displayName":"parentIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"projectLead(\"\")","displayName":"projectLead(\"\")","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"projectLeads()","displayName":"projectLeads()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"projectMatches(\"\")","displayName":"projectMatches(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsList(\"\")","displayName":"projectsList(\"\")","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":"projectWithUserInRole(\"\")","displayName":"projectWithUserInRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"recentProjects()","displayName":"recentProjects()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"releasedOn(\"\")","displayName":"releasedOn(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"sprintEndDateOf(\"\")","displayName":"sprintEndDateOf(\"\")","types":["java.util.Date"]},{"value":"sprintStartDateOf(\"\")","displayName":"sprintStartDateOf(\"\")","types":["java.util.Date"]},{"value":"standardIssueTypes()","displayName":"standardIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"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":"subtask(\"\")","displayName":"subtask(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subTaskIssueTypes()","displayName":"subTaskIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"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":"userMatches(\"\")","displayName":"userMatches(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"usersInRole(\"\")","displayName":"usersInRole(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"usersInTimezone(\"\")","displayName":"usersInTimezone(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"versionEndDateOf(\"\")","displayName":"versionEndDateOf(\"\")","types":["java.util.Date"]},{"value":"versionMatches(\"\")","displayName":"versionMatches(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsAfter(\"\")","displayName":"versionsAfter(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsAfterDate(\"\")","displayName":"versionsAfterDate(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionsBefore(\"\")","displayName":"versionsBefore(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"versionStartDateOf(\"\")","displayName":"versionStartDateOf(\"\")","types":["java.util.Date"]},{"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":"workedIssues(\"\", \"\", \"\")","displayName":"workedIssues(\"\", \"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedAfter(\"\")","displayName":"workLoggedAfter(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedBetween(\"\", \"\")","displayName":"workLoggedBetween(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedBy()","displayName":"workLoggedBy()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLoggedOn(\"\")","displayName":"workLoggedOn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workStartedOn(\"\")","displayName":"workStartedOn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workUpdatedOn(\"\")","displayName":"workUpdatedOn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]}]
["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":1579645682194},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1579645682195},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1579645682199},{"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,"lastViewed":1579645682202},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Link types","id":"issue_link_type","key":"issue.field.issuelinks","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},{"name":"Query","id":"text","key":"text","isShown":true},{"name":"Business Value","id":"customfield_10106","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"Development","id":"customfield_11700","key":"com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary","isShown":true},{"name":"Epic Colour","id":"customfield_10603","key":"com.pyxis.greenhopper.jira:gh-epic-color","isShown":false},{"name":"Epic Link","id":"customfield_10600","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true},{"name":"Epic Name","id":"customfield_10601","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true},{"name":"Epic Status","id":"customfield_10602","key":"com.pyxis.greenhopper.jira:gh-epic-status","isShown":false},{"name":"Epic/Theme","id":"customfield_10103","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"External issue ID","id":"customfield_10500","key":"com.atlassian.jira.plugin.system.customfieldtypes:textfield","isShown":false},{"name":"External issue ID","id":"customfield_11100","key":"com.atlassian.jira.plugin.system.customfieldtypes:textfield","isShown":false},{"name":"Fixing Priority","id":"customfield_11801","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":true},{"name":"Flagged","id":"customfield_10102","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true},{"name":"Global Rank","id":"customfield_10000","key":"com.pyxis.greenhopper.jira:gh-global-rank","isShown":true},{"name":"NRE Approved","id":"customfield_11405","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true},{"name":"NRE Projects","id":"customfield_11404","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Original story points","id":"customfield_11602","key":"com.atlassian.jpo:jpo-custom-field-original-story-points","isShown":true},{"name":"Other-Reporter","id":"customfield_11402","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":false},{"name":"Parent Link","id":"customfield_11301","key":"com.atlassian.jpo:jpo-custom-field-parent","isShown":false},{"name":"Rank","id":"customfield_10700","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true},{"name":"Rank (Obsolete)","id":"customfield_10104","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":false},{"name":"Rank (Obsolete)","id":"customfield_10300","key":"com.pyxis.greenhopper.jira:gh-global-rank","isShown":true},{"name":"Release Version History","id":"customfield_10109","key":"com.pyxis.greenhopper.jira:greenhopper-releasedmultiversionhistory","isShown":true},{"name":"Severity","id":"customfield_11900","key":"com.atlassian.jira.plugin.system.customfieldtypes:select","isShown":false},{"name":"Sprint","id":"customfield_10400","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true},{"name":"Story Points","id":"customfield_10105","key":"com.atlassian.jira.plugin.system.customfieldtypes:float","isShown":true},{"name":"Support case ID","id":"customfield_11500","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Team","id":"customfield_11403","key":"com.atlassian.teams:rm-teams-custom-field-team","isShown":true},{"name":"jqltField","id":"customfield_11300","key":"com.j-tricks.jql-plugin:jqlt-field","isShown":true}],"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},{"name":"Target end","id":"customfield_11601","key":"com.atlassian.jpo:jpo-custom-field-baseline-end","isShown":true},{"name":"Target start","id":"customfield_11600","key":"com.atlassian.jpo:jpo-custom-field-baseline-start","isShown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true,"lastViewed":1579645682201},{"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 10202 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14103&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 10202 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14107&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_5\"\n title=\"Epic\"\n value=\"5\">Epic</option>\n \n <option class=\" imagebacked 10202 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=14118&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 10202 \"\n data-icon=\"/images/icons/issuetypes/task_agile.png\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_7\"\n title=\"Technical task\"\n value=\"7\">Technical task</option>\n </optgroup>\n </select>\n </div>\n ","validSearcher":true,"isShown":true},"component":{"name":"Component","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldcomponent\">Component:</label><span id=\"fieldcomponent\" class=\"fieldValue\">\n \n Virtual Columns </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-projectconstant\" >\n <label for=\"searcher-component\">Component</label>\n <select class=\"select js-default-checkboxmultiselect\" id=\"searcher-component\" multiple=\"multiple\" name=\"component\" size=\"2\">\n <optgroup label=\"\">\n <option value=\"-1\" title=\"No Component\">No Component</option>\n </optgroup>\n <optgroup label=\"\">\n <option value=\"id:Admin statements\" title=\"Admin statements\">Admin statements</option>\n <option value=\"id:Authentication and Privilege System\" title=\"Authentication and Privilege System\">Authentication and Privilege System</option>\n <option value=\"id:Backup\" title=\"Backup\">Backup</option>\n <option value=\"id:Character Sets\" title=\"Character Sets\">Character Sets</option>\n <option value=\"id:Compiling\" title=\"Compiling\">Compiling</option>\n <option value=\"id:Configuration\" title=\"Configuration\">Configuration</option>\n <option value=\"id:Data Definition - Alter Table\" title=\"Data Definition - Alter Table\">Data Definition - Alter Table</option>\n <option value=\"id:Data Definition - Create Table\" title=\"Data Definition - Create Table\">Data Definition - Create Table</option>\n <option value=\"id:Data Definition - Procedure\" title=\"Data Definition - Procedure\">Data Definition - Procedure</option>\n <option value=\"id:Data Definition - Temporary\" title=\"Data Definition - Temporary\">Data Definition - Temporary</option>\n <option value=\"id:Data Manipulation - Delete\" title=\"Data Manipulation - Delete\">Data Manipulation - Delete</option>\n <option value=\"id:Data Manipulation - Insert\" title=\"Data Manipulation - Insert\">Data Manipulation - Insert</option>\n <option value=\"id:Data Manipulation - Subquery\" title=\"Data Manipulation - Subquery\">Data Manipulation - Subquery</option>\n <option value=\"id:Data Manipulation - Update\" title=\"Data Manipulation - Update\">Data Manipulation - Update</option>\n <option value=\"id:Data types\" title=\"Data types\">Data types</option>\n <option value=\"id:Debug\" title=\"Debug\">Debug</option>\n <option value=\"id:Documentation\" title=\"Documentation\">Documentation</option>\n <option value=\"id:Documentation - Support\" title=\"Documentation - Support\">Documentation - Support</option>\n <option value=\"id:Dynamic Columns\" title=\"Dynamic Columns\">Dynamic Columns</option>\n <option value=\"id:Embedded Server\" title=\"Embedded Server\">Embedded Server</option>\n <option value=\"id:Encryption\" title=\"Encryption\">Encryption</option>\n <option value=\"id:Events\" title=\"Events\">Events</option>\n <option value=\"id:Full-text Search\" title=\"Full-text Search\">Full-text Search</option>\n <option value=\"id:Galera\" title=\"Galera\">Galera</option>\n <option value=\"id:Galera Arbitrator garbd\" title=\"Galera Arbitrator garbd\">Galera Arbitrator garbd</option>\n <option value=\"id:Galera SST\" title=\"Galera SST\">Galera SST</option>\n <option value=\"id:GIS\" title=\"GIS\">GIS</option>\n <option value=\"id:Information Schema\" title=\"Information Schema\">Information Schema</option>\n <option value=\"id:JSON\" title=\"JSON\">JSON</option>\n <option value=\"id:libmariadb\" title=\"libmariadb\">libmariadb</option>\n <option value=\"id:Locale Settings\" title=\"Locale Settings\">Locale Settings</option>\n <option value=\"id:Locking\" title=\"Locking\">Locking</option>\n <option value=\"id:mariabackup\" title=\"mariabackup\">mariabackup</option>\n <option value=\"id:N/A\" title=\"N/A\">N/A</option>\n <option value=\"id:Optimizer\" title=\"Optimizer\">Optimizer</option>\n <option value=\"id:Optimizer - CTE\" title=\"Optimizer - CTE\">Optimizer - CTE</option>\n <option value=\"id:Optimizer - Window functions\" title=\"Optimizer - Window functions\">Optimizer - Window functions</option>\n <option value=\"id:OTHER\" title=\"OTHER\">OTHER</option>\n <option value=\"id:Packaging\" title=\"Packaging\">Packaging</option>\n <option value=\"id:Parser\" title=\"Parser\">Parser</option>\n <option value=\"id:Partitioning\" title=\"Partitioning\">Partitioning</option>\n <option value=\"id:PL/SQL\" title=\"PL/SQL\">PL/SQL</option>\n <option value=\"id:Platform Debian\" title=\"Platform Debian\">Platform Debian</option>\n <option value=\"id:Platform FreeBSD\" title=\"Platform FreeBSD\">Platform FreeBSD</option>\n <option value=\"id:Platform OpenBSD\" title=\"Platform OpenBSD\">Platform OpenBSD</option>\n <option value=\"id:Platform openSUSE\" title=\"Platform openSUSE\">Platform openSUSE</option>\n <option value=\"id:Platform Power\" title=\"Platform Power\">Platform Power</option>\n <option value=\"id:Platform RedHat\" title=\"Platform RedHat\">Platform RedHat</option>\n <option value=\"id:Platform Windows\" title=\"Platform Windows\">Platform Windows</option>\n <option value=\"id:Plugin - Audit\" title=\"Plugin - Audit\">Plugin - Audit</option>\n <option value=\"id:Plugin - AWS key management\" title=\"Plugin - AWS key management\">Plugin - AWS key management</option>\n <option value=\"id:Plugin - feedback\" title=\"Plugin - feedback\">Plugin - feedback</option>\n <option value=\"id:Plugin - pam\" title=\"Plugin - pam\">Plugin - pam</option>\n <option value=\"id:Plugin - SQL_ERROR_LOG\" title=\"Plugin - SQL_ERROR_LOG\">Plugin - SQL_ERROR_LOG</option>\n <option value=\"id:Plugin - unix_socket\" title=\"Plugin - unix_socket\">Plugin - unix_socket</option>\n <option value=\"id:Plugin - userstat\" title=\"Plugin - userstat\">Plugin - userstat</option>\n <option value=\"id:Plugins\" title=\"Plugins\">Plugins</option>\n <option value=\"id:Prepared Statements\" title=\"Prepared Statements\">Prepared Statements</option>\n <option value=\"id:Protocol\" title=\"Protocol\">Protocol</option>\n <option value=\"id:Query Cache\" title=\"Query Cache\">Query Cache</option>\n <option value=\"id:Replication\" title=\"Replication\">Replication</option>\n <option value=\"id:Scripts & Clients\" title=\"Scripts & Clients\">Scripts & Clients</option>\n <option value=\"id:Sequences\" title=\"Sequences\">Sequences</option>\n <option value=\"id:Server\" title=\"Server\">Server</option>\n <option value=\"id:SSL\" title=\"SSL\">SSL</option>\n <option value=\"id:Storage Engine - Archive\" title=\"Storage Engine - Archive\">Storage Engine - Archive</option>\n <option value=\"id:Storage Engine - Aria\" title=\"Storage Engine - Aria\">Storage Engine - Aria</option>\n <option value=\"id:Storage Engine - Cassandra\" title=\"Storage Engine - Cassandra\">Storage Engine - Cassandra</option>\n <option value=\"id:Storage Engine - Connect\" title=\"Storage Engine - Connect\">Storage Engine - Connect</option>\n <option value=\"id:Storage Engine - Federated\" title=\"Storage Engine - Federated\">Storage Engine - Federated</option>\n <option value=\"id:Storage Engine - InnoDB\" title=\"Storage Engine - InnoDB\">Storage Engine - InnoDB</option>\n <option value=\"id:Storage Engine - Memory\" title=\"Storage Engine - Memory\">Storage Engine - Memory</option>\n <option value=\"id:Storage Engine - Mroonga\" title=\"Storage Engine - Mroonga\">Storage Engine - Mroonga</option>\n <option value=\"id:Storage Engine - MyISAM\" title=\"Storage Engine - MyISAM\">Storage Engine - MyISAM</option>\n <option value=\"id:Storage Engine - OQGRAPH\" title=\"Storage Engine - OQGRAPH\">Storage Engine - OQGRAPH</option>\n <option value=\"id:Storage Engine - RocksDB\" title=\"Storage Engine - RocksDB\">Storage Engine - RocksDB</option>\n <option value=\"id:Storage Engine - S3\" title=\"Storage Engine - S3\">Storage Engine - S3</option>\n <option value=\"id:Storage Engine - Sequence\" title=\"Storage Engine - Sequence\">Storage Engine - Sequence</option>\n <option value=\"id:Storage Engine - SphinxSE\" title=\"Storage Engine - SphinxSE\">Storage Engine - SphinxSE</option>\n <option value=\"id:Storage Engine - Spider\" title=\"Storage Engine - Spider\">Storage Engine - Spider</option>\n <option value=\"id:Storage Engine - TokuDB\" title=\"Storage Engine - TokuDB\">Storage Engine - TokuDB</option>\n <option value=\"id:Storage Engine - XtraDB\" title=\"Storage Engine - XtraDB\">Storage Engine - XtraDB</option>\n <option value=\"id:Stored routines\" title=\"Stored routines\">Stored routines</option>\n <option value=\"id:Temporal Types\" title=\"Temporal Types\">Temporal Types</option>\n <option value=\"id:Tests\" title=\"Tests\">Tests</option>\n <option value=\"id:Time zones\" title=\"Time zones\">Time zones</option>\n <option value=\"id:Triggers\" title=\"Triggers\">Triggers</option>\n <option value=\"id:Variables\" title=\"Variables\">Variables</option>\n <option value=\"id:Versioned Tables\" title=\"Versioned Tables\">Versioned Tables</option>\n <option value=\"id:Views\" title=\"Views\">Views</option>\n <option selected=\"selected\" value=\"id:Virtual Columns\" title=\"Virtual Columns\">Virtual Columns</option>\n <option value=\"id:wsrep\" title=\"wsrep\">wsrep</option>\n <option value=\"id:XA\" title=\"XA\">XA</option>\n <option value=\"id:XML Functions\" title=\"XML Functions\">XML Functions</option>\n </optgroup>\n </select>\n </div>\n ","jql":"component = \"Virtual Columns\"","validSearcher":true,"isShown":true},"project":{"name":"Project","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldpid\">Project:</label><span id=\"fieldpid\" class=\"fieldValue\">\n \n <a href=\"/browse/MDEV\" title=\"Browse MariaDB Server project\">MariaDB Server</a> </span></div>\n","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=10902&size=small\"\n title=\"MariaDB ColumnStore\"\n value=\"10902\">\n MariaDB ColumnStore (MCOL)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10300&size=small\"\n title=\"MariaDB Connector/C\"\n value=\"10300\">\n MariaDB Connector/C (CONC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10301&size=small\"\n title=\"MariaDB Connector/J\"\n value=\"10301\">\n MariaDB Connector/J (CONJ)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11300&size=small\"\n title=\"MariaDB Connector/node.js\"\n value=\"11300\">\n MariaDB Connector/node.js (CONJS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10400&size=small\"\n title=\"MariaDB Connector/ODBC\"\n value=\"10400\">\n MariaDB Connector/ODBC (ODBC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11400&size=small\"\n title=\"MariaDB Connector/Python\"\n value=\"11400\">\n MariaDB Connector/Python (CONPY)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10600&size=small\"\n title=\"MariaDB MaxScale\"\n value=\"10600\">\n MariaDB MaxScale (MXS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10000&size=small\"\n selected=\"selected\" title=\"MariaDB Server\"\n value=\"10000\">\n MariaDB Server (MDEV)\n </option>\n </optgroup>\n </select>\n </div>\n \n","jql":"project = MDEV","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://jira.mariadb.org/secure/useravatar?size=xsmall&avatarId=10123\" 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/statuses/open.png\" value=\"1\" title=\"Open\" data-simple-status=\"{"id":"1","name":"Open","description":"","iconUrl":"/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Open</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/status_generic.gif\" value=\"10101\" title=\"Confirmed\" data-simple-status=\"{"id":"10101","name":"Confirmed","description":"","iconUrl":"/images/icons/status_generic.gif","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Confirmed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/inprogress.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/statuses/inprogress.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Progress</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/down.png\" value=\"10000\" title=\"Stalled\" data-simple-status=\"{"id":"10000","name":"Stalled","description":"There was some work done on this issue in the past. But the assignee is not working on it anymore.","iconUrl":"/images/icons/statuses/down.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Stalled</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/information.png\" value=\"10002\" title=\"In Review\" data-simple-status=\"{"id":"10002","name":"In Review","description":"The current assignee is reviewing the work done in this issue.","iconUrl":"/images/icons/statuses/information.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Review</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Closed</option>\n </select>\n </div>\n \n","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}]