Get started

Use case library

JWT expression editor

JWT expression parser functions

JWT workflow functions

JWT remote actions

JWT automation rules

JWT calculated fields

JWT calendars

JWT properties

JWT JQL functions

Cloud migration hub

Additional product info

Versions Compared

Old Version 20

changes.mady.by.user Iheb Kharab

Saved on

compared with

New Version Current

changes.mady.by.user Iheb Kharab

Saved on

Key

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


UI Text Box
sizemedium
typeinfo

This JQL function is used for searching for returns users by checking against their user properties that contain date or date-time values.


Code Block
languagebash
titleSyntax
linenumberstrue
usersWithDateTimeProperty(propertyName, operator, value, format) #Output: UserText list


Parameters used in this function

UI Expand
titleExamples


Parser expressionDescription


Code Block
languagebash
linenumberstrue
assignee in usersWithDateTimeProperty("day_off", "<", "2021/11/03", "dd/MM/yy")


This example returns all issues where the assignee's property day_off is before 2021/11/03, written in the format dd/MM/yyyy.


Code Block
languagebash
linenumberstrue
reporter in usersWithDateTimeProperty("birthday", ">=", "1997/09/16 [11:30", "MM-dd-yyyy [hh:mm]")


This example returns all issues where the Reporterreporter's property birthday is after or on the same day as 1997/09/16 11:30, written in the format MM-dd-yyyy [hh:mm].
UI Expand
titleAdditional information
ParameterInput (data type)Description
propertyName

Status
subtletrue
titletext

The name of a user property containing a date or date-time value
operator

Status
subtletrue
titletext

A valid comparison operator

value

Status
subtletrue
titletext

The value to compare with the property.

UI Text Box
typeinfo

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

format

Status
subtletrue
titletext

The date or date-time format in which the property value is written. Any format is allowed.
UI Expand
titleOutput
UI Expand
titleExamples
This function returns a 
Status
subtletrue
titleUSER LIST
.
UI Text Box
sizemedium
typeinfo

Variant supporting 12-hr and 24-hr format:

  • 12-hr format: MM-dd-yyyy [hh:mm a] where a stands for AM/PM
  • 24-hr format: MM-dd-yyyy [hh:mm]
Code Block
languagebash
titleSyntax
linenumberstrue
usersWithDateTimePropertyValue(String property, String comparator, DateTime value, format) #Output: User list
Parser expressionusersWithDateTimePropertyValue091611", "MM-dd-yyyy [hh:mm0916 11:30 , written in the format MM-dd-yyyy [hh:mm] (24-hr format)
Description


Code Block
languagebash
linenumberstrue
assignee in 
usersWithDateTimeProperty("day_off", "<", "2020/
08/
15 
[12:30
]")


This example returns all issues where the assignee's property day_off is before 2020/08/15 12:30.


Code Block
languagebash
linenumberstrue
assignee in usersWithDateTimePropertyValueusersWithDateTimeProperty("day_off", "<", "2020/09/16 23[12:30", "MM-dd-yyyy [hh:mm a]")


MM-dd-yyyy [hh:mm a] (12-hr format AM/PM)

This example returns all issues where the assignee's property day_off is before 2020/09/16

11:30 PM, written in the format 

12:30.






The date must have a format of 
UI Expand
titleAdditional information

Parameters used in this function

ParameterInput (data type)Description
String property
propertyName

Status
subtletrue
titletext

The name of a user property containing a date or date-time value.

String comparator

The property has to be saved in one of the following format:

  • yyyy/MM/dd
  • yyyy/MM/dd [hh:mm]
operator

Status
subtletrue
titletext

A valid comparison operator

.DateTime

. Allowed operators are:

OperatorDescription
=Property must be equal to the specified value.
!=Property must not be equal to the specified value.
<

Property must be lower than the specified value,

meaning that the date saved date in the property must be before the specified date.

>

Property must be greater than the specified value,

meaning that the date saved date in the property must be after the specified date.

<=

Property must be lower or equals to the specified value,

meaning that the date saved date in the property must be before or equals to the specified date.

>=

Property must be greater or equals to the specified value,

meaning that the date saved date in the property must be after or equals to the specified date.


value

Status
subtletrue
titletext

The value to compare with the property

.
UI Text Box
typeinfo

, the following formats are accepted:

  • yyyy/MM/dd [hh:mm]
or
  • yyyy
-
  • /MM
-dd [hh:mm a] in 12-hr
  • /dd


UI Text Box
typeinfo

In case you use the format yyyy/MM/dd, the time part of the date will automatically be set to 00:00

format

Status
subtletrue
titletext

The date or date-time format in which the property value is written

.




UI Expand
titleOutput

This function returns a 

Status
subtletrue
titleUSER LIST
.
text list


UI Text Box
typetip

If you want to search for issues where a user as a specific text or numeric property value, have a look the the usersWithTextProperty or usersWithNumericProperty() function.

If you want to search for issues, checking only if a property is being set ignoring it's value, have a look the the usersWithProperty() function.


Include Page
DECADIS:_snip_limit_JQL_functions
DECADIS:_snip_limit_JQL_functions


Page properties
hiddentrue


Short description

Searches for users by checking on their Returns users with specific date or date-time properties.

Output

Status
subtletrue
titleUSER LISTtext list

Label

Status
colourRed
titlestaff pick




Page properties
hiddentrue



Status
Tech review

Status
colourGreyYellow
titleTODoReady for review

Style guide

Status
colourGreen
titledone

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