Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

UI Text Box

size	medium
type	info

This JQL function is used for searching project properties containing a date in format yyyy/MM/dd [hh:mm] or yyyy-MM-dd [hh:mm].

Quote-marks " must be used.

Code Block

language	bash
title	Syntax
linenumbers	true

projectsWhereDateProperty(propertyName, operator, date) #Output: Issues

UI Expand

title	Examples

Parser expression Description

Code Block

language	bash
linenumbers	true

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

linenumbers	true

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

title	Additional information

Parameters used in this function

Parameter Input (data type) Description

propertyName

Status

subtle	true
title	text

The name of a project property containing a text value.

operator

Status

subtle	true
title	text

A valid comparison operator.

date

Status

subtle	true
title	text

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

UI Text Box

type	info

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

UI Expand

title	Output

This function returns

Status


subtle	true
title	text

Page properties

hidden	true

Short description

JQL function to search for specific date properties.

Output

Status


subtle	true
title	text

Label

Page properties

hidden	true

Status

Tech review

Status

colour	Green
title	done

Style guide

Status

colour	Green
title	done

Status

title	todo

Status

colour	Yellow
title	Ready for review

Status

colour	Green
title	done

Status

colour	Red
title	flagged

Content

Space Tools

Versions Compared

Old Version 14

New Version 15

Key