CQL to query Page Properties for automation

[Rhys Gottwald]

Hi I want to run an automation that only executes actions if a specific value is found in the Page Properties Macro of a page. 

I have tried the AI labeling action with a prompt but this seems not to only consider the values in the Page Properties Macro it searches the whole page

Is there a way to do this with CQL?.  

[Tomislav Tobijas · Accepted solution]

Hi @Rhys Gottwald ,

I know this 'sectioning' the content can be a bit tricky. I did some parsing of the page body when it comes to Page Properties macro which pulls the email address of the mentioned user but this just feels a bit 'too complicated' if you ask me: https://community.atlassian.com/forums/Confluence-questions/Re-Re-Email-recipients-based-on-Page-property-smart-v/qaq-p/2903711/comment-id/330414#M330414

I guess you could parse JSON content of the page and store only part in the Page Properties macro in the variable and then use .match() function.

Again, this can get really complicated and I hope someone else has a 'smarter solution'. 👀

Cheers,
Tobi

[Rhys Gottwald]

Thank you @Tomislav Tobijas that is a bit of a complex solution for what we are trying to achieve, but it should work, thank you.

[James.Alvir]

@Rhys Gottwald - were you able to resolve? I'm tackling something similar. 

[Rhys Gottwald]

Yes, the solution from Tomislav worked.