PFS-JIRA

  • Dashboards
  • Projects
  • Issues
  • Dependency Map
    Recent Maps
    • (User not logged in)
    • Clear Recent Maps
    • Manage Maps
  • Give feedback to Atlassian
  • Help
    • Jira Core help
    • Keyboard Shortcuts
    • About Jira
    • Jira Credits
  • Log In

Export - CSV (All fields)

Export - CSV (Current fields)

Comma (,) Semicolon (;) Vertical bar (|) Caret (^)

  1. Task INSTRM-1009
    Add camera_name and module_name columns to sps_camera table.
  2. Task INSTRM-851
    Re-process Oct 18 engineering run for database.
  3. Task INSTRM-2205
    Set up test databases to support reprocessing existing MCS (and other) data
  4. Task INSTRM-2116
    add pfs_config_fiber.fiber_status column
  5. Task INSTRM-2100
    Remove unnecessary tables from opDB
  6. Task INSTRM-2041
    Please add guide_delta_scale to the agc_guide_offset
  7. Task INSTRM-2039
    Add some indexes for common cobra/mcs/ag/target joins
  8. Task INSTRM-2015
    Change the foreign key constraint of `cobra_move` and `cobra_match`
  9. Task INSTRM-1984
    Creating a field for trace convergence tolerance in pfs_config table
  10. Task INSTRM-1276
    Update mcsActor with fibreID routine and database interation
  11. Task INSTRM-1275
    Fix `cobra_match` so that `spot_id` can be `NULL`
  12. Task INSTRM-1240
    Add a table for the cordinate transformation between MCS and PFI
  13. Story INSTRM-1171
    Read-only access to summit opDB
  14. Task INSTRM-1145
    Replication test for opDB using two test nodes in Hilo
  15. Task INSTRM-1144
    Add new tables for obslog in the opDB schema
  16. Task INSTRM-1143
    Add a tool to ingest data from pfsDesign file to opDB
  17. Task INSTRM-1110
    Factor out telescope and environmental conditions into new table(s)
  18. Task INSTRM-1096
    Add {{pfs_visit.pfs_design_id}} column
  19. Task INSTRM-1085
    Flagging detected objects on AG camera through additional glass plate in front of the sensor
  20. Task INSTRM-1063
    Add timestamp in `pfs_visit` table
  21. Task INSTRM-1786
    add variant / pfsDesignId0 column to pfsDesign/pfsConfig opdb table
  22. Task INSTRM-1762
    current agc_exposure table does not match defined constraints.
  23. Task INSTRM-1731
    create sequence_group table in opdb
  24. Task INSTRM-1703
    Add columns to tel_status for accumulated dither offsets.
  25. Task INSTRM-1646
    add flags column to mcs_data
  26. Story INSTRM-1577
    Verify the mechanism to store pfsDesing/pfsConfig information to opDB
  27. Task INSTRM-1497
    check `update` method of opdb library
  28. Task INSTRM-1476
    Move database writing outside of thread
  29. Task INSTRM-2355
    Update opdb.insert_kw to be SQLAlchemy 1.4/2.0-compatible.
  30. Task INSTRM-2343
    Remove Opdb.reset() method
  31. Task INSTRM-2342
    Remove reset method in opdb library
  32. Task INSTRM-2276
    mask column of fiducial_fiber table is all "None"
  33. Task INSTRM-2260
    Add {{mcs_boresight}} join column in {{mcs_exposure}}
  34. Task INSTRM-2252
    Redirect agcc output tables to foreign server
  35. Task INSTRM-1456
    Add a table for the guide offset
  36. Task INSTRM-1448
    Add table for fiducial fibre matches
  37. Task INSTRM-1437
    Add `design_name` in `pfs_design` table
  38. Task INSTRM-1406
    Provide the measurement algorithm used for MCS spots in the opDB
  39. Task INSTRM-1405
    Provide the measurement algorithm used for AG spots
  40. Task INSTRM-1403
    Add table to relate matched guidestar with spot
  41. Task INSTRM-1394
    Update PFI-MCS transformation tables on opDB
  42. Task INSTRM-1367
    obslog: global search on header keyword
  43. Task INSTRM-1352
    Some fix and cleanups of `pfsDesign` and `pfsConfig` table
  44. Task INSTRM-1348
    Ingest pfsDesign/pfsConfig files to opDB
  45. Task INSTRM-1334
    Add efficient DataFrame <--> opdb methods
  46. Task INSTRM-1321
    Allow the spt_operational_database setup.py to install a directory for ICS
  47. Task INSTRM-1311
    Add a table of distortion parameters for sanity check
  48. Task INSTRM-1305
    rename sps_sequence to iic_sequence in opdb
  49. Task INSTRM-1302
    Define tables outside opDB
  50. Task INSTRM-1298
    Add select_copy_to method
  51. Task INSTRM-1293
    pull out status column from sps_sequence table
  52. Task INSTRM-1008
    Design and create operational database tables for A&G camera exposures
  53. Task INSTRM-991
    Provide functional requirement and use cases of the opDB standard library from the viewpoint of ETS
  54. Task INSTRM-979
    Make a proposal of the standard library to access opDB
  55. Task INSTRM-978
    Provide functional requirement and use cases of the opDB standard library from the viewpoint of DRP (and more general aspects)
  56. Task INSTRM-977
    Provide functional requirement and use cases of the opDB standard library from the general viewpoint of ICS
  57. Task INSTRM-976
    Provide functional requirement and use cases of the opDB standard library from the viewpoint of SpS actors
  58. Task INSTRM-975
    Provide functional requirement and use cases of the opDB standard library from the viewpoint of MCS/PFI actors
  59. Task INSTRM-1881
    add target_ra and target_dec to pfs_config_fiber table
  60. Task INSTRM-1853
    add pfi_nominal_final.. to pfs_config_fiber table
  61. Story INSTRM-764
    Reconsider FiberPosition, CobraPosition, and FiducialFiberPosition tables
  62. Story INSTRM-763
    Changes to schema for CobraConfig and mcsData
  63. Story INSTRM-762
    Reconsider unique columns in e.g. mcsData
  64. Story INSTRM-761
    Remove the diff columns from CobraConfig
  65. Task INSTRM-751
    Update mcsexposure schema with all telescope info required for analysis
  66. Task INSTRM-749
    Convert opdb table and column names from camelCase to under_lines.
  67. Task INSTRM-739
    Making unified column name in DB
  68. Task INSTRM-735
    Establish a library for database interaction.
  69. Task INSTRM-732
    Normalize PFI configuration opdb tables ?
  70. Task INSTRM-730
    Add index on mcsData's frameId column
  71. Task INSTRM-941
    Create mechanism to manage the opDB update
  72. Task INSTRM-909
    Change opDB according to LAM's proposal for AIT and operation of SpS on the mountain
  73. Task INSTRM-905
    Update opDB schema for PFI works at ASRD
  74. Task INSTRM-904
    Rename `fiber_id` to `cobra_id` in opDB
  75. Task INSTRM-903
    Reconsider `fiducial_fiber_position` in opDB
  76. Task INSTRM-902
    Reconsider `cobra_geometry` in opDB
  77. Task INSTRM-901
    Establish a mechanism to save the convergence test results in opDB
  78. Task INSTRM-900
    Establish a mechanism to save the motor map in opDB
  79. Story INSTRM-852
    Reprocess Aug 2019 engineering run
  80. Task INSTRM-850
    Determine if we want to include centroiding information in database
  81. Story INSTRM-844
    Additional updates to operational schema
  82. Story INSTRM-843
    Update operational database schema
  83. Story INSTRM-815
    Provide additional opDB columns from FITS headers
  84. Story INSTRM-802
    Add tables for SPS AIT to the Subaru opdb
  85. Task INSTRM-2347
    Add photometry to MCS
  86. Task INSTRM-2457
    Add m2_off3 column to tel_status
  87. Task INSTRM-2481
    Add a new table for acquisition quality
  88. Task INSTRM-2480
    Add columns about convergence results in pfs_config table of opDB
  89. Task INSTRM-1323
    Use context managers ("with") as much as possible in db code.
  90. Task INSTRM-1229
    Sort out current `cobra_status` & `cobra_movement`
  91. Task INSTRM-1309
    Update columns of `cobra` table to match to the grandfibermap doc
  92. Task INSTRM-1308
    Additional columns in `fiducial_fiber_geometry`
  93. Bug INSTRM-1098
    insert failure at LAM opdb
Refresh results
[{"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}]
  • Atlassian Jira Project Management Software (v8.3.4#803005-sha1:1f96e09)
  • About Jira
  • Report a problem
  • Powered by a free Atlassian Jira open source license for Kavli IPMU, Univ of Tokyo. Try Jira - bug tracking software for your team.
Atlassian