Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,294,327
Community Members
 
Community Events
165
Community Groups

Comala States Report CQL Filter by stateexpiry

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.

2 answers

Hello @Gene McLay and other community members.

This capability was released in autumn 2021.

For more detail, see our wiki: https://wiki.comalatech.com/display/CDML/CQL+filter+-+reporting+pages+that+have+been+approved+or+expired+in+a+time+period 

All the best

James

Hello @Gene McLay 

We do not currently support these CQL expressions with the Document States Report Macro CQL filter. If you could contact me via https://support.comalatech.com I'll add your details to our internal feature request.

Thanks in advance

James
Senior Product Manager

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

779 views 5 21
Read article

Community Events

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

Events near you