Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
UI Text Box
sizemedium
typeinfo

This JQL function is used for searching project properties containing a date.

Quote-marks " must be used.

Code Block
languagebash
titleSyntax
linenumberstrue
projectsWhereDateProperty(propertyName, operator, date) #Output: Issues
UI Expand
titleExamples
Parser expressionDescription
Code Block
languagebash
linenumberstrue
project in projectsWhereDateProperty(projectStart, ">", 2020/01/01 )
This example returns a list of projects where the property called 'projectStart' contains a date value greater than '2020/01/01', i.e. text {projectStart=2020/05/05'} is present in the project's description.
Code Block
linenumberstrue
project in projectsWhereDateProperty(deadline, ">=", -1w )
This example returns aa list of projects where a property called 'deadline' exists with a date value greater than a week ago.
UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
propertyName

Status
subtletrue
titletext

The name of a project property containing a text value.
operator

Status
subtletrue
titletext

A valid comparison operator.

date

Status
subtletrue
titletext

The date to be compared with the date stored in the project property. 

UI Text Box
typeinfo

The date must have a format of yyyy/MM/dd [hh:mm] or yyyy-MM-dd [hh:mm]

UI Expand
titleOutput

This function returns 

Status
subtletrue
titletextPROJECT LIST
.

Page properties
hiddentrue
Short description

JQL function to search for specific date properties.

Output

Status
subtletrue
titletextPROJECT list

Label
Page properties
hiddentrue

Status
Tech review

Status
colourGreen
titledone

Style guide

Status
colourGreen
titledone

Status
titletodo
Status
colourYellow
titleReady for review
Status
colourGreen
titledone
Status
colourRed
titleflagged