As user, I want to use relative dates in Conditional colors

Description

According to Atlassian Jira Project Administration course, most users prefer to search (aka, think), using relatives dates (i.e. days, weeks etc.)

Currently, the conditional colors implemented into CCJ ask user to set the exact date, not a relative one.

Suggesting next.

As user I want to set conditional color based on relative dates.
For instance, I want to set the condition:

-> The events to be displayed in orange.

========================
Support relative time:
w - week
d - day
h - hour
m - minute
E.g.: 1m (1 minute), 2M (2 months)
From now taking current time.
now() - no parameters - current time
These can take relative parameters:
startOfDay
startOfMonth
startOfWeek
startOfYear

Link to info source: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html#Advancedsearching-functionsreference-nownow()

===============
Regular expr to support interval validation:
utils.durationStringCorrect => rename to utils.isDurationStringCorrect

=====
ConditionalColorsComponent line 124 additional validation if it's relative date or function with relative date

==========
Duration for function 'startOfWeek' should have the format (+/-)n(yMwdm), e.g -1M for 1 month earlier.
==========
} else if (
this.validationFieldOfDateTime !== undefined && this.isOperatorWithValue()
) {
if (new RegExp(this.validationFieldOfDateTime)).test(this.condColor.value)) {
// this is date time string
} else if (realativeTimePattern.test(this.condColor.value)) {
// this is relative time
} else if (realativeFunctionPattern.test(this.condColor.value)) {
// this is relative fucntion
} else {
// error (modify calendar.calConfig.sourceJiraAndWorklog.conditionalColor.errors.dateValueIsInvalid):
// The value should be either date or datetime or ralative time or realative function.
}
=============
// Date saved in ISO format but string contain space instead of 'T'
// if condColor.value regexp test for data/datetime:
operand2 = moment(condColor.value, fieldRenderId === 'date' ? Utils.ISO_DATE_FORMAT :
Utils.CONDITIONAL_DATE_TIME_FORMAT, true).valueOf();
// if if condColor.value regexp test for realative date:
call function calculateTimeForRelativeDateStr
// if if condColor.value regexp test for relative function:
call function calculateTimeForRelativeDateFun

=========================
reg exp for relative function: https://regex101.com/r/uzIg97/1

Your pinned fields
Click on the next to a field label to start pinning.

Priority

Major

Fix versions

Reporter

Mariia Korolishyna

Assignee

Mariia Korolishyna

App

CCJ

App Type

Cloud
Server