Export - CSV (All fields)
Export - CSV (Current fields)
INSTRM-1009
Add camera_name and module_name columns to sps_camera table.INSTRM-851
Re-process Oct 18 engineering run for database.INSTRM-2205
Set up test databases to support reprocessing existing MCS (and other) dataINSTRM-2116
add pfs_config_fiber.fiber_status columnINSTRM-2100
Remove unnecessary tables from opDBINSTRM-2041
Please add guide_delta_scale to the agc_guide_offsetINSTRM-2039
Add some indexes for common cobra/mcs/ag/target joinsINSTRM-2015
Change the foreign key constraint of `cobra_move` and `cobra_match`INSTRM-1984
Creating a field for trace convergence tolerance in pfs_config tableINSTRM-1276
Update mcsActor with fibreID routine and database interationINSTRM-1275
Fix `cobra_match` so that `spot_id` can be `NULL`INSTRM-1240
Add a table for the cordinate transformation between MCS and PFIINSTRM-1171
Read-only access to summit opDBINSTRM-1145
Replication test for opDB using two test nodes in HiloINSTRM-1144
Add new tables for obslog in the opDB schemaINSTRM-1143
Add a tool to ingest data from pfsDesign file to opDBINSTRM-1110
Factor out telescope and environmental conditions into new table(s)INSTRM-1096
Add {{pfs_visit.pfs_design_id}} columnINSTRM-1085
Flagging detected objects on AG camera through additional glass plate in front of the sensorINSTRM-1063
Add timestamp in `pfs_visit` tableINSTRM-1786
add variant / pfsDesignId0 column to pfsDesign/pfsConfig opdb tableINSTRM-1762
current agc_exposure table does not match defined constraints.INSTRM-1731
create sequence_group table in opdbINSTRM-1703
Add columns to tel_status for accumulated dither offsets.INSTRM-1646
add flags column to mcs_dataINSTRM-1577
Verify the mechanism to store pfsDesing/pfsConfig information to opDBINSTRM-1497
check `update` method of opdb libraryINSTRM-1476
Move database writing outside of threadINSTRM-2355
Update opdb.insert_kw to be SQLAlchemy 1.4/2.0-compatible.INSTRM-2343
Remove Opdb.reset() methodINSTRM-2342
Remove reset method in opdb libraryINSTRM-2276
mask column of fiducial_fiber table is all "None"INSTRM-2260
Add {{mcs_boresight}} join column in {{mcs_exposure}}INSTRM-2252
Redirect agcc output tables to foreign serverINSTRM-1456
Add a table for the guide offsetINSTRM-1448
Add table for fiducial fibre matchesINSTRM-1437
Add `design_name` in `pfs_design` tableINSTRM-1406
Provide the measurement algorithm used for MCS spots in the opDBINSTRM-1405
Provide the measurement algorithm used for AG spotsINSTRM-1403
Add table to relate matched guidestar with spotINSTRM-1394
Update PFI-MCS transformation tables on opDBINSTRM-1367
obslog: global search on header keywordINSTRM-1352
Some fix and cleanups of `pfsDesign` and `pfsConfig` tableINSTRM-1348
Ingest pfsDesign/pfsConfig files to opDBINSTRM-1334
Add efficient DataFrame <--> opdb methodsINSTRM-1323
Use context managers ("with") as much as possible in db code.INSTRM-1321
Allow the spt_operational_database setup.py to install a directory for ICSINSTRM-1311
Add a table of distortion parameters for sanity checkINSTRM-1305
rename sps_sequence to iic_sequence in opdbINSTRM-1302
Define tables outside opDBINSTRM-1298
Add select_copy_to methodINSTRM-1293
pull out status column from sps_sequence tableINSTRM-1008
Design and create operational database tables for A&G camera exposuresINSTRM-991
Provide functional requirement and use cases of the opDB standard library from the viewpoint of ETSINSTRM-979
Make a proposal of the standard library to access opDBINSTRM-978
Provide functional requirement and use cases of the opDB standard library from the viewpoint of DRP (and more general aspects)INSTRM-977
Provide functional requirement and use cases of the opDB standard library from the general viewpoint of ICSINSTRM-976
Provide functional requirement and use cases of the opDB standard library from the viewpoint of SpS actorsINSTRM-975
Provide functional requirement and use cases of the opDB standard library from the viewpoint of MCS/PFI actorsINSTRM-1881
add target_ra and target_dec to pfs_config_fiber tableINSTRM-1853
add pfi_nominal_final.. to pfs_config_fiber tableINSTRM-764
Reconsider FiberPosition, CobraPosition, and FiducialFiberPosition tablesINSTRM-763
Changes to schema for CobraConfig and mcsDataINSTRM-762
Reconsider unique columns in e.g. mcsDataINSTRM-761
Remove the diff columns from CobraConfigINSTRM-751
Update mcsexposure schema with all telescope info required for analysisINSTRM-749
Convert opdb table and column names from camelCase to under_lines.INSTRM-739
Making unified column name in DBINSTRM-735
Establish a library for database interaction.INSTRM-732
Normalize PFI configuration opdb tables ?INSTRM-730
Add index on mcsData's frameId columnINSTRM-941
Create mechanism to manage the opDB updateINSTRM-909
Change opDB according to LAM's proposal for AIT and operation of SpS on the mountainINSTRM-905
Update opDB schema for PFI works at ASRDINSTRM-904
Rename `fiber_id` to `cobra_id` in opDBINSTRM-903
Reconsider `fiducial_fiber_position` in opDBINSTRM-902
Reconsider `cobra_geometry` in opDBINSTRM-901
Establish a mechanism to save the convergence test results in opDBINSTRM-900
Establish a mechanism to save the motor map in opDBINSTRM-852
Reprocess Aug 2019 engineering runINSTRM-850
Determine if we want to include centroiding information in databaseINSTRM-844
Additional updates to operational schemaINSTRM-843
Update operational database schemaINSTRM-815
Provide additional opDB columns from FITS headersINSTRM-802
Add tables for SPS AIT to the Subaru opdbINSTRM-2347
Add photometry to MCSINSTRM-2457
Add m2_off3 column to tel_statusINSTRM-2480
Add columns about convergence results in pfs_config table of opDBINSTRM-2481
Add a new table for acquisition qualityINSTRM-1229
Sort out current `cobra_status` & `cobra_movement`INSTRM-1309
Update columns of `cobra` table to match to the grandfibermap docINSTRM-1308
Additional columns in `fiducial_fiber_geometry`INSTRM-1098
insert failure at LAM opdb
[{"value":"affectedVersion","displayName":"affectedVersion","auto":"true","orderable":"true","searchable":"true","operators":["~","!~","=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["is not","=","was not in","changed","in","is","was in","!=","was","was not","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"attachments","displayName":"attachments","searchable":"true","operators":["is","is not"],"types":["com.atlassian.jira.issue.attachment.Attachment"]},{"value":"\"Business Value\"","displayName":"Business Value - cf[10003]","orderable":"true","searchable":"true","cfid":"cf[10003]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"category","displayName":"category","auto":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.ProjectCategory"]},{"value":"comment","displayName":"comment","searchable":"true","operators":["~","!~"],"types":["java.lang.String"]},{"value":"component","displayName":"component","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.bc.project.component.ProjectComponent"]},{"value":"created","displayName":"created","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"createdDate","displayName":"createdDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"creator","displayName":"creator","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"description","displayName":"description","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Development","displayName":"Development - cf[10500]","orderable":"true","searchable":"true","cfid":"cf[10500]","operators":[">",">=","=","<","<=","in","!~","not in","is","is not"],"types":["java.lang.Number","java.lang.String"]},{"value":"due","displayName":"due","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"duedate","displayName":"duedate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"environment","displayName":"environment","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic/Theme\"","displayName":"Epic/Theme - cf[10001]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10001]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Color\"","displayName":"Epic Color - cf[10009]","orderable":"true","searchable":"true","cfid":"cf[10009]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10006]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10006]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"Epic Name\"","displayName":"Epic Name - cf[10007]","orderable":"true","searchable":"true","cfid":"cf[10007]","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10008]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10008]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"filter","displayName":"filter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":["is not","=",">","is","was in","!=","<=","not in","~","was not in","changed","<","in","was","was not",">=","!~"],"types":["com.atlassian.jira.project.version.Version"]},{"value":"Flagged","displayName":"Flagged - cf[10000]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10000]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"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.util.Date","java.lang.String","java.lang.Number"]},{"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":"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[10604]","orderable":"true","searchable":"true","cfid":"cf[10604]","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[10601]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10601]","operators":["=","in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["is not","=",">","is","was in","!=","<=","not in","was not in","changed","<","in","was","was not",">="],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"progress","displayName":"progress","orderable":"true","operators":[],"types":["java.lang.Object"]},{"value":"project","displayName":"project","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.project.Project"]},{"value":"Rank","displayName":"Rank - cf[10010]","orderable":"true","searchable":"true","cfid":"cf[10010]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"\"Redmine ID\"","displayName":"Redmine ID - cf[10800]","orderable":"true","searchable":"true","cfid":"cf[10800]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Release Version History\"","displayName":"Release Version History - cf[10200]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10200]","operators":["~","!~","=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"remainingEstimate","displayName":"remainingEstimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["is not","=","was not in","changed","in","is","was in","!=","was","was not","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"request","displayName":"request","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["is not","=",">","is","was in","!=","<=","not in","was not in","changed","<","in","was","was not",">="],"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":"Reviewers","displayName":"Reviewers - cf[10100]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10100]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"searchrequest","displayName":"searchrequest","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"Sprint","displayName":"Sprint - cf[10005]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10005]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["is not","=","was not in","changed","in","is","was in","!=","was","was not","not in"],"types":["com.atlassian.jira.issue.status.Status"]},{"value":"statusCategory","displayName":"statusCategory","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.status.category.StatusCategory"]},{"value":"\"Story Points\"","displayName":"Story Points - cf[10002]","orderable":"true","searchable":"true","cfid":"cf[10002]","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[10603]","orderable":"true","searchable":"true","cfid":"cf[10603]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"Target start\"","displayName":"Target start - cf[10602]","orderable":"true","searchable":"true","cfid":"cf[10602]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"Team","displayName":"Team - cf[10600]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10600]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"timeestimate","displayName":"timeestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timeoriginalestimate","displayName":"timeoriginalestimate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"timespent","displayName":"timespent","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.types.Duration"]},{"value":"type","displayName":"type","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.issuetype.IssueType"]},{"value":"updated","displayName":"updated","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"updatedDate","displayName":"updatedDate","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"voter","displayName":"voter","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"votes","displayName":"votes","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"watcher","displayName":"watcher","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"worklogAuthor","displayName":"worklogAuthor","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"worklogComment","displayName":"worklogComment","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"worklogDate","displayName":"worklogDate","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.util.Date"]},{"value":"workratio","displayName":"workratio","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]}]
[{"value":"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":"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":"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":"futureSprints()","displayName":"futureSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"issueHistory()","displayName":"issueHistory()","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesInPlan(\"\")","displayName":"issuesInPlan(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"issuesInProgram(\"\")","displayName":"issuesInProgram(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"value":"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":"now()","displayName":"now()","types":["java.util.Date"]},{"value":"openSprints()","displayName":"openSprints()","isList":"true","types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"parentIssuesOf(\"\")","displayName":"parentIssuesOf(\"\")","isList":"true","types":["com.atlassian.jira.issue.Issue"]},{"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":"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"]}]
["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"]
{"errorMessages":["jqlTooComplex"],"errors":{}}
[{"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}]