nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

extract current year in Confluence page

Anna_lpl1dr

Hi there,

I have created Confluence page where all issues are grouped by month.

Jira macro with relative time is used for each month. For example, January will use the query below

issueFunction in linkedIssuesOfRecursiveLimited("project = XXX", 5) AND issuetype = Bug AND status != Cancelled AND resolved >= startOfYear() and resolved < startOfYear(1M)

I need to extract current year to display it in my page title. The whole reason behind this exercise is to have 1 page that will automatically refresh for each new year without need to edit JQL & current Year value. Is there any way to accomplish this in Confluence without any plug ins and manual intervention to edit it on a yearly basis?

Thanking in advance!

Accepted answers

Nicolas Grossi

@Anna You might take a look at this documentation: https://community.atlassian.com/t5/Confluence-questions/How-to-show-today-s-date-in-confluence-page/qaq-p/2156865

Nicolas

All comments

Nicolas Grossi

@Anna You might take a look at this documentation: https://community.atlassian.com/t5/Confluence-questions/How-to-show-today-s-date-in-confluence-page/qaq-p/2156865

Nicolas

Anna_lpl1dr

Hi Nicolas,

Thanks for the link. It looks like there is no way of extracting year dynamically in Confluence unless we use plug ins. I even checked confiForm elements but none of them met my expectations and also during export into pdf the value in confiForm disappears. I don't see any built in solution within Confluence at this moment.

Regards!

Alex Medved _ConfiForms_

@Anna

Could you please help us to understand what disappears from ConfiForms in PDF export? May be we can fix it...

Also, have you considered creating a user macro may be?

Some ideas: https://wiki.vertuna.com/display/VERTUNA/Show+current+timestamp+on+the+page

Alex

Anna_lpl1dr

Hi Alex,

I inserted ConfiForm Field Definition (Field type = Text) and saved it. Then entered value 2024 in the page and exported in pdf. The entered value is not in pdf. I also noticed that pdf export pulls all values into pdf from dropdown (Field type = Dropdown), however, I am not my concern of these issues at this point.

I found another field type = Formula and tried to use NOW() function there and it doesn't display current time. I was thinking to format the date to get year. Is it possible to use this field just for pure date operation without referencing to any other field? I am not clear from the field description if this doable?

This is what the documentation tells about Formula field (https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Types)

This field type sets the value for the field based on an expression which can reference the record owner as [owner], a record modifier as [modifier]; and any record field as [entry.FIELD_NAME]. Important: this value is calculated every time an entry is updated (and created). See the "Calculated" type if the field should NOT recalculated on each edit. See Supported math operators, formulas and functions.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

jira-data-center

data-center

addon-com.vertuna.confluence.plugins.confiforms

confiforms