My clients want a report page on our confluence that shows all the pages that will expire in the next month, and I'm trying to use the CQL Filter parameter in the Document States Report macro to accomplish this.
Although I know how to do this with normal CQL (stateexpiry <= now('1m')), I can't figure out how it would work with the 'FieldName:Value' system that their Macro uses for the CQL Filter parameter. I've tried a few tests where I new the expiry date exactly, and went stateexpiry:YYYY/MM/DD and stateexpiry:"YYYY/MM/DD", but that just chucks an error. I've also tried it with - instead of /, with no effect.
I feel like ServiceRocket's Reporting for Confluence would have an easy fix, but atm the team doesn't want to pay for it when there seems to be another solution.
Hello Community! Quick disclaimer: We are running a contest on Community (The Atlympics!) from July 23rd - August 8th of 2021. If you are interested in participating in this contest (prizes! ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events