Page History

Versions Compared

Old Version 9

changes.mady.by.user Christian Czaia

Saved on Nov 17, 2020

compared with

New Version Current

changes.mady.by.user Jona Ittermann

Saved on Sep 30, 2021

Key

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

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

UI Text Box

size	medium
type	info

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

UI Text Box

type	note

Quote-marks " must be used.

Code Block

language	bash
title	Syntax
linenumbers	true

projectsWhereDateProperty(propertyName, operator, date) #Output: IssuesText list

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 all issue belonging to a project where a projects where the property called 'projectStart' exists with 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 a list of all issue belonging to a project 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	data typetext

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 returns a

Status


subtle	true
title	issuestext list

Include Page

	DECADIS:_snip_limit_JQL_functions
	DECADIS:_snip_limit_JQL_functions

Page properties

hidden	true

Short description

JQL function to search for specific date properties.Returns projects with specific properties containing a date

Output

Status


subtle	true
title	text list

Label

Page properties

hidden	true

Status

Tech review

Status

colour	Yellow
title	Ready for review

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 9

New Version Current

Key