Jira Insight IQL find this month birtday people

Question

Hi

Is it possible somehow to get users from insight with IQL ho have this month birtday. Birthday is right now as Sünnupäev field day/month/year.

I like to sort people into Confluence like all aprill birthday people in one list.

Urmo Luts_uyee1y · Answer

Intresting, i did try but did not find any users.

"Sünnipäev" > startOfMonth() AND "Sünnipäev" < endOfMonth() ORDER BY Eesnimi ASC

But when i look into insight, there is user with birthday in march.

Marco Brundel · Answer

Hi @Urmo Luts ,

In IQL you can use

* startOfMonth()
* endOfMonth()

See also https://documentation.mindville.com/insight/latest/iql-insight-query-language-33467338.html#IQL-InsightQueryLanguage-Date

regards, Marco