Export - CSV (All fields)
Export - CSV (Current fields)
MDEV-20497
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
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 deterministicMDEV-18951
Polymorphic Data Types for Functions
PROCEDURE and anonymous blocks silently ignore FETCH GROUP NEXT ROW
Port "MDEV-7773 Aggregate stored functions" to sql_yacc_ora.yy
Server crash in find_field_in_tables upon 2nd execution of SP which causes ER_WRONG_GROUP_FIELD
User defined aggregate functions not working correctly when the schema is changed
Mariadb 10.3 crashed with signal 11
Server crashes in TABLE_LIST::reinit_before_use upon ADD FOREIGN KEY on 2nd execution of PS/SP
Server crashes in sp_process_definer upon 2nd execution of PS/SP with CREATE ROLE
Conversion from TIMESTAMP to VARCHAR SP variables does not work well on fractional digits
AddressSanitizer: use-after-poison in Item_change_list::rollback_item_tree_changes
Server crashes in Item_null_result::field_type upon SELECT with CHARSET(date) and ROLLUP
Unexpected connection abort after certain operations from within stored procedure
Reduce SP memory usage
CURSOR FOR LOOP - ERROR: unexpected end of stream, read 0 bytes (SERVER CRASH)
Stored Functions need their own temporary table namespace
Session variable initialization
Server crash in base_list::push_back or ASAN use-after-poison in multi_update::prepare upon 2nd execution of SP with erroneous UPDATE
Server crashes in find_order_in_list upon 2nd (3rd) execution of SP with UPDATE
Server crashes in base_list_iterator::next upon TRUNCATE PARTITION through SPs or Assertion `!alloced || !Ptr || !Alloced_length || (Alloced_length >= (str_length + 1))' fails in String::c_ptr
Server crashes in Field_iterator_natural_join::next upon 2nd execution of SP
Server crashes in unsafe_key_update upon attempt to update view through 2nd execution of SP
ASAN heap-use-after-free in my_charlen_utf8 / handle_if_exists_options on 2nd execution of SP with ALTER adding CHECK constraint
ASAN heap-use-after-free in my_charlen_utf8 / my_well_formed_char_length_utf8 on 2nd execution of SP with ALTER trying to add bad CHECK
mariadb crash in find_field_in_tables
Server crash in insert_fields or unexpected ER_NO_TABLES_USED upon 2nd execution of SP
2nd execution of SP: ASAN heap-use-after-free in my_strcasecmp_utf8 or Assertion `ls->length < 0xFFFFFFFFL && ((ls->length == 0 && !ls->str) || ls->length == strlen(ls->str))' or unexpected ER_TOO_LONG_IDENT
Assertion `!conds' failed in mysql_delete upon 2nd execution of SP with DELETE HISTORY
Hangs server with repeating log entry
"Table Does Not Exist" Error from Recursive CTE Query Inside Function
SP variables do not return expected NULL in summary rows in ROLLUP queries
SP with a CONTINUE HANDLER inside a loop wastes THD memory aggressively
[{"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 not","was","not in","changed","was in","in","was not in","is not","="],"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":["is","!=","was not","not in","<","in","was not in","is not",">=","=","<=","~","was","changed","was 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.String","java.lang.Number","java.util.Date"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issuetype","displayName":"issuetype","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"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":["is","!=","was not","not in","<","in","was not in","is not",">=","=","<=","was","changed","was 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 not","was","not in","changed","was in","in","was not in","is not","="],"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":["is","!=","was not","not in","<","in","was not in","is not",">=","=","<=","was","changed","was 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 not","was","not in","changed","was in","in","was not in","is not","="],"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":"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":1569176256954},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1569176256955},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1569176256958},{"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":1569176256961},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true},{"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":"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":"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":false},{"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":1569176256960},{"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 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: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: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=\"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=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}]