You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I've been trying to get a CQL working. The use case is:
1. report that returns a list of comments made to pages within a single space
2. over the past 7 days
3. filter by a specific label ( i can't make this one work)
This is the query I have (minus the label):
space="LANDING" and type=comment and created >= now("-7d")
This filters out the comments in the last 7 days. But if I add the label:
space="LANDING" and type=comment and created >= now("-7d") and label in (remove)
Then the query returns 0.
I tried adding the type=page (and / or). With AND it shows 0 results. If I use the OR then the returns are all comments (it bypasses the created >=now)
space="LANDING" and type=comment or type=page and created >= now("-7d") and label in (remove) order by lastModified desc
Is this a CQL limitation? I can't find information about that.
Thanks for the help!
Hello @Aaron Pavez
Unfortunately, this combination is not possible, as the Comments do not "inherit", or "receive" the label attribute, only the page. Thus, they are not shown in the results, because the comments themselves do not carry the Label, but the Page is the one that does.
Ill attach a link to a ticket where Atlassian mentions this.
Hopefully this will be useful to anyone who seeks to achieve the same as we did.
With friendly regards