PLAYSQL-300app failed to enable
PLAYSQL-298Announce/enforce the end-of-life of Play SQL Spreadsheets in the UI (cancelled)
PLAYSQL-296PlaySQL Datepicker doesn't work in Spreadsheets
PLAYSQL-295Dynamic Parameter fails when Output=POOR or Output=PRINT
PLAYSQL-294Forms: Can't use # for an ID > 50
PLAYSQL-293Is it possible to search in Play SQL query macro
PLAYSQL-292Dynamic parameter
PLAYSQL-291Avoid failure when a column can't be deleted
PLAYSQL-290Play SQL Forms cannot be activated
PLAYSQL-289Jira Link not working
PLAYSQL-288Issue on confluence with enabling spreadsheets and forms after upgrades
PLAYSQL-286Impossible to filter and export on foreign key columns
PLAYSQL-284Unable to save settings
PLAYSQL-283AJS Compatibility
PLAYSQL-282Fix javascript error when opening the list of formulas
PLAYSQL-281Formulas chashes the page when use formulas on Confluence 6.15.7
PLAYSQL-280Add notifications or alerts
PLAYSQL-279Spreadsheet compatibility with Confluence 7.0
PLAYSQL-278Data in spreadsheet not getting saved/displayed
PLAYSQL-277Unable to add a new column
PLAYSQL-276Add an option to show full spreadsheet by default (will be 200 records by default)
PLAYSQL-274Not able to update and save playsql spreadsheet
PLAYSQL-273Not able to link Requirements to Jira
PLAYSQL-272Cannot Export All - Error for deleted table
PLAYSQL-271Play SQL Export Format - Can the format be fixed
PLAYSQL-270XSS vector on PCloud and Server
PLAYSQL-269Export Table / View Describes (Like SQL Describe)
PLAYSQL-268Play SQL Bug - Gives Null Pointer Exception on an Export
PLAYSQL-267Security: arbitrary users able to edit table queries
PLAYSQL-266Add-on comaptibilty with Confluence data center latest version 6.15.1
PLAYSQL-265Remove feedback job
PLAYSQL-263Question how to enable names in x axis for all bars.
PLAYSQL-262Can I set the session state before running the actual query?
PLAYSQL-261Play SQL Apps - Data Centre Compatibility
PLAYSQL-260Why viewing Chart requires logging in?
PLAYSQL-259$errorText when spawning query editor
PLAYSQL-258Incorrect JIRA Relations in Traceability Matrix
PLAYSQL-257Error when pasting Excel tables
PLAYSQL-256Could not display PlaySQL: error
PLAYSQL-255Display a descriptive error message when there is an SQL syntax error
PLAYSQL-254Bug at installation
PLAYSQL-253Get rid of the "See also" pages list in the "hover-on" requirement card
PLAYSQL-252Image renderer
PLAYSQL-251When I paste a table, it should become a macro, not a confluence table
PLAYSQL-249Date/time, default values and access
PLAYSQL-247Ensure the administrator sets up the database as read-write
PLAYSQL-246Can't set a date to NULL
PLAYSQL-245Play SQL Forms Application
PLAYSQL-244Sometimes, certain columns are missing in the query results.
PLAYSQL-243The list of queries is not sorted by name, but by URL!
PLAYSQL-242Deletion of queries or spreadsheets
PLAYSQL-241Error in Create Joint Tables
PLAYSQL-240PlaySql Permissions
PLAYSQL-239Javascript error in certain circumstances
PLAYSQL-238Troubles generating autosuggestion
PLAYSQL-237Dialects: Replace SQL templates with Kotlin code
PLAYSQL-236Line Totals not working
PLAYSQL-233'Unknown' Error When Using Form to Create Record
PLAYSQL-232Scripts: User permissions
PLAYSQL-231Scripts: Security and Cors
PLAYSQL-230Charts: As a user, I want to use query results as a data source for the chart
PLAYSQL-229Charts: As a user, I want to be able to create a chart
PLAYSQL-228Can't install Play SQL
PLAYSQL-227ECMAScript 6 is not compatible with IE10
PLAYSQL-226Play SQL Forms has a compatibility issue with the latest version of Play SQL Spreadsheets
PLAYSQL-224Unable to disable a PlaySQL connection: It says "Please select a dialect"
PLAYSQL-223Error in creating spreadsheet - database lock acquisition
PLAYSQL-222Setup: Using an empty schema name + JNDI
PLAYSQL-221Conditional formatting
PLAYSQL-219User/Page Pickers bug
PLAYSQL-218playSQL Spreadsheets not working in IE browser
PLAYSQL-217You are not permitted to perform this operation - playsql
PLAYSQL-215Manage Foreign Tables from inside of Play SQL...
PLAYSQL-214Manage table permissions
PLAYSQL-213Ability to transform a normal table into a Play SQL one
PLAYSQL-212Ability to reverse table axis
PLAYSQL-211Exporting forms in PDF
PLAYSQL-210Connection with SQL Server is not working
PLAYSQL-209Improve Dialects API
PLAYSQL-208Compatibility with Confluence 6.0 and Data Center
PLAYSQL-206Use the PSEA add-on for Excel exports
PLAYSQL-205Record browser unsuable after inserting record and page reload
PLAYSQL-204Move a table to another space
PLAYSQL-203Dialect should be Required when configuring the database
PLAYSQL-202Confusing 'Next' button when configuring a database
PLAYSQL-201Warn when the context/space key is not set
PLAYSQL-200support for vertical table layout
PLAYSQL-199org.swift.confluence.dynamictable.DynamicTableManager interferes with Play SQL
PLAYSQL-197Unable to add rows to new/existing tables
PLAYSQL-196Import excel worksheet to create playsql table
PLAYSQL-195after deleting spreadsheet, i cannot create a new one with the same name
PLAYSQL-194cant delete row in simple spreadsheet
PLAYSQL-193Anonymous can't run queries
PLAYSQL-192Bug with Confluence 5.9.1 compatibility
PLAYSQL-191Column UI - Unable to retrieve correct datatype from db
PLAYSQL-190Pivoting a large row into a single column
PLAYSQL-189Error: "Multiple ResultSets were returned by the query"
PLAYSQL-188Question: How do you create auto-sequence number column?
PLAYSQL-187SQL syntax error: Incorrect syntax near 'LIMIT'
PLAYSQL-186Bugs in the wizard named "Create query from spreadsheet"
PLAYSQL-185Spreadsheets can't be inserted in Global Templates
PLAYSQL-184Error removing a connection
PLAYSQL-183Joint Tables should work across spaces
PLAYSQL-182Ability to style spreadsheets in PDF exports
PLAYSQL-181Ability to style form fields
PLAYSQL-180Styling applied to Play SQL form
PLAYSQL-179Refreshing a spreadsheet
PLAYSQL-178Ability to utilise Datetime database fields
PLAYSQL-177Insert a query from another space ("Recently Viewed")
PLAYSQL-176Complete support for "AS" in MySQL
PLAYSQL-175Update the license information
PLAYSQL-174Excel export
PLAYSQL-173Disable the legacy macro
PLAYSQL-172Column width: Improvements
PLAYSQL-171Icon for filtered columns
PLAYSQL-170Full screen mode
PLAYSQL-167Selection and copy-paste
PLAYSQL-165Joint Tables: Use another ID column than the primary key
PLAYSQL-164Changing name of the column label/name will move the column to last
PLAYSQL-163Disallow ID as column - special button to show ID column
[{"value":"\"[CHART] Date of First Response\"","displayName":"[CHART] Date of First Response - [CHART] Date of First Response","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"[CHART] Date of First Response[Date of first response]\"","displayName":"[CHART] Date of First Response - [CHART] Date of First Response[Date of first response]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"cf[10001]","displayName":"[CHART] Date of First Response - cf[10001]","orderable":"true","cfid":"cf[10001]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"[CHART] Time in Status\"","displayName":"[CHART] Time in Status - [CHART] Time in Status","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"[CHART] Time in Status[Time in Status]\"","displayName":"[CHART] Time in Status - [CHART] Time in Status[Time in Status]","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"cf[10000]","displayName":"[CHART] Time in Status - cf[10000]","orderable":"true","cfid":"cf[10000]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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":"Approvals","displayName":"Approvals - Approvals","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"\"Approvals[Approvals]\"","displayName":"Approvals - Approvals[Approvals]","searchable":"true","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"cf[10400]","displayName":"Approvals - cf[10400]","orderable":"true","cfid":"cf[10400]","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"Approvers","displayName":"Approvers - Approvers","operators":[],"types":["java.lang.Object"]},{"value":"\"Approvers[User Picker (multiple users)]\"","displayName":"Approvers - Approvers[User Picker (multiple users)]","operators":[],"types":["java.lang.Object"]},{"value":"cf[11007]","displayName":"Approvers - cf[11007]","orderable":"true","cfid":"cf[11007]","operators":[],"types":["java.lang.Object"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["=","not in","changed","is not","was in","was not","is","was","was not in","!=","in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"assignee.property","displayName":"assignee.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.lang.Number","java.util.Date"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"buildName","displayName":"buildName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"buildState","displayName":"buildState","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Business Value\"","displayName":"Business Value - Business Value","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Business Value[Number]\"","displayName":"Business Value - Business Value[Number]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10005]","displayName":"Business Value - cf[10005]","orderable":"true","cfid":"cf[10005]","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":"change-control-type","displayName":"change-control-type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"change-gating-type","displayName":"change-gating-type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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":"creator.property","displayName":"creator.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.lang.Number","java.util.Date"]},{"value":"cf[11011]","displayName":"Data Center SEN - cf[11011]","orderable":"true","cfid":"cf[11011]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Data Center SEN\"","displayName":"Data Center SEN - Data Center SEN","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Data Center SEN[Short text]\"","displayName":"Data Center SEN - Data Center SEN[Short text]","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentEnvironmentName","displayName":"deploymentEnvironmentName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentEnvironmentType","displayName":"deploymentEnvironmentType","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentName","displayName":"deploymentName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"deploymentState","displayName":"deploymentState","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"development","displayName":"development - cf[10600]","orderable":"true","searchable":"true","cfid":"cf[10600]","operators":["<","<=",">",">="],"types":["java.lang.Number"]},{"value":"environment","displayName":"environment","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"cf[10003]","displayName":"Epic/Theme - cf[10003]","auto":"true","orderable":"true","cfid":"cf[10003]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic/Theme\"","displayName":"Epic/Theme - Epic/Theme","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic/Theme[Labels]\"","displayName":"Epic/Theme - Epic/Theme[Labels]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Color\"","displayName":"Epic Color - cf[10011]","orderable":"true","searchable":"true","cfid":"cf[10011]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10008]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10008]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10009]","orderable":"true","searchable":"true","cfid":"cf[10009]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10010]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10010]","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":["<","changed","was in","was not","was","in",">",">=","=","not in","is not","<=","is","was not in","!="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"flagDisabledRollout","displayName":"flagDisabledRollout","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagEnabled","displayName":"flagEnabled","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagEnabledRollout","displayName":"flagEnabledRollout","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"cf[10002]","displayName":"Flagged - cf[10002]","auto":"true","orderable":"true","cfid":"cf[10002]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Flagged","displayName":"Flagged - Flagged","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Flagged[Checkboxes]\"","displayName":"Flagged - Flagged[Checkboxes]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"flagKey","displayName":"flagKey","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"flagName","displayName":"flagName","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"id","displayName":"id","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"cf[11012]","displayName":"Instance type - cf[11012]","auto":"true","orderable":"true","cfid":"cf[11012]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Instance type\"","displayName":"Instance type - Instance type","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Instance type[Dropdown]\"","displayName":"Instance type - Instance type[Dropdown]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"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":"issueBlocks","displayName":"issueBlocks","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Issue color\"","displayName":"Issue color - cf[11003]","orderable":"true","searchable":"true","cfid":"cf[11003]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"issueDuplicates","displayName":"issueDuplicates","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsBlockedBy","displayName":"issueIsBlockedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsDuplicatedBy","displayName":"issueIsDuplicatedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueIsRaisedBy","displayName":"issueIsRaisedBy","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueLink","displayName":"issueLink","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","is","is not"],"types":["com.atlassian.jira.issue.link.IssueLinkType"]},{"value":"issueRaised","displayName":"issueRaised","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueRelated","displayName":"issueRelated","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":"jsd-linked-incident-ids","displayName":"jsd-linked-incident-ids","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"jsm-system-incident-id","displayName":"jsm-system-incident-id","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"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":"linkedIssue","displayName":"linkedIssue","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"cf[10024]","displayName":"Observations - cf[10024]","orderable":"true","cfid":"cf[10024]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Observations","displayName":"Observations - Observations","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Observations[Paragraph]\"","displayName":"Observations - Observations[Paragraph]","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Organizations","displayName":"Organizations - cf[10800]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10800]","operators":["=","!=","not in","in"],"types":["com.atlassian.servicedesk.api.organization.CustomerOrganization"]},{"value":"originalEstimate","displayName":"originalEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"parent","displayName":"parent","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"parentEpic","displayName":"parentEpic","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Parent Link\"","displayName":"Parent Link - cf[10500]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10500]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"cf[11005]","displayName":"Participants - cf[11005]","auto":"true","orderable":"true","cfid":"cf[11005]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"Participants","displayName":"Participants - Participants","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"\"Participants[User Picker (multiple users)]\"","displayName":"Participants - Participants[User Picker (multiple users)]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["<","changed","was in","was not","was","in",">",">=","=","not in","is not","<=","is","was not in","!="],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"progress","displayName":"progress","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"project.property","displayName":"project.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.lang.Number","java.util.Date"]},{"value":"projectType","displayName":"projectType","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.project.type.ProjectTypeKey"]},{"value":"Rank","displayName":"Rank - cf[10100]","orderable":"true","searchable":"true","cfid":"cf[10100]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"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":["=","not in","changed","is not","was in","was not","is","was","was not in","!=","in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"reporter.property","displayName":"reporter.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.lang.Number","java.util.Date"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"request-channel-type","displayName":"request-channel-type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Request language\"","displayName":"Request language - cf[11010]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11010]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.servicedesk.internal.api.customfields.requestlanguage.RequestLanguage"]},{"value":"request-last-activity-time","displayName":"request-last-activity-time","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Request participants\"","displayName":"Request participants - cf[11001]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11001]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"\"Request Type\"","displayName":"Request Type - cf[10900]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10900]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.servicedesk.internal.api.origin.VpOrigin"]},{"value":"\"Requirement Yogi\"","displayName":"Requirement Yogi - cf[11022]","orderable":"true","searchable":"true","cfid":"cf[11022]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["<","changed","was in","was not","was","in",">",">=","=","not in","is not","<=","is","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":"Satisfaction","displayName":"Satisfaction - cf[11004]","orderable":"true","searchable":"true","cfid":"cf[11004]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Satisfaction date\"","displayName":"Satisfaction date - cf[11006]","orderable":"true","searchable":"true","cfid":"cf[11006]","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":"sd-kb-shared","displayName":"sd-kb-shared","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"searchrequest","displayName":"searchrequest","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"cf[10025]","displayName":"Severity - cf[10025]","auto":"true","orderable":"true","cfid":"cf[10025]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Severity","displayName":"Severity - Severity","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Severity[Dropdown]\"","displayName":"Severity - Severity[Dropdown]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Sprint","displayName":"Sprint - cf[10007]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10007]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"cf[11000]","displayName":"Start date - cf[11000]","orderable":"true","cfid":"cf[11000]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Start date\"","displayName":"Start date - Start date","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Start date[Date]\"","displayName":"Start date - Start date[Date]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["=","not in","changed","is not","was in","was not","is","was","was not in","!=","in"],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"statusCategoryChangedDate","displayName":"statusCategoryChangedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Story point estimate\"","displayName":"Story point estimate - cf[11002]","orderable":"true","searchable":"true","cfid":"cf[11002]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"cf[10004]","displayName":"Story Points - cf[10004]","orderable":"true","cfid":"cf[10004]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Story Points\"","displayName":"Story Points - Story Points","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Story Points[Number]\"","displayName":"Story Points - Story Points[Number]","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"subtasks","displayName":"subtasks","orderable":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"summary","displayName":"summary","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Target end\"","displayName":"Target end - cf[11015]","orderable":"true","searchable":"true","cfid":"cf[11015]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Target start\"","displayName":"Target start - cf[11014]","orderable":"true","searchable":"true","cfid":"cf[11014]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"cf[10700]","displayName":"Team - cf[10700]","auto":"true","orderable":"true","cfid":"cf[10700]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"Team","displayName":"Team - Team","auto":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"\"Team[Team]\"","displayName":"Team - Team[Team]","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"\"Ticket category\"","displayName":"Ticket category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.servicedesk.api.itsm.Practice"]},{"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":"\"Time to next response\"","displayName":"Time to next response - cf[11013]","orderable":"true","searchable":"true","cfid":"cf[11013]","operators":["=","!=","<","<=",">",">="],"types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"voter.property","displayName":"voter.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.lang.Number","java.util.Date"]},{"value":"votes","displayName":"votes","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watcher.property","displayName":"watcher.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.String","java.lang.Number","java.util.Date"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"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":"approved()","displayName":"approved()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"approver(\"\")","displayName":"approver(\"\")","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"breached()","displayName":"breached()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"cascadeOption(\"\")","displayName":"cascadeOption(\"\")","isList":"true","types":["com.atlassian.jira.issue.customfields.option.CascadingOption"]},{"value":"closedSprints()","displayName":"closedSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"completed()","displayName":"completed()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"componentsLeadByUser()","displayName":"componentsLeadByUser()","isList":"true","types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"currentLogin()","displayName":"currentLogin()","types":["java.util.Date"]},{"value":"earliestUnreleasedVersion()","displayName":"earliestUnreleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"elapsed(\"\")","displayName":"elapsed(\"\")","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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":"everBreached()","displayName":"everBreached()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"inactiveUsers()","displayName":"inactiveUsers()","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"iqlFunction(\"\")","displayName":"iqlFunction(\"\")","isList":"true","types":["com.atlassian.servicedesk.cmdb.model.CmdbObjectReference"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesWithRemoteLinksByGlobalId(\"\")","displayName":"issuesWithRemoteLinksByGlobalId(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"lastLogin()","displayName":"lastLogin()","types":["java.util.Date"]},{"value":"latestReleasedVersion()","displayName":"latestReleasedVersion()","types":["com.atlassian.jira.project.version.Version"]},{"value":"linkedIssues(\"\")","displayName":"linkedIssues(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"membersOf(\"\")","displayName":"membersOf(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"myApproval()","displayName":"myApproval()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"myPending()","displayName":"myPending()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"myPendingApproval()","displayName":"myPendingApproval()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"organizationMembers(\"\")","displayName":"organizationMembers(\"\")","isList":"true","types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"paused()","displayName":"paused()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"pending()","displayName":"pending()","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"pendingBy(\"\")","displayName":"pendingBy(\"\")","types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"projectsLeadByUser()","displayName":"projectsLeadByUser()","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasPermission(\"\")","displayName":"projectsWhereUserHasPermission(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"projectsWhereUserHasRole(\"\")","displayName":"projectsWhereUserHasRole(\"\")","isList":"true","types":["com.atlassian.jira.project.Project"]},{"value":"releasedVersions()","displayName":"releasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"remaining(\"\")","displayName":"remaining(\"\")","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"value":"running()","displayName":"running()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]},{"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":"subTaskIssueTypes()","displayName":"subTaskIssueTypes()","isList":"true","types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"unreleasedVersions()","displayName":"unreleasedVersions()","isList":"true","types":["com.atlassian.jira.project.version.Version"]},{"value":"updatedBy(\"\")","displayName":"updatedBy(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"votedIssues()","displayName":"votedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"watchedIssues()","displayName":"watchedIssues()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"withinCalendarHours()","displayName":"withinCalendarHours()","types":["com.atlassian.servicedesk.internal.sla.searcher.SlaDataTypes$SlaDataType"]}]
["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","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":"Assignee","id":"assignee","key":"navigator.filter.assignee","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Reporter","id":"reporter","key":"navigator.filter.reportedby","isShown":true,"isCollapsible":false,"isCollapsed":false}],"type":"PEOPLE","title":"People"},{"searchers":[{"name":"Project","id":"project","key":"common.concepts.project","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Type","id":"issuetype","key":"navigator.filter.issuetype","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Status","id":"status","key":"navigator.filter.status","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Priority","id":"priority","key":"navigator.filter.matchingpriorities","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Resolution","id":"resolution","key":"navigator.filter.matchingresolutions","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Creator","id":"creator","key":"navigator.filter.createdby","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Affects Version","id":"version","key":"common.filters.matchesversions","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Fix Version","id":"fixfor","key":"common.concepts.fixversion","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Component","id":"component","key":"common.filters.incomponents","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"% Limits","id":"workratio","key":"navigator.filter.workratio.limits","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Description","id":"description","key":"issue.field.description","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Comment","id":"comment","key":"navigator.filter.matchingcomments","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Label","id":"labels","key":"common.filters.labels","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Status Category","id":"statusCategory","key":"navigator.filter.statuscategory","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Query","id":"text","key":"common.words.query","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Parent","id":"parent","key":"issue.field.parent","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Ticket category","id":"ticketCategory","key":"jsd.basic.jql.ticketcategory.field.name","isShown":false,"isCollapsible":false,"isCollapsed":false}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"navigator.filter.created","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Updated Date","id":"updated","key":"navigator.filter.updated","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Resolution Date","id":"resolutiondate","key":"navigator.filter.resolutiondate","isShown":true,"isCollapsible":false,"isCollapsed":false},{"name":"Due Date","id":"duedate","key":"navigator.filter.duedate","isShown":false,"isCollapsible":false,"isCollapsed":false},{"name":"Status Category Changed Date","id":"statuscategorychangedate","key":"navigator.filter.statuscategory.changed.date","isShown":true,"isCollapsible":false,"isCollapsed":false}],"type":"DATES","title":"Dates"}]},"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 \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=10403&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 \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=10407&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_6\"\n title=\"Epic\"\n value=\"6\">Epic</option>\n \n <option class=\" imagebacked \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=10411&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 \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=10415&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_7\"\n title=\"Story\"\n value=\"7\">Story</option>\n \n <option class=\" imagebacked \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=10501&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_10000\"\n title=\"Suggestion / Idea\"\n value=\"10000\">Suggestion / Idea</option>\n \n <option class=\" imagebacked \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=10418&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 \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=10416&avatarType=issuetype\"\n data-fallback-icon=\"/images/icons/issuetypes/blank.png\"\n id=\"type_5\"\n title=\"Sub-task\"\n value=\"5\">Sub-task</option>\n </optgroup>\n </select>\n </div>\n ","validSearcher":true,"isShown":true},"project":{"name":"Project","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldpid\">Project:</label><span id=\"fieldpid\" class=\"fieldValue\">\n \n <a href=\"/browse/PLAYSQL\" title=\"Browse Play SQL project\">Play SQL</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=\"4\">\n <optgroup label=\"All projects\">\n \n <option data-icon=\"/secure/projectavatar?pid=10000&size=small\"\n selected=\"selected\" title=\"Play SQL\"\n value=\"10000\">\n Play SQL (PLAYSQL)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10301&size=small\"\n title=\"Play SQL Cloud\"\n value=\"10301\">\n Play SQL Cloud (PCLOUD)\n </option>\n \n <option data-icon=\"/secure/projectavatar?pid=10200&size=small\"\n title=\"Requirement Yogi\"\n value=\"10200\">\n Requirement Yogi (RY)\n </option>\n </optgroup>\n </select>\n </div>\n \n","jql":"project = PLAYSQL","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://avatar-management.services.atlassian.com/default/16\n\" 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/closed.png\" value=\"10003\" title=\"Closed\" data-simple-status=\"{"id":"10003","name":"Closed","description":"","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/information.png\" value=\"10006\" title=\"In Review\" data-simple-status=\"{"id":"10006","name":"In Review","description":"","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/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/generic.png\" value=\"10105\" title=\"Not in planning\" data-simple-status=\"{"id":"10105","name":"Not in planning","description":"","iconUrl":"/images/icons/statuses/generic.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Not in planning</option>\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/information.png\" value=\"10004\" title=\"Ready for Release\" data-simple-status=\"{"id":"10004","name":"Ready for Release","description":"","iconUrl":"/images/icons/statuses/information.png","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Ready for Release</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,"favourite":false},{"id":-2,"name":"Reported by me","jql":"reporter = currentUser() order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true,"favourite":false},{"id":-4,"name":"All issues","jql":"order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-5,"name":"Open issues","jql":"resolution = Unresolved order by priority DESC,updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-9,"name":"Done issues","jql":"statusCategory = Done order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-3,"name":"Viewed recently","jql":"issuekey in issueHistory() order by lastViewed DESC","isSystem":true,"sharePermissions":[],"requiresLogin":true,"favourite":false},{"id":-6,"name":"Created recently","jql":"created >= -1w order by created DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-7,"name":"Resolved recently","jql":"resolutiondate >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false},{"id":-8,"name":"Updated recently","jql":"updated >= -1w order by updated DESC","isSystem":true,"sharePermissions":[],"requiresLogin":false,"favourite":false}]