Confluence List Macro CQL

Question

Hi, I have looked in help documentation and I cannot seem to find any help on the Insert Confluence List macro so I am coming here.

I what I need to do with the list is return a set of pages that;

* Are Verified and,
* Have a specific label.

I am adding a CQL query to the search bar the of the Macro, but the fact that I have entered a CQL query seems to be ignored and the entire content is used as the search term.

I know about the Filter by Label (Content by Label) macro, but I would preferred to use the List macro because I want the Table Layout and I cannot search only for pages that are verified.

So I guess my question is, can I use CQL in the Insert Confluence List macro?

Brandi Guess · Answer

Hello @Rhys Gottwald  I tested this today and can confirm the built-in search for this macro isn’t respecting filters.

Here’s a reliable workaround:

In Confluence, open Search

Set filters.

Copy the URL from your browser’s address bar.

Paste it on your page as a Smart Link

This respects the exact parameters you used in search.

Here is a loom:

https://www.loom.com/share/0739ff13f2df4bae91b6437514bb8c0d?sid=332354b4-94bc-4e39-b09e-5cd7c17400ac

Barbara Szczesniak · Answer

@Rhys Gottwald I can't seem to find a page on this macro either. In fact, I was surprised to find it in the list of available macros on a page (and was hoping there might be a help button in there, but no). The macro definition window just says search by keyword, so I'm not sure you can use a CQL query (gee, wouldn't it be nice if there was a page documenting how to use this macro? 🙃)

I did find a couple other questions where the community recommended using the Filter by Label macro, which may be because none of us know how to use the Insert Confluence List macro.