Export - CSV (All fields)
Export - CSV (Current fields)
MDEV-23094
Multiple calls to a Stored Procedure from another Stored Procedure crashes server
Assertion `! thd->in_sub_stmt' failed in sp_instr_stmt::exec_core
Invalid use of aggregate function in SP is not detected at CREATE time
Crash with a stored aggregate function returning INET6
*SAN: sql/sql_select.cc:24493:22: runtime error: load of value 3200171710, which is not a valid value for type 'enum_parsing_place' (on optimized builds)
*SAN: sql/item.cc:2788:70: runtime error: member call on address 0x62b000086e58 which does not point to an object of type 'Query_arena' (on optimized builds)
Strange effect when creating&calling a procedure after changing character_set_database
Assertion `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed in Diagnostics_area::set_ok_status on FUNCTION replace
Crash on a table value constructor with an SP variable
Assertion field_max_length <= m_return_field_def.length || m_return_field_def.type_handler()->cmp_type() == INT_RESULT || (_current_thd()->stmt_arena->is_stmt_execute() && m_return_field_def.length == 8 && (m_return_field_def.pack_flag & (1024U|2048U)))
Excessive stack memory usage due to WSREP_LOG
ERROR 1054 Unknown column 'ID' in 'field list' exists on 10.4, but doesn't exist on 10.3
munmap_chunk(): invalid pointer, crash in alloc_root, ASAN heap-use-after-free in lex_end_stage1 or Assertion `m_thd == __null' failed
Assertion `thd->free_list == __null' failed in MYSQLparse upon DECLARE CURSOR with parameters
Server crashes in st_select_lex_unit::exclude_level upon execution of SP
Assertion `!result' failed in convert_const_to_int upon 2nd execution of PS
FUNCTION xxx does not exist error when stored procedure cache limit is reached
Stored Aggregate Functions return NULL cross database.
Calling stored procedure twice in the same session causes MariaDB to crash
Server crashes in mysql_derived_prepare on 2nd execution of SP with views
Uncontrollable memory allocation with TRIGGERS, PROCEDURES and FUNCTIONS
stored function can see half-updated table
Server crashes in in setup_on_expr upon 3rd execution of SPMDEV-21033
Call procedures dynamically with table/field names
Function crash server
IF NOT EXISTS AND NOT EXISTS crash DB server
Server crashes in JOIN::transform_in_predicates_into_in_subq upon 2nd execution of PS/SP comparing GEOMETRY with other types
Server crashes in Item_field::type_handler upon 3rd execution of SP deleting from versioned table
Server crashes in base_list_iterator::next upon 2nd execution of SP, LOCK/UNLOCK tables are involved
Server crashes in Item_field::used_tables upon 2nd execution of SP with UPDATE on app-versioned table
DO SLEEP() incorrect evaluation when running procedure for long time
Failed to load routine: procedure containing CTE incorrectly stored in mysql.proc
Pure virtual method called in Item_ref::set_properties, SIGSEGV or ASAN heap-use-after-free in create_view_field
Exception is not captured by sqlexception handler on UPDATE with LEFT JOIN
Server crashes in get_current_user upon SET PASSWORD via SP
Server crashes in check_fields upon 2nd execution of SP with UPDATE on app-versioned table
Server crash in st_select_lex::cleanup or Assertion `sl->join == 0' failed in reinit_stmt_before_use
Wrong SHOW PROCEDURE output for SET GLOBAL sysvar1=expr, sysvar2=expr
sql_mode=ORACLE: Wrong SHOW PROCEDURE output for sysvar:=expr
Crash on an SP variable assignment to a wrong subselect
stored function with "SQL SECURITY DEFINER" DEFINER requires COLUMN PRIVILEGES
INSERT ... SELECT crashes (In Item_func::fix_fields) in complex stored procedure
Update Table Fails with Trigger and Stored Function
Update with join stopped worked if there is a call to a procedure in a trigger
Server crashes in mysql_handle_single_derived upon 2nd execution of PS
Server crash in create_view_field or Assertion `m_sp == __null' failed in Item_func_sp::fix_fields after invalidating view by dropping function
SUPER is not required for ALTER FUNCTION when log_bin_trust_function_creators=OFF and log_bin=ON
RETURN can't be used right after BEGIN
Unable to create a function in mariadb even when function in deterministic
Polymorphic Data Types for Functions
[{"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":["is","was","was in","=","was not","is not","was not in","!=","in","not in","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":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":["<","was","=","was not",">=","!=","<=","!~","not in","changed","is","was in","is not","~","was not in","in",">"],"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":"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":"\"PM Planning\"","displayName":"PM Planning - 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":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["<","was","=","was not",">=","!=","<=","not in","changed","is","was in","is not","was not in","in",">"],"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":["is","was","was in","=","was not","is not","was not in","!=","in","not in","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","=","was not",">=","!=","<=","not in","changed","is","was in","is not","was not in","in",">"],"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":["is","was","was in","=","was not","is not","was not in","!=","in","not in","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":"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":"issuesWithReminder()","displayName":"issuesWithReminder()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderDueWithin(\"\", \"\")","displayName":"issuesWithReminderDueWithin(\"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForEmail(\"\")","displayName":"issuesWithReminderForEmail(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForGroup(\"\")","displayName":"issuesWithReminderForGroup(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForRole(\"\")","displayName":"issuesWithReminderForRole(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderForUser(\"\")","displayName":"issuesWithReminderForUser(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithReminderOwnedBy(\"\")","displayName":"issuesWithReminderOwnedBy(\"\")","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":1594651714579},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1594651714580},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1594651714584},{"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":1594651714587},{"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":"Estimated Frequency","id":"customfield_12100","key":"com.atlassian.jira.plugin.system.customfieldtypes:select","isShown":false},{"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":false},{"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":"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":"PM Planning","id":"customfield_11404","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"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":false},{"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":1594651714585},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true},{"name":"QA Assignee","id":"customfield_12000","key":"com.atlassian.jira.plugin.system.customfieldtypes:userpicker","isShown":false}],"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 Stored routines </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:Performance Schema\" title=\"Performance Schema\">Performance Schema</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 selected=\"selected\" 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:Upgrades\" title=\"Upgrades\">Upgrades</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 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 = \"Stored routines\"","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=\"Recent Projects\">\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 <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=11801&size=small\"\n title=\"MariaDB Connector/C++\"\n value=\"11801\">\n MariaDB Connector/C++ (CONCPP)\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=11902&size=small\"\n title=\"MariaDB Connector/R2DBC\"\n value=\"11902\">\n MariaDB Connector/R2DBC (R2DBC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11901&size=small\"\n title=\"MariaDB Foundation Development\"\n value=\"11901\">\n MariaDB Foundation Development (MDBF)\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":"This issue is not being actively worked on at the moment.","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}]