Export - CSV (All fields)
Export - CSV (Current fields)
ZSS-511
LEFTB and REPLACEB return #NAMEZSS-506
After deleting a sheet, the charts which reference the deleted sheet cause an exception
delete the last sheet, chart on another sheet show in the last sheet.
hide all column and all row only can recover by undo (not by drag UI)
delete a reference sheet, the reference cell cause exception
Click check mark of formula bar after entering a value, all cells become unable to edit
After hiding a row contained overflow cells, the hidden row's cell text is still shown and overlap
Insert rows above cells where the chart header references will cause NPE
Get wrong cell format text after click reset in jsf/jsp demo
Opening "Insert Picture" dialog twice causes whole Spreadsheet disabled.
Can't get correct edit text if set a cell value by Date
If using xls format and reorder sheet, the sheet reference in formulas will be modified.
After trying to delete last sheet, any user action causes exceptions
If reorder a sheet and modify a cell on it, the value of formula referred to such cell will be incorrect.
change column width and JS errors show
move a sheet with chart causes an exception
After undoing a deleted column under frozen rows, gridline is in disorder
undo deleted merged cells becomes blank cells
Paste multiple rows and their order is different from original rows
Toolbar button's status doesn't update after switching sheets
Rename sheet with character "." on specific Excel file will cause exception
Set outline border around a merged cell doesn't get correct result
Formula result doesn't change after named-range updated
Multiple filters doesn't work correctly
"Blanks" in Autofilter drop-down list never shows checked
The color picker in context(popup) menu disappeared if didn't select any color and re-open context menu
border color picker and cell background color picker have different UI
Can't copy all selected cells to other application when using Chrome
Get exception when evaluating hyperlink after export & clear cell
Strange behavior when re-sizing North or West of chart/image in scrolling
Insert a hyperlink on a cell with empty hyperlink doesn't work as expected
Chart/Image doesn't move location after change column/row width/height
Cannot click on hyperlink in the merge cell.
NullPointerException when the sheet has hyperlinks with empty URL
Inserting a row at non-selected sheet with API doesn't work
delete one column at most right and bottom position and scroll up will cause JavaScript exception
After scrolling down to bottom of sheet quickly, insert a row on a row with data and delete a row, the last row's cells will have data and same as selected row.
Freeze panels and change row/column size, then switch to other sheet and back, freeze panel's headers will be chaos.
Filter popup menu is scrolled if setFreezePanel() and unfrozen region is also scrolled
Date format and display doesn't match
border patterns around a cell it is not showing in the exported pdf file
change width of columns in corner freeze panel will cause Javascript exception
Wrong sum results
IE10 resizing column (java.lang.Double cannot be cast to java.lang.Integer)
Support view with different zoom level
insert,delete whole column or row when overlap merge cell will cause unexpect result
adjust column width and javascript errors showed
after insert new sheet and export it, then input some data into this new sheet and export again. such file can't load by ZSS and Excel
if freeze the specific xlsx file and export it, its freeze position is wrong in Excel
just exported to a specific xlsx file with many formulas, Excel fail to load such file again
[{"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":["=","changed","!=","was","not in","is not","in","was not","was in","was not in","is"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"bugsInEpicCount","displayName":"bugsInEpicCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"bugsInEpicDoneCount","displayName":"bugsInEpicDoneCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"bugsInEpicInProgressCount","displayName":"bugsInEpicInProgressCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"bugsInEpicToDoCount","displayName":"bugsInEpicToDoCount","orderable":"true","searchable":"true","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":"commitsCount","displayName":"commitsCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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[10800]","orderable":"true","searchable":"true","cfid":"cf[10800]","operators":[">",">=","=","<","<=","in","!~","not in","is","is not"],"types":["java.lang.Number","java.lang.String"]},{"value":"environment","displayName":"environment","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"failingBuildsCount","displayName":"failingBuildsCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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","not in",">=","is not","in","was in","!~","is",">","<=","changed","<","was not","~","was not in"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"\" Freshservice Tickets\"","displayName":" Freshservice Tickets - cf[10200]","orderable":"true","searchable":"true","cfid":"cf[10200]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"gh.epic.color.name","displayName":"gh.epic.color.name - cf[10308]","orderable":"true","searchable":"true","cfid":"cf[10308]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"gh.epic.label.name","displayName":"gh.epic.label.name - cf[10306]","orderable":"true","searchable":"true","cfid":"cf[10306]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"gh.epic.link.name","displayName":"gh.epic.link.name - cf[10305]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10305]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"gh.epic.status.name","displayName":"gh.epic.status.name - cf[10307]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10307]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"gh.issue.businessvalues","displayName":"gh.issue.businessvalues - cf[10303]","orderable":"true","searchable":"true","cfid":"cf[10303]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"gh.issue.flaggingfield","displayName":"gh.issue.flaggingfield - cf[10300]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10300]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"gh.issue.labelfield","displayName":"gh.issue.labelfield - cf[10301]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10301]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"gh.issue.storypoints","displayName":"gh.issue.storypoints - cf[10302]","orderable":"true","searchable":"true","cfid":"cf[10302]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"gh.lexorank.field.name","displayName":"gh.lexorank.field.name - cf[10309]","orderable":"true","searchable":"true","cfid":"cf[10309]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"gh.sprint.customfield.default.name","displayName":"gh.sprint.customfield.default.name - cf[10304]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10304]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"\"Hit Rate Index\"","displayName":"Hit Rate Index - cf[10000]","orderable":"true","searchable":"true","cfid":"cf[10000]","operators":["=","!=","in","not in","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.util.Date","java.lang.String"]},{"value":"issueFunction","displayName":"issueFunction - cf[10600]","orderable":"true","searchable":"true","cfid":"cf[10600]","operators":["in","not in"],"types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"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":"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":"openPullRequestsCount","displayName":"openPullRequestsCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"openReviewsCount","displayName":"openReviewsCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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[11103]","orderable":"true","searchable":"true","cfid":"cf[11103]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"parent","displayName":"parent","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Parent Link\"","displayName":"Parent Link - cf[11100]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11100]","operators":["=","in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","was","not in",">=","is not","in","was in","is",">","<=","changed","<","was not","was not 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":"pullRequestsCount","displayName":"pullRequestsCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Release Version History\"","displayName":"Release Version History - cf[10310]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10310]","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":["=","changed","!=","was","not in","is not","in","was not","was in","was not in","is"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","was","not in",">=","is not","in","was in","is",">","<=","changed","<","was not","was not 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":"reviewsCount","displayName":"reviewsCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"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":"\"Security Level\"","displayName":"Security Level - cf[11000]","orderable":"true","searchable":"true","cfid":"cf[11000]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["=","changed","!=","was","not in","is not","in","was not","was in","was not in","is"],"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":"storiesInEpicCount","displayName":"storiesInEpicCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"storiesInEpicDoneCount","displayName":"storiesInEpicDoneCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"storiesInEpicInProgressCount","displayName":"storiesInEpicInProgressCount","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"storiesInEpicToDoCount","displayName":"storiesInEpicToDoCount","orderable":"true","searchable":"true","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":"\"Target end\"","displayName":"Target end - cf[11102]","orderable":"true","searchable":"true","cfid":"cf[11102]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Target start\"","displayName":"Target start - cf[11101]","orderable":"true","searchable":"true","cfid":"cf[11101]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"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":"addedAfterSprintStart()","displayName":"addedAfterSprintStart()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"affectedVersionCountEqualTo(\"\")","displayName":"affectedVersionCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionCountGreaterThan(\"\")","displayName":"affectedVersionCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionCountLessThan(\"\")","displayName":"affectedVersionCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionReleasedAfterDate(\"\")","displayName":"affectedVersionReleasedAfterDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionReleasedBeforeDate(\"\")","displayName":"affectedVersionReleasedBeforeDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionReleasedBetweenDates(\"\")","displayName":"affectedVersionReleasedBetweenDates(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionReleasedOnDate(\"\")","displayName":"affectedVersionReleasedOnDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsArchivedCountEqualTo(\"\")","displayName":"affectedVersionsArchivedCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsArchivedCountGreaterThan(\"\")","displayName":"affectedVersionsArchivedCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsArchivedCountLessThan(\"\")","displayName":"affectedVersionsArchivedCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsOpenedCountEqualTo(\"\")","displayName":"affectedVersionsOpenedCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsOpenedCountGreaterThan(\"\")","displayName":"affectedVersionsOpenedCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsOpenedCountLessThan(\"\")","displayName":"affectedVersionsOpenedCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsReleasedCountEqualTo(\"\")","displayName":"affectedVersionsReleasedCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsReleasedCountGreaterThan(\"\")","displayName":"affectedVersionsReleasedCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"affectedVersionsReleasedCountLessThan(\"\")","displayName":"affectedVersionsReleasedCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"aggregateExpression()","displayName":"aggregateExpression()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"allIssuesInEpic(\"\")","displayName":"allIssuesInEpic(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"archivedVersions()","displayName":"archivedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"attachedAfter(\"\")","displayName":"attachedAfter(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachedBefore(\"\")","displayName":"attachedBefore(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachedBetween(\"\")","displayName":"attachedBetween(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachedByUser(\"\")","displayName":"attachedByUser(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachedOnDate(\"\")","displayName":"attachedOnDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachmentExtension(\"\")","displayName":"attachmentExtension(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachmentName(\"\")","displayName":"attachmentName(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachmentsCountEqualTo(\"\")","displayName":"attachmentsCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachmentsCountGreaterThan(\"\")","displayName":"attachmentsCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"attachmentsCountLessThan(\"\")","displayName":"attachmentsCountLessThan(\"\")","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":"commented()","displayName":"commented()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"commentedAfter(\"\")","displayName":"commentedAfter(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedBefore(\"\")","displayName":"commentedBefore(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedBetween(\"\")","displayName":"commentedBetween(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedByUser(\"\")","displayName":"commentedByUser(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentedOn(\"\")","displayName":"commentedOn(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentsCountEqualTo(\"\")","displayName":"commentsCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentsCountGreaterThan(\"\")","displayName":"commentsCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"commentsCountLessThan(\"\")","displayName":"commentsCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"completeInSprint()","displayName":"completeInSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"componentMatch()","displayName":"componentMatch()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"dateCompare()","displayName":"dateCompare()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"earliestUnreleasedVersionByReleaseDate()","displayName":"earliestUnreleasedVersionByReleaseDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"endOfDay()","displayName":"endOfDay()","types":["java.util.Date"]},{"value":"endOfMonth()","displayName":"endOfMonth()","types":["java.util.Date"]},{"value":"endOfWeek()","displayName":"endOfWeek()","types":["java.util.Date"]},{"value":"endOfYear()","displayName":"endOfYear()","types":["java.util.Date"]},{"value":"epicOf(\"\")","displayName":"epicOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"epicsOf()","displayName":"epicsOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"expression()","displayName":"expression()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"fieldMatch(\"\")","displayName":"fieldMatch(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fieldsHaveSameValue(\"\")","displayName":"fieldsHaveSameValue(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fileAttached()","displayName":"fileAttached()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"fixVersionCountEqualTo(\"\")","displayName":"fixVersionCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionCountGreaterThan(\"\")","displayName":"fixVersionCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionCountLessThan(\"\")","displayName":"fixVersionCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionReleasedAfterDate(\"\")","displayName":"fixVersionReleasedAfterDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionReleasedBeforeDate(\"\")","displayName":"fixVersionReleasedBeforeDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionReleasedBetweenDates(\"\")","displayName":"fixVersionReleasedBetweenDates(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionReleasedOnDate(\"\")","displayName":"fixVersionReleasedOnDate(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsArchivedCountEqualTo(\"\")","displayName":"fixVersionsArchivedCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsArchivedCountGreaterThan(\"\")","displayName":"fixVersionsArchivedCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsArchivedCountLessThan(\"\")","displayName":"fixVersionsArchivedCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsOpenedCountEqualTo(\"\")","displayName":"fixVersionsOpenedCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsOpenedCountGreaterThan(\"\")","displayName":"fixVersionsOpenedCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsOpenedCountLessThan(\"\")","displayName":"fixVersionsOpenedCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsReleasedCountEqualTo(\"\")","displayName":"fixVersionsReleasedCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsReleasedCountGreaterThan(\"\")","displayName":"fixVersionsReleasedCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"fixVersionsReleasedCountLessThan(\"\")","displayName":"fixVersionsReleasedCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"hasAttachments()","displayName":"hasAttachments()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasComments()","displayName":"hasComments()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasLinks()","displayName":"hasLinks()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasLinkType()","displayName":"hasLinkType()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasRemoteLinks()","displayName":"hasRemoteLinks()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"hasSubtasks()","displayName":"hasSubtasks()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"inactiveUsers()","displayName":"inactiveUsers()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"incompleteInSprint()","displayName":"incompleteInSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issueFieldExactMatch()","displayName":"issueFieldExactMatch()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issueFieldMatch()","displayName":"issueFieldMatch()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuePickerField()","displayName":"issuePickerField()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issuesInEpics()","displayName":"issuesInEpics()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"issuesInPlan(\"\")","displayName":"issuesInPlan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesInProgram(\"\")","displayName":"issuesInProgram(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"jiraUserPropertyEquals()","displayName":"jiraUserPropertyEquals()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"lastComment()","displayName":"lastComment()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"lastUpdated()","displayName":"lastUpdated()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"latestReleaseVersionForProject(\"\")","displayName":"latestReleaseVersionForProject(\"\")","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedBy(\"\")","displayName":"linkedBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedByIssueProject()","displayName":"linkedByIssueProject()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuePriority()","displayName":"linkedIssuePriority()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssuesOf()","displayName":"linkedIssuesOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfAll()","displayName":"linkedIssuesOfAll()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfAllRecursive()","displayName":"linkedIssuesOfAllRecursive()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfAllRecursiveLimited()","displayName":"linkedIssuesOfAllRecursiveLimited()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfRecursive()","displayName":"linkedIssuesOfRecursive()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfRecursiveLimited()","displayName":"linkedIssuesOfRecursiveLimited()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssuesOfRemote()","displayName":"linkedIssuesOfRemote()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"linkedIssueStatus()","displayName":"linkedIssueStatus()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssueStatusCategory()","displayName":"linkedIssueStatusCategory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkedIssueType()","displayName":"linkedIssueType()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"links(\"\")","displayName":"links(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linksCountEqualTo(\"\")","displayName":"linksCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linksCountGreaterThan(\"\")","displayName":"linksCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linksCountLessThan(\"\")","displayName":"linksCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linksIssue(\"\")","displayName":"linksIssue(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"linkType()","displayName":"linkType()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"loggedTimeByUser(\"\")","displayName":"loggedTimeByUser(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"memberOfRole()","displayName":"memberOfRole()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"movedIssues()","displayName":"movedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"myProjects()","displayName":"myProjects()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"nextSprint()","displayName":"nextSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"overdue()","displayName":"overdue()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"parentIssuesOf(\"\")","displayName":"parentIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"parentOf(\"\")","displayName":"parentOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"parentsOf()","displayName":"parentsOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"portfolioChildrenOf()","displayName":"portfolioChildrenOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"portfolioParentsOf()","displayName":"portfolioParentsOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"previousSprint()","displayName":"previousSprint()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"projectMatch()","displayName":"projectMatch()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsOfType()","displayName":"projectsOfType()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasPermission(\"\")","displayName":"projectsWhereUserHasPermission(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasRole(\"\")","displayName":"projectsWhereUserHasRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"recentProjects()","displayName":"recentProjects()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"releaseDate()","displayName":"releaseDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"removedAfterSprintStart()","displayName":"removedAfterSprintStart()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"standardIssueTypes()","displayName":"standardIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"startDate()","displayName":"startDate()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"startOfDay()","displayName":"startOfDay()","types":["java.util.Date"]},{"value":"startOfMonth()","displayName":"startOfMonth()","types":["java.util.Date"]},{"value":"startOfWeek()","displayName":"startOfWeek()","types":["java.util.Date"]},{"value":"startOfYear()","displayName":"startOfYear()","types":["java.util.Date"]},{"value":"subtaskCountEqualTo(\"\")","displayName":"subtaskCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subtaskCountGreaterThan(\"\")","displayName":"subtaskCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subtaskCountLessThan(\"\")","displayName":"subtaskCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subTaskIssueTypes()","displayName":"subTaskIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"subTaskKey()","displayName":"subTaskKey()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subTaskOf(\"\")","displayName":"subTaskOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subTaskPriority(\"\")","displayName":"subTaskPriority(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subtasksOf()","displayName":"subtasksOf()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]},{"value":"subTaskStatus(\"\")","displayName":"subTaskStatus(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subTaskStatusCategory(\"\")","displayName":"subTaskStatusCategory(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"subTaskType(\"\")","displayName":"subTaskType(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"transitionedByUser(\"\")","displayName":"transitionedByUser(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"updatedByUser(\"\")","displayName":"updatedByUser(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"updatedByUserCountEqualTo(\"\")","displayName":"updatedByUserCountEqualTo(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"updatedByUserCountGreaterThan(\"\")","displayName":"updatedByUserCountGreaterThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"updatedByUserCountLessThan(\"\")","displayName":"updatedByUserCountLessThan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"userMatch(\"\")","displayName":"userMatch(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"versionMatch()","displayName":"versionMatch()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"votedIssues()","displayName":"votedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"watchedIssues()","displayName":"watchedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workedIssues(\"\", \"\", \"\")","displayName":"workedIssues(\"\", \"\", \"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"workLogged()","displayName":"workLogged()","isList":"true","types":["com.onresolve.jira.groovy.jql.IndexingCustomField"]}]
["explain","select","isnull","commit","isempty","when","rowid","output","number","character","identified","sqrt","delimiter","else","exclusive","lock","catch","join","strict","greater","if","between","order","having","in","byte","double","subtract","outer","index","raw","is","then","execute","input","as","defaults","field","size","left","unique","difference","returns","begin","modulo","object","trans","minus","access","increment","sum","long","into","uid","current","default","file","goto","min","audit","by","share","where","after","power","escape","connect","noaudit","table","validate","cf","set","break","initial","max","more","column","right","trigger","union","asc","rename","decrement","equals","fetch","char","exists","notin","to","first","return","transaction","checkpoint","date","privileges","declare","before","do","integer","float","while","empty","mode","view","whenever","prior","continue","function","intersection","limit","raise","create","from","collation","alter","group","add","all","last","like","resource","count","check","less","encoding","inner","rownum","collate","null","abort","immediate","true","decimal","exec","nowait","changed","desc","option","drop","next","string","session","values","for","distinct","insert","revoke","update","delete","not","synonym","avg","public","and","of","define","alias","divide","end","row","multiply","on","or","intersect","previous","false","go","start","was","rows","any","int","modify","with","inout","boolean","grant","remainder","user"]
{"searchers":{"groups":[{"searchers":[{"name":"Project","id":"project","key":"issue.field.project","isShown":true,"lastViewed":1679440286004},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true,"lastViewed":1679440286005},{"name":"Status","id":"status","key":"issue.field.status","isShown":true,"lastViewed":1679440286008},{"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,"lastViewed":1679440286010},{"name":"Component","id":"component","key":"issue.field.components","isShown":true},{"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":"Development","id":"customfield_10800","key":"com.atlassian.jira.plugins.jira-development-integration-plugin:devsummary","isShown":true},{"name":"Original story points","id":"customfield_11103","key":"com.atlassian.jpo:jpo-custom-field-original-story-points","isShown":true},{"name":"Release Version History","id":"customfield_10310","key":"com.pyxis.greenhopper.jira:greenhopper-releasedmultiversionhistory","isShown":true},{"name":"Security Level","id":"customfield_11000","key":"com.atlassian.jira.plugin.system.customfieldtypes:textfield","isShown":true},{"name":"Epic Name","id":"customfield_10306","key":"com.pyxis.greenhopper.jira:gh-epic-label","isShown":true},{"name":"Epic Link","id":"customfield_10305","key":"com.pyxis.greenhopper.jira:gh-epic-link","isShown":true},{"name":"Flagged","id":"customfield_10300","key":"com.atlassian.jira.plugin.system.customfieldtypes:multicheckboxes","isShown":true},{"name":"Epic/Theme","id":"customfield_10301","key":"com.atlassian.jira.plugin.system.customfieldtypes:labels","isShown":true},{"name":"Rank","id":"customfield_10309","key":"com.pyxis.greenhopper.jira:gh-lexo-rank","isShown":true},{"name":"Sprint","id":"customfield_10304","key":"com.pyxis.greenhopper.jira:gh-sprint","isShown":true},{"name":"issueFunction","id":"customfield_10600","key":"com.onresolve.jira.groovy.groovyrunner:jqlFunctionsCustomFieldType","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":"Target end","id":"customfield_11102","key":"com.atlassian.jpo:jpo-custom-field-baseline-end","isShown":true},{"name":"Target start","id":"customfield_11101","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":1679440286009},{"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 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12403&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 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12407&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10002\"\n title=\"Epic\"\n value=\"10002\">Epic</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12411&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_2\"\n title=\"New Feature\"\n value=\"2\">New Feature</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12415&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10003\"\n title=\"Story\"\n value=\"10003\">Story</option>\n </optgroup>\n\n <optgroup label=\"Sub-Task Issue Types\">\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12416&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10200\"\n title=\"Documentation\"\n value=\"10200\">Documentation</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12416&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10001\"\n title=\"Research\"\n value=\"10001\">Research</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12407&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10100\"\n title=\"Testing\"\n value=\"10100\">Testing</option>\n \n <option class=\" imagebacked 10000 \"\n data-icon=\"/secure/viewavatar?size=xsmall&avatarId=12418&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10000\"\n title=\"Verify\"\n value=\"10000\">Verify</option>\n </optgroup>\n </select>\n </div>\n ","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/ZSS\" title=\"Browse ZK Spreadsheet project\">ZK Spreadsheet</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=10101&size=small\"\n selected=\"selected\" title=\"ZK Spreadsheet\"\n value=\"10101\">\n ZK Spreadsheet (ZSS)\n </option>\n </optgroup>\n <optgroup label=\"All Projects\">\n \n <option data-icon=\"/secure/projectavatar?pid=10600&size=small\"\n title=\"Freshdesk Jira Test Project\"\n value=\"10600\">\n Freshdesk Jira Test Project (FD)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11100&size=small\"\n title=\"Keikai\"\n value=\"11100\">\n Keikai (KEIKAI)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10800&size=small\"\n title=\"Project Q\"\n value=\"10800\">\n Project Q (PQ)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10400&size=small\"\n title=\"ZATS\"\n value=\"10400\">\n ZATS (ZATS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10000&size=small\"\n title=\"ZK\"\n value=\"10000\">\n ZK (ZK)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10900&size=small\"\n title=\"ZK Addon\"\n value=\"10900\">\n ZK Addon (ZKADDON)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10201&size=small\"\n title=\"ZK Calendar\"\n value=\"10201\">\n ZK Calendar (ZKCAL)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10500&size=small\"\n title=\"ZK Charts\"\n value=\"10500\">\n ZK Charts (ZKCHARTS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10700&size=small\"\n title=\"ZK CKeditor\"\n value=\"10700\">\n ZK CKeditor (ZKCK)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10300&size=small\"\n title=\"ZK Document\"\n value=\"10300\">\n ZK Document (ZKDOC)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=11000&size=small\"\n title=\"ZK Fiddle\"\n value=\"11000\">\n ZK Fiddle (ZKFIDDLE)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10701&size=small\"\n title=\"ZK Gmaps\"\n value=\"10701\">\n ZK Gmaps (ZKGMAPS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10103&size=small\"\n title=\"ZK JSP\"\n value=\"10103\">\n ZK JSP (ZKJSP)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10203&size=small\"\n title=\"ZK Pivottable\"\n value=\"10203\">\n ZK Pivottable (ZKPVT)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10101&size=small\"\n selected=\"selected\" title=\"ZK Spreadsheet\"\n value=\"10101\">\n ZK Spreadsheet (ZSS)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10202&size=small\"\n title=\"ZK Spring\"\n value=\"10202\">\n ZK Spring (ZKSPRING)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10200&size=small\"\n title=\"ZK Studio\"\n value=\"10200\">\n ZK Studio (ZKSTUDIO)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10100&size=small\"\n title=\"ZTL\"\n value=\"10100\">\n ZTL (ZTL)\n </option>\n </optgroup>\n </select>\n </div>\n \n","jql":"project = ZSS","validSearcher":true,"isShown":true},"fixfor":{"name":"Fix Version","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldfixfor\">Fix Version:</label><span id=\"fieldfixfor\" class=\"fieldValue\">\n \n 3.0.0 </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-projectconstant\" >\n <label for=\"searcher-fixfor\">Fix Version</label>\n <select class=\"select js-default-checkboxmultiselect\" id=\"searcher-fixfor\" multiple=\"multiple\" name=\"fixfor\" size=\"2\" >\n <optgroup label=\"\">\n <option value=\"-1\" title=\"No Version\">No Version</option>\n <option value=\"-2\" title=\"Unreleased Versions\">Unreleased Versions</option>\n <option value=\"-3\" title=\"Released Versions\">Released Versions</option>\n </optgroup>\n <optgroup label=\"Unreleased Versions\">\n <option value=\"id:2.1.0\" title=\"2.1.0\">2.1.0</option>\n <option value=\"id:2.1.1\" title=\"2.1.1\">2.1.1</option>\n <option value=\"id:2.2.0\" title=\"2.2.0\">2.2.0</option>\n <option value=\"id:2.3.0\" title=\"2.3.0\">2.3.0</option>\n <option value=\"id:2.5.0\" title=\"2.5.0\">2.5.0</option>\n <option value=\"id:2.6.0\" title=\"2.6.0\">2.6.0</option>\n <option selected=\"selected\" value=\"id:3.0.0\" title=\"3.0.0\">3.0.0</option>\n <option value=\"id:3.0.0 RC\" title=\"3.0.0 RC\">3.0.0 RC</option>\n <option value=\"id:3.0.1\" title=\"3.0.1\">3.0.1</option>\n <option value=\"id:3.0.2\" title=\"3.0.2\">3.0.2</option>\n <option value=\"id:3.5.0 RC\" title=\"3.5.0 RC\">3.5.0 RC</option>\n <option value=\"id:3.6.0\" title=\"3.6.0\">3.6.0</option>\n <option value=\"id:3.7.0\" title=\"3.7.0\">3.7.0</option>\n <option value=\"id:3.8.0\" title=\"3.8.0\">3.8.0</option>\n <option value=\"id:3.8.0.1\" title=\"3.8.0.1\">3.8.0.1</option>\n <option value=\"id:3.8.0.FL\" title=\"3.8.0.FL\">3.8.0.FL</option>\n <option value=\"id:3.8.1\" title=\"3.8.1\">3.8.1</option>\n <option value=\"id:3.8.1.FL\" title=\"3.8.1.FL\">3.8.1.FL</option>\n <option value=\"id:3.8.2\" title=\"3.8.2\">3.8.2</option>\n <option value=\"id:3.8.3\" title=\"3.8.3\">3.8.3</option>\n <option value=\"id:3.8.3.FL\" title=\"3.8.3.FL\">3.8.3.FL</option>\n <option value=\"id:3.9.0\" title=\"3.9.0\">3.9.0</option>\n <option value=\"id:3.9.0.FL\" title=\"3.9.0.FL\">3.9.0.FL</option>\n <option value=\"id:3.9.1\" title=\"3.9.1\">3.9.1</option>\n <option value=\"id:3.9.2\" title=\"3.9.2\">3.9.2</option>\n <option value=\"id:3.9.3\" title=\"3.9.3\">3.9.3</option>\n <option value=\"id:8.0.3\" title=\"8.0.3\">8.0.3</option>\n <option value=\"id:Freshly\" title=\"Freshly\">Freshly</option>\n </optgroup>\n <optgroup label=\"Released Versions\">\n <option value=\"id:3.5.0\" title=\"3.5.0\">3.5.0</option>\n <option value=\"id:3.9.4\" title=\"3.9.4\">3.9.4</option>\n <option value=\"id:3.9.5\" title=\"3.9.5\">3.9.5</option>\n <option value=\"id:3.9.6\" title=\"3.9.6\">3.9.6</option>\n </optgroup>\n </select>\n </div>\n ","jql":"fixVersion = 3.0.0","validSearcher":true,"isShown":true},"assignee":{"name":"Assignee","editHtml":"\n \n <div class=\"field-group aui-field-userlist\" >\n <label for=\"searcher-assigneeSelect\">Assignee</label>\n <fieldset rel=\"assignee\" class=\"hidden user-group-searcher-params\">\n </fieldset>\n <select class=\"js-usergroup-checkboxmultiselect\" multiple=\"multiple\" id=\"assignee\" name=\"assignee\" data-placeholder-text=\"Enter username or group\">\n <optgroup>\n <option class=\"headerOption\" data-icon=\"https://tracker.zkoss.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":"The issue is open and ready for the assignee to start work on it.","iconUrl":"/images/icons/statuses/open.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Open</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/reopened.png\" value=\"4\" title=\"Reopened\" data-simple-status=\"{"id":"4","name":"Reopened","description":"This issue was once resolved, but the resolution was deemed incorrect. From here issues are either marked assigned or resolved.","iconUrl":"/images/icons/statuses/reopened.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Reopened</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/resolved.png\" value=\"5\" title=\"Resolved\" data-simple-status=\"{"id":"5","name":"Resolved","description":"A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.","iconUrl":"/images/icons/statuses/resolved.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Resolved</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/closed.png\" value=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"The issue is considered finished, the resolution is correct. Issues which are closed can be reopened.","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/resolved.png\" value=\"10000\" title=\"In Testing\" data-simple-status=\"{"id":"10000","name":"In Testing","description":"A resolution has been taken, and it is awaiting verification by tester. From here issues are either reopened, or are closed. ","iconUrl":"/images/icons/statuses/resolved.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">In Testing</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}]
0.3
0