Hello everyone! Michael from Confluence here. I am writing today to let you know that CQL (Confluence Query Language) searches now support "smartlink" as a type. Previously, when users wanted to f...
...o review the link." I cannot figure out how to scroll through every page and to look for links & linked pages. Have tried CQL but I guess I am not advanced enough yet. Did anyone try that yet o...
...abel=announcement" CQL condition, but it is not triggering when it is supposed to. Here is a screenshot showing how I have the rule set up: You can see here I added some logging actions to verify t...
...xpand=body.view&cql=(type=page%20and%20space%20in%20(SAPW,SAMPO, .... )) Part of the first response below: " ... ], "start": 0, "limit": 35, "size": 22, "_links": { "base": ... " Is there s...
Hello, I'm trying to run a REST API that searches content by CQL via multiple IDs, but some pages aren't retrieved. The API I used is the following: /rest/api/content/search?cql=(id=3...
...n author can have several pages and will therefore get several emails. However, we want to set a rule with CQL that only sends 1 email to each author if they have an outdated page, and not 1 email per o...
Hi there. I'm trying to search a confluence page for body content that has a certain tag and that lives in a certain space that is also tagged. It seems I cannot do hierarchical searches in the Adv...
Using Confluence automation, how would one set up a rule to: For pages that: Exist as a child of a page with a specific title, Have a specific label on them, When the page moves, Remove a spe...
Hi According to the cql documentation I can search for pages containing the Jira macro by entering: macro=jira However this searches only for: "macro" OR "Jira" it seems. Is it possible to d...
The Title & Text field can use wildcards * and fuzzy operators like ~ At times, we need to search for slight variations of the page labels Is there any way to use a wildcard or fuzzy operator t...
Using CQL i want to restrict the results returned by a query to a limit of say 25 or 50. How do i specify that limit in the CQL ? (Label = "sample-issue" OR Title ~ "sample-issue~") A...
Can anyone tell med how to search in all child pages of a given page by using CQL filters?
Hi, I am using confluence cloud and have tried to search in confluence using the (-) minus operator, but received the same results as if I didn't use it at all (all the results for the search ...
...ugely appreciated. The Goal : Complete a CQL Search using Jira Automation's "Send Web Request" action. Where I'm stuck : I've managed to somehow get the a...
I'm trying to get the actual DATE for the last modification, not just results that fit in that constraint, i.e., rest/api/content/search?cql=lastModified>=2022-01-02&expand=body.storage...
...reated that has a certain keyword. It is relatively simple: When: Page published If: CQL condition label = "xyz" Then: Send email However, I can't find an expression that describes that there is n...
Hello! I use the confluence API in my project, to create confluence links, and today we already do the search, by title, or text, using de CQL parameter. But I did a search, and I came to see s...
...reated the equivalent CQL: contributor="useraccountid" and type="page" However, when calling the API, I only get 37 results back, not the 45 results I expected. Are there any assumptions m...
...he "CQL Search" Makro. These clients typically want all fields filled on a certain page in case they print the page and it should include all context. Or have a large page properties list where t...
Hi , hope all in good time. We are trying to sort this CQL by the created parameter as per below CQL. type=page and created >= startOfMonth("-90d") Referred to the docs, but got the e...
...ade a workflow parameter in my comala workflow that keeps track of labels. Is there a way to input whatever the get-metadata macro returns into the content-by-label's cql parameter? I'm l...
CQL or Confluence Query Language is a powerful search language. It is a secret trick that only advanced Confluence users will know. Unlike its famous sibling JQL which is used in Jira a...
My clients want a report page on our confluence that shows all the pages that will expire in the next month, and I'm trying to use the CQL Filter parameter in the Document States Report macro to a...
We would like to create a document space for certain documents. The idea is to include a search bar that will only search through attachments within a certain page. Users will need to be able to sear...
I am writing a user macro to search a page/pages using CQL with the code below ##Test property ## @param PageTitle:title=Page Title|type=string|required=true|desc=Your page title ## @param S...
Copied to clipboard