How do i filter by current date as dynamic in confluence database?

Question

We created a database for daily standup and only want to show today's dailys every day without having to change them manually.

Tomislav Tobijas · Answer

Hi @Nickolas N ,

This currently isn't supported for Confluence Databases. However, here's a feature suggestion on which you can vote and add yourself as a watcher: CONFCLOUD-78103: Date field: Add parameters like current date to filters for dynamic filtering

Cheers,
Tobi

Sushant Verma · Answer

Hi @Nickolas N

Welcome to the community!

You can use JQL or macros for advanced filtering and dynamic display.

If your Confluence page is integrated with Jira for issue or project tracking, you can use JQL to dynamically filter issues based on the current date. Below is the JQL query:

created >= startOfDay() AND created <= endOfDay()

To apply this in Confluence:

* Go to a Confluence page where you want to display the filtered results.
* Add the Jira Issues macro and paste your dynamic JQL query.

This will show issues that meet the current date filter, updated dynamically whenever the page is loaded.

Regards,
Sushant Verma