Create a Page of Most Liked Pages

Question

What I want:

Page that shows recordings from a speaker series (label: "speaker-series") sorted by most likes (like the "Popular" option but with parameters and elsewhere in the space.

Question:

Can I add a custom query to a page that pulls that information based on the parameters identified above?

My missing knowledge:

How do you add queries to a page?

How do you determine names of tables and attributes to write queries?

Sayed Bares [ServiceRocket] · Answer

@Kelly Becker welcome to the community!

This is something that a third-party reporting apps could accomplish:

* https://marketplace.atlassian.com/search?hosting=cloud&product=confluence&query=reporting

Aron Gombas _Midori_ · Answer

This sounds like a typical use case to be solved with a CQL search like this:

label = "speaker-series" order by likes

Unfortunately, "likes" is not available as a CQL field. I don't know why, but CQL is very limited in comparison to JQL, its equivalent in Jira. I do hope though that Atlassian will keep adding new fields, functions to CQL. You may want to open a feature request.

If "likes" were available, you could create a page using one of the macros that display CQL search results.