OLSECMS-41
Create module to generate correspond letters based on provide templates.
Implement file storage using OneDrive
OLSE update request
Discuss possible long term solution for email templates
Create mockup of Dashboard
Fix calculation of payment summary
Make OLSE project/board visible for OLSE members
Hide HRA in future forms
Edit user pages
Remove "Wages Recovered Other Agencies" with in Payment Summary Tab
Upload HCSO Data onto Drupal
HCSO - Quality Assurrance TESTING and DEBUGGING
Change all Currency format
Do NOT load payments with 0 "zero" amount
ACTIVITY SHEET TAB - Add feature to Upload docs during Data entry for an activity
Fix saving of correspondence to google drive
Payment Changes - Additional Fields
Create Grand total section for Payment Tracking
activity sheet search
Updated HCSO Templates
Add function to import data entered on google spreadsheet to Drupal
[{"value":"\"[CHART] Date of First Response\"","displayName":"[CHART] Date of First Response - cf[10002]","orderable":"true","searchable":"true","cfid":"cf[10002]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"\"[CHART] Time in Status\"","displayName":"[CHART] Time in Status - cf[10000]","orderable":"true","searchable":"true","cfid":"cf[10000]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Acceptance Criteria\"","displayName":"Acceptance Criteria - cf[11900]","orderable":"true","searchable":"true","cfid":"cf[11900]","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":"\"AirTable Action Items\"","displayName":"AirTable Action Items - cf[12041]","orderable":"true","searchable":"true","cfid":"cf[12041]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"AirTable Assignee\"","displayName":"AirTable Assignee - cf[12036]","orderable":"true","searchable":"true","cfid":"cf[12036]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"AirTable Attachment\"","displayName":"AirTable Attachment - cf[12039]","orderable":"true","searchable":"true","cfid":"cf[12039]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"AirTable Category\"","displayName":"AirTable Category - cf[12042]","orderable":"true","searchable":"true","cfid":"cf[12042]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"AirTable Epic Name\"","displayName":"AirTable Epic Name - cf[12034]","orderable":"true","searchable":"true","cfid":"cf[12034]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"AirTable Notes\"","displayName":"AirTable Notes - cf[12020]","orderable":"true","searchable":"true","cfid":"cf[12020]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"AirTable Number\"","displayName":"AirTable Number - cf[12033]","orderable":"true","searchable":"true","cfid":"cf[12033]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"AirTable Sprint\"","displayName":"AirTable Sprint - cf[12043]","orderable":"true","searchable":"true","cfid":"cf[12043]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"AirTable Status\"","displayName":"AirTable Status - cf[12035]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12035]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Approvals","displayName":"Approvals - cf[11230]","orderable":"true","searchable":"true","cfid":"cf[11230]","operators":["="],"types":["com.atlassian.servicedesk.plugins.approvals.internal.searcher.ApprovalsDataTypes$ApprovalDataType"]},{"value":"assignee","displayName":"assignee","auto":"true","orderable":"true","searchable":"true","operators":["was not","is","was not in","!=","=","in","was in","was","not in","is not","changed"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"assignee.property","displayName":"assignee.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.Number","java.lang.String","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 Unit\"","displayName":"Business Unit - cf[11801]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11801]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Business Value\"","displayName":"Business Value - cf[10014]","orderable":"true","searchable":"true","cfid":"cf[10014]","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":"cf[12013]","displayName":"Category - cf[12013]","orderable":"true","searchable":"true","operators":["~","!~","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.Number","java.lang.String","java.util.Date"]},{"value":"Criticaility","displayName":"Criticaility - cf[11130]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11130]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Department","displayName":"Department - cf[12055]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12055]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"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[11430]","orderable":"true","searchable":"true","cfid":"cf[11430]","operators":["<","<=",">",">="],"types":["java.lang.Number"]},{"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[10011]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10011]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"\"Epic Colour\"","displayName":"Epic Colour - cf[10733]","orderable":"true","searchable":"true","cfid":"cf[10733]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Link\"","displayName":"Epic Link - cf[10730]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10730]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"cf[10731]","displayName":"Epic Name - cf[10731]","orderable":"true","searchable":"true","operators":["~","!~","=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"cf[12021]","displayName":"Epic Name - cf[12021]","orderable":"true","searchable":"true","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"\"Epic Status\"","displayName":"Epic Status - cf[10732]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10732]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Feature template\"","displayName":"Feature template - cf[12053]","orderable":"true","searchable":"true","cfid":"cf[12053]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"filter","displayName":"filter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"fixVersion","displayName":"fixVersion","auto":"true","orderable":"true","searchable":"true","operators":["was not in","!=",">=","=","in",">","was in","is not","changed","<=","was 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":"Flagged","displayName":"Flagged - 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":"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":"issue","displayName":"issue","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issue.property","displayName":"issue.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.Number","java.lang.String","java.util.Date"]},{"value":"\"Issue Cluster\"","displayName":"Issue Cluster - cf[11800]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11800]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"Issue color\"","displayName":"Issue color - cf[12011]","orderable":"true","searchable":"true","cfid":"cf[12011]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"issuekey","displayName":"issuekey","orderable":"true","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">="],"types":["com.atlassian.jira.issue.Issue"]},{"value":"issueLink","displayName":"issueLink","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":"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":"linkedIssue","displayName":"linkedIssue","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"\"OOC Priority\"","displayName":"OOC Priority - cf[12038]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12038]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Organizations","displayName":"Organizations - cf[11600]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11600]","operators":["=","!=","not in","in"],"types":["com.atlassian.servicedesk.api.organization.CustomerOrganization"]},{"value":"parent","displayName":"parent","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[11330]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11330]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.Issue"]},{"value":"Permit","displayName":"Permit - cf[12004]","orderable":"true","searchable":"true","cfid":"cf[12004]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"value":"Phase","displayName":"Phase - cf[12002]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12002]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"\"postmortem status\"","displayName":"postmortem status","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.String"]},{"value":"priority","displayName":"priority","auto":"true","orderable":"true","searchable":"true","operators":["was not in","!=",">=","=","in",">","was in","is not","changed","<=","was not","is","<","was","not in"],"types":["com.atlassian.jira.issue.priority.Priority"]},{"value":"\"Priority #\"","displayName":"Priority # - cf[12005]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12005]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"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.Number","java.lang.String","java.util.Date"]},{"value":"cf[12003]","displayName":"Project - cf[12003]","auto":"true","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Rank","displayName":"Rank - cf[10830]","orderable":"true","searchable":"true","cfid":"cf[10830]","operators":["=","!=","in","not in","<","<=",">",">="],"types":["java.lang.String"]},{"value":"\"Release Version History\"","displayName":"Release Version History - cf[10020]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10020]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["com.atlassian.jira.project.version.Version"]},{"value":"reporter","displayName":"reporter","auto":"true","orderable":"true","searchable":"true","operators":["was not","is","was not in","!=","=","in","was in","was","not in","is not","changed"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"reporter.property","displayName":"reporter.property","searchable":"true","operators":["=","!=","in","not in","<","<=",">",">=","~","!~","is","is not"],"types":["java.lang.Number","java.lang.String","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-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[12008]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12008]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.user.ApplicationUser"]},{"value":"\"Request Type\"","displayName":"Request Type - cf[12007]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12007]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.servicedesk.internal.customfields.origin.VpOrigin"]},{"value":"Requirement","displayName":"Requirement - cf[11802]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11802]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.label.Label"]},{"value":"resolution","displayName":"resolution","auto":"true","orderable":"true","searchable":"true","operators":["was not in","!=",">=","=","in",">","was in","is not","changed","<=","was 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[12049]","orderable":"true","searchable":"true","cfid":"cf[12049]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"savedfilter","displayName":"savedfilter","auto":"true","searchable":"true","operators":["=","!=","in","not in"],"types":["com.atlassian.jira.issue.search.SearchRequest"]},{"value":"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":"Sprint","displayName":"Sprint - cf[10430]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[10430]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.greenhopper.service.sprint.Sprint"]},{"value":"\"Start date\"","displayName":"Start date - cf[12006]","orderable":"true","searchable":"true","cfid":"cf[12006]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.util.Date"]},{"value":"status","displayName":"status","auto":"true","orderable":"true","searchable":"true","operators":["was not","is","was not in","!=","=","in","was in","was","not in","is not","changed"],"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[12010]","orderable":"true","searchable":"true","cfid":"cf[12010]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Story Point Estimator\"","displayName":"Story Point Estimator - cf[12009]","orderable":"true","searchable":"true","cfid":"cf[12009]","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Story Points\"","displayName":"Story Points - cf[10013]","orderable":"true","searchable":"true","cfid":"cf[10013]","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":"\"Supported Launch\"","displayName":"Supported Launch - cf[12040]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12040]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Team","displayName":"Team - cf[11500]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[11500]","operators":["=","!=","in","not in","is","is not"],"types":["java.lang.Number"]},{"value":"text","displayName":"text","searchable":"true","operators":["~"],"types":["java.lang.String"]},{"value":"Timeline","displayName":"Timeline - cf[12012]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12012]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"value":"Title","displayName":"Title - cf[12019]","orderable":"true","searchable":"true","cfid":"cf[12019]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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":"\"UAT Status\"","displayName":"UAT Status - cf[12001]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12001]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]},{"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":"\"User Story\"","displayName":"User Story - cf[12032]","orderable":"true","searchable":"true","cfid":"cf[12032]","operators":["~","!~","is","is not"],"types":["java.lang.String"]},{"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.Number","java.lang.String","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.Number","java.lang.String","java.util.Date"]},{"value":"watchers","displayName":"watchers","orderable":"true","searchable":"true","operators":["=","!=","in","not in","is","is not","<","<=",">",">="],"types":["java.lang.Number"]},{"value":"\"Who's Queue\"","displayName":"Who's Queue - cf[12022]","auto":"true","orderable":"true","searchable":"true","cfid":"cf[12022]","operators":["=","!=","in","not in","is","is not"],"types":["com.atlassian.jira.issue.customfields.option.Option"]}]
[{"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":"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":"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":"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":"Project","id":"project","key":"issue.field.project","isShown":true},{"name":"Summary","id":"summary","key":"issue.field.summary","isShown":true},{"name":"Type","id":"issuetype","key":"issue.field.issuetype","isShown":true},{"name":"Status","id":"status","key":"issue.field.status","isShown":true},{"name":"Priority","id":"priority","key":"issue.field.priority","isShown":true},{"name":"Resolution","id":"resolution","key":"issue.field.resolution","isShown":true},{"name":"Creator","id":"creator","key":"issue.field.creator","isShown":true},{"name":"Affects Version","id":"version","key":"issue.field.affectsversions","isShown":false},{"name":"Fix Version","id":"fixfor","key":"issue.field.fixversions","isShown":false},{"name":"Component","id":"component","key":"issue.field.components","isShown":false},{"name":"% Limits","id":"workratio","key":"issue.field.workratio","isShown":true},{"name":"Environment","id":"environment","key":"issue.field.environment","isShown":true},{"name":"Description","id":"description","key":"issue.field.description","isShown":true},{"name":"Comment","id":"comment","key":"issue.field.comment","isShown":true},{"name":"Label","id":"labels","key":"issue.field.labels","isShown":true},{"name":"Status Category","id":"statusCategory","key":"text","isShown":true},{"name":"Query","id":"text","key":"text","isShown":true}],"type":"DETAILS","title":"Details"},{"searchers":[{"name":"Created Date","id":"created","key":"issue.field.created","isShown":true},{"name":"Updated Date","id":"updated","key":"issue.field.updated","isShown":true},{"name":"Resolution Date","id":"resolutiondate","key":"issue.field.resolution.date","isShown":true},{"name":"Due Date","id":"duedate","key":"issue.field.duedate","isShown":true},{"name":"Status Category Changed Date","id":"statuscategorychangedate","key":"issue.field.status.category.change.date","isShown":true}],"type":"DATES","title":"Dates"},{"searchers":[{"name":"Assignee","id":"assignee","key":"issue.field.assignee","isShown":true},{"name":"Reporter","id":"reporter","key":"issue.field.reporter","isShown":true}],"type":"PEOPLE","title":"People"}]},"values":{"issuetype":{"name":"Type","editHtml":"\n\n\n\n <div class=\"field-group aui-field-issuetype\" >\n <label for=\"searcher-type\">Type</label>\n <select class=\"select js-default-checkboxmultiselect\" id=\"searcher-type\" multiple=\"multiple\" name=\"type\"\n data-placeholder-text=\"Find Issue Types...\" size=\"5\">\n <optgroup>\n \n <option class=\" \"\n id=\"type_-2\"\n title=\"All Standard Issue Types\"\n value=\"-2\">All Standard Issue Types</option>\n \n <option class=\" \"\n id=\"type_-3\"\n title=\"All Sub-Task Issue Types\"\n value=\"-3\">All Sub-Task Issue Types</option>\n </optgroup>\n\n <optgroup label=\"Standard Issue Types\">\n \n <option class=\" imagebacked \"\n data-icon=\"/secure/viewavatar?size=medium&avatarId=11208&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=11206&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","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=\"2\">\n <optgroup label=\"All projects\">\n \n <option data-icon=\"/secure/projectavatar?pid=11091&size=small\"\n title=\"OLSE Case Management System\"\n value=\"11091\">\n OLSE Case Management System (OLSECMS)\n </option>\n </optgroup>\n </select>\n </div>\n \n","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-cdn.atlassian.com/default\" 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},"resolution":{"name":"Resolution","viewHtml":" <div class=\"searcherValue\">\n \n <label class=\"fieldLabel\" for=\"fieldresolution\">Resolution:</label><span id=\"fieldresolution\" class=\"fieldValue\">\n \n Unresolved </span></div>\n","editHtml":"\n <div class=\"field-group aui-field-constants\" >\n <label for=\"searcher-resolution\">Resolution</label>\n \n <select class=\"select js-default-checkboxmultiselect\" data-placeholder-text=\"Find Resolutions...\" id=\"searcher-resolution\" multiple=\"multiple\" name=\"resolution\" size=\"4\" >\n <option class=\"headerOption\" selected=\"selected\" value=\"-1\" title=\"Unresolved\">Unresolved</option>\n <option value=\"1\" title=\"Fixed\" >Fixed</option>\n <option value=\"2\" title=\"Won't Fix\" >Won't Fix</option>\n <option value=\"3\" title=\"Duplicate\" >Duplicate</option>\n <option value=\"4\" title=\"Incomplete\" >Incomplete</option>\n <option value=\"5\" title=\"Cannot Reproduce\" >Cannot Reproduce</option>\n <option value=\"10000\" title=\"Done\" >Done</option>\n <option value=\"10001\" title=\"Won't Do\" >Won't Do</option>\n </select>\n </div>\n \n","jql":"resolution = Unresolved","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=\"6\" title=\"Closed\" data-simple-status=\"{"id":"6","name":"Closed","description":"","iconUrl":"/images/icons/statuses/closed.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Closed</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/subtask.gif\" value=\"10001\" title=\"Done\" data-simple-status=\"{"id":"10001","name":"Done","description":"","iconUrl":"/images/icons/subtask.gif","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Done</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/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. This is the backlog for the active sprint.","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/reopened.png\" value=\"4\" title=\"Reopened\" data-simple-status=\"{"id":"4","name":"Reopened","description":"This issue was once resolved, but the resolution was deemed incorrect. From here issues are either marked assigned or resolved.","iconUrl":"/images/icons/statuses/reopened.png","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">Reopened</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/statuses/resolved.png\" value=\"5\" title=\"Resolved\" data-simple-status=\"{"id":"5","name":"Resolved","description":"A resolution has been taken, and it is awaiting verification by reporter. From here issues are either reopened, or are closed.","iconUrl":"/images/icons/statuses/resolved.png","statusCategory":{"id":3,"key":"done","colorName":"green"}}\">Resolved</option>\n <option class=\"imagebacked\" data-icon=\"/\" value=\"10200\" title=\"Review in Progress\" data-simple-status=\"{"id":"10200","name":"Review in Progress","description":"Engineer is doing code review or Product is doing QA.","iconUrl":"/","statusCategory":{"id":4,"key":"indeterminate","colorName":"yellow"}}\">Review in Progress</option>\n <option class=\"imagebacked\" data-icon=\"/images/icons/subtask.gif\" value=\"10000\" title=\"To Do\" data-simple-status=\"{"id":"10000","name":"To Do","description":"This is the backlog for the sprint. Stories arrive in this status as fully written estimated, and put into this current sprint. If someone goes out on PTO, can be reset to this.","iconUrl":"/images/icons/subtask.gif","statusCategory":{"id":2,"key":"new","colorName":"blue-gray"}}\">To Do</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}]