Can I list all pages of a space, showing if or if not they have a label attached?

Question

In my case, I want to make sure, that certain pages do have a certain label, even if they were created via "blank page" (instead of using the correct customized page template).

Is there an option to do so, e.g. a simple list with all pages of a space in one column and used lables (or empty field) for each page in a second column?

Ian McKay_hxnmd8 · Answer

Hiya!

Label not in worked for me... Thanks for sharing the solution I was looking for.

Awesome community!

Siegfried Steins · Answer

Hi again and thanks to @Srinatha Tondihal for your inspiration.

I now made a big step forward using this CQL:

label not in ("label1","label2") AND type=page AND space.key="spacename"

The output I get from that is a plain list with two coloums - "Title" and "Space"

Is it possible to change the output? e.g. to "Title" and "Label"?

Thanks for any further inspiration :)
KR Siegfried

Siegfried Steins · Answer

Hi @Srinatha Tondihal and thank you very much for the warm welcome and you fast answer.

However, I get an error message "Could not parse cql"
And I'm afraid it's a little bit more complicated, as users might add labels on each page by themselves (which is wanted), but I have to check, whether certain defined lables are attached in order to organize our views via page property macros.

Probably, it's possible to adjust the CQL? (I already used JQL, but not CQL so far)

Thanks a lot in advance :)
KR Siegfried