# \#cql **URL:** https://community.developer.atlassian.com/tag/cql/73.md [Latest](https://community.developer.atlassian.com/latest.md) · [Categories](https://community.developer.atlassian.com/categories.md) · [Tags](https://community.developer.atlassian.com/tags.md) --- ## [How can I pull results from a CQL query into a custom email automation?](https://community.developer.atlassian.com/t/how-can-i-pull-results-from-a-cql-query-into-a-custom-email-automation/103045)
**Author:** [@SadajaRiddickJohnson](https://community.developer.atlassian.com/u/SadajaRiddickJohnson)\ **Replies:** 0\ **Last updated:** [October 1, 2026, 9:06pm UTC](https://community.developer.atlassian.com/t/how-can-i-pull-results-from-a-cql-query-into-a-custom-email-automation/103045 "2026-10-01T21:06:31Z")
I am attempting to setup an automation that involves using a CQL query to find all pages in one of my organizations’ spaces that have not been updated in over a year, and then send an email with all of these found pages. … --- ## [/wiki/rest/api/content/search?cql=id stopped working for specific pages](https://community.developer.atlassian.com/t/wiki-rest-api-content-search-cql-id-stopped-working-for-specific-pages/73182)
**Author:** [@VakalosMixalis](https://community.developer.atlassian.com/u/VakalosMixalis)\ **Replies:** 11\ **Last updated:** [August 25, 2026, 5:46pm UTC](https://community.developer.atlassian.com/t/wiki-rest-api-content-search-cql-id-stopped-working-for-specific-pages/73182 "2026-08-25T17:46:45Z")
Hello, I think there is a bug in the following REST API → wiki/rest/api/content/search?cql=id We were using this URL → wiki/rest/api/content/search?cql=id in (90101010,9101010101) to get the content of multiple page… --- ## [Is there an upper time limit for how long it takes for the CQL index to update?](https://community.developer.atlassian.com/t/is-there-an-upper-time-limit-for-how-long-it-takes-for-the-cql-index-to-update/101281)
**Author:** [@TobiasArndt](https://community.developer.atlassian.com/u/TobiasArndt)\ **Replies:** 1\ **Last updated:** [June 18, 2026, 5:33am UTC](https://community.developer.atlassian.com/t/is-there-an-upper-time-limit-for-how-long-it-takes-for-the-cql-index-to-update/101281 "2026-06-18T05:33:23Z")
In our migration tooling we have a page that lists all migrated pages that contain our macros where the customer has to perform some actions to complete the app migration. For this we need to wait for the CQL index to u… --- ## [Curl search cql with hex encoded url no longer working](https://community.developer.atlassian.com/t/curl-search-cql-with-hex-encoded-url-no-longer-working/100233)
**Author:** [@TD7200](https://community.developer.atlassian.com/u/TD7200)\ **Replies:** 2\ **Last updated:** [April 16, 2026, 9:48am UTC](https://community.developer.atlassian.com/t/curl-search-cql-with-hex-encoded-url-no-longer-working/100233 "2026-04-16T09:48:19Z")
We are using a bash script to update content on confluence cloud. First the script is searching a the page id with the page title using $CONFL\_API\_END=https://my-company.atlassian.net/wiki/rest/api/content/ curl -so- … --- ## [Getting inaccurate result from CQL server conenction](https://community.developer.atlassian.com/t/getting-inaccurate-result-from-cql-server-conenction/100142)
**Author:** [@PatelKashishkumarSud](https://community.developer.atlassian.com/u/PatelKashishkumarSud)\ **Replies:** 0\ **Last updated:** [April 9, 2026, 2:27pm UTC](https://community.developer.atlassian.com/t/getting-inaccurate-result-from-cql-server-conenction/100142 "2026-04-09T14:27:20Z")
Getting inaccurate result from CQL server connection, I used one cql to retrieve the data from confluence, hitting same query then getting different number of result, some time 6 records sometime 12 records, also getting… --- ## [Find pages with forge macro](https://community.developer.atlassian.com/t/find-pages-with-forge-macro/49438)
**Author:** [@MWulff](https://community.developer.atlassian.com/u/MWulff)\ **Replies:** 9\ **Last updated:** [December 10, 2025, 11:10am UTC](https://community.developer.atlassian.com/t/find-pages-with-forge-macro/49438 "2025-12-10T11:10:52Z")
We want to list all pages with a specific forge macro. Normally you can do this by searching for pages with a macro via wiki/rest/api/content/search?cql=macro in ("iframe")&type=page. It works for built-in macros (like … --- ## [Confluence REST v1 Search Endpoint FAILS - Cursor of next URL is EXTRAORDINARILY long, leading to 413 error](https://community.developer.atlassian.com/t/confluence-rest-v1-search-endpoint-fails-cursor-of-next-url-is-extraordinarily-long-leading-to-413-error/95098)
**Author:** [@heinrich-wikitraccs](https://community.developer.atlassian.com/u/heinrich-wikitraccs)\ **Replies:** 7\ **Last updated:** [September 10, 2025, 1:38pm UTC](https://community.developer.atlassian.com/t/confluence-rest-v1-search-endpoint-fails-cursor-of-next-url-is-extraordinarily-long-leading-to-413-error/95098 "2025-09-10T13:38:46Z")
This started happening after Sept 4, 2025, around 2 PM. Running the following CQL search returns results with a reeeeeeeeeeeaally long next URL: /wiki/rest/api/content/search?cql=type=page&limit=200 (Note: in the s… --- ## [Workaround for 32KB Content Property Limit to Index a 5MB LaTeX Document in a Custom ACE Macro](https://community.developer.atlassian.com/t/workaround-for-32kb-content-property-limit-to-index-a-5mb-latex-document-in-a-custom-ace-macro/90637)
**Author:** [@FernandoGuimares](https://community.developer.atlassian.com/u/FernandoGuimares)\ **Replies:** 1\ **Last updated:** [March 25, 2025, 4:50am UTC](https://community.developer.atlassian.com/t/workaround-for-32kb-content-property-limit-to-index-a-5mb-latex-document-in-a-custom-ace-macro/90637 "2025-03-25T04:50:25Z")
Hi everyone, I’m building a custom Confluence Cloud macro using Atlassian Connect Express (ACE) to index and display content from large LaTeX documents (up to 5MB). My goal is to attach metadata to pages via content pro… --- ## [Confluence Cloud CQL label search - draft pages not included](https://community.developer.atlassian.com/t/confluence-cloud-cql-label-search-draft-pages-not-included/86858)
**Author:** [@UlrichKuhnhardtIzym1](https://community.developer.atlassian.com/u/UlrichKuhnhardtIzym1)\ **Replies:** 1\ **Last updated:** [December 4, 2024, 11:07pm UTC](https://community.developer.atlassian.com/t/confluence-cloud-cql-label-search-draft-pages-not-included/86858 "2024-12-04T23:07:29Z")
I have added label cqltest to a draft (live-edit) page in confluence. I am running the CQL search query: search?cql=label=cqltest&cqlcontext=%7B%22contentStatuses%22%3A%5B%22draft%22%5D%7D Observed behaviour No result… --- ## [Confluence Cloud ?CQL=macro=myForgeMacro returns no results](https://community.developer.atlassian.com/t/confluence-cloud-cql-macro-myforgemacro-returns-no-results/86857)
**Author:** [@UlrichKuhnhardtIzym1](https://community.developer.atlassian.com/u/UlrichKuhnhardtIzym1)\ **Replies:** 1\ **Last updated:** [December 4, 2024, 10:28pm UTC](https://community.developer.atlassian.com/t/confluence-cloud-cql-macro-myforgemacro-returns-no-results/86857 "2024-12-04T22:28:25Z")
I have declared a Confluence forge macro with key myForgeMacro. I have added the macro to several pages. Observed behaviour The CQL macro rest api query ?cql=macro=myForgeMacro returns no results. Expected Behaviour T… --- ## [How to pass contentStatuses in cqlContext object for CQL Search API](https://community.developer.atlassian.com/t/how-to-pass-contentstatuses-in-cqlcontext-object-for-cql-search-api/47076)
**Author:** [@ShwetaGulati](https://community.developer.atlassian.com/u/ShwetaGulati)\ **Replies:** 10\ **Last updated:** [October 10, 2024, 2:30pm UTC](https://community.developer.atlassian.com/t/how-to-pass-contentstatuses-in-cqlcontext-object-for-cql-search-api/47076 "2024-10-10T14:30:50Z")
How to pass contentStatuses in cqlContext object for CQL Search API? Can you share a sample request for getting items with status = current? --- ## [Search non-app users via CQL](https://community.developer.atlassian.com/t/search-non-app-users-via-cql/85023)
**Author:** [@Corentin](https://community.developer.atlassian.com/u/Corentin)\ **Replies:** 2\ **Last updated:** [October 8, 2024, 7:47am UTC](https://community.developer.atlassian.com/t/search-non-app-users-via-cql/85023 "2024-10-08T07:47:52Z")
Hi folks, is it possible to search users while filtering out app users? Contrary to tickets like https://jira.atlassian.com/browse/CONFCLOUD-70582, the accountTypefield is now populated, however, it seems like it is sti… --- ## [CQL for decision macro search](https://community.developer.atlassian.com/t/cql-for-decision-macro-search/83831)
**Author:** [@GrigoryRomanyuk](https://community.developer.atlassian.com/u/GrigoryRomanyuk)\ **Replies:** 0\ **Last updated:** [September 27, 2024, 6:02am UTC](https://community.developer.atlassian.com/t/cql-for-decision-macro-search/83831 "2024-09-27T06:02:36Z")
I want to fetch all decision from the entire confluence site. But I cannot find the right CQL. macro = decision doesn’t work. There is a macro “Decision report”, that searches for all decisions, that kind of a clue to… --- ## [See all pages edited by a particular individual within a particular time period](https://community.developer.atlassian.com/t/see-all-pages-edited-by-a-particular-individual-within-a-particular-time-period/60519)
**Author:** [@alok](https://community.developer.atlassian.com/u/alok)\ **Replies:** 4\ **Last updated:** [September 5, 2024, 5:49am UTC](https://community.developer.atlassian.com/t/see-all-pages-edited-by-a-particular-individual-within-a-particular-time-period/60519 "2024-09-05T05:49:28Z")
@iragudo once concern I have with this approach: Would this only show contributions by the last editor? In other words, if two people edited the same page, it seems only the last editor would show up in the API. Is there… --- ## [Search By Space Name](https://community.developer.atlassian.com/t/search-by-space-name/82410)
**Author:** [@MartinCassidy](https://community.developer.atlassian.com/u/MartinCassidy)\ **Replies:** 1\ **Last updated:** [August 8, 2024, 9:42am UTC](https://community.developer.atlassian.com/t/search-by-space-name/82410 "2024-08-08T09:42:00Z")
I’m trying to create a forge app will needs to be able to query all spaces within Confluence, ideally with the ability to filter by space name and type (e.g. personal/global) The deprecated /wiki/rest/api/search looks l… --- ## [Finding a page by title](https://community.developer.atlassian.com/t/finding-a-page-by-title/41553)
**Author:** [@candid](https://community.developer.atlassian.com/u/candid)\ **Replies:** 9\ **Last updated:** [July 2, 2024, 1:21pm UTC](https://community.developer.atlassian.com/t/finding-a-page-by-title/41553 "2024-07-02T13:21:37Z")
If you ever want to retrieve one or multiple pages by title using the Confluence REST API and thought that would be a matter of one simple call against the CQL or Content REST API, you have been fooled by a collection of… --- ## [How do I extract only the relevant information with the confluence API?](https://community.developer.atlassian.com/t/how-do-i-extract-only-the-relevant-information-with-the-confluence-api/81500)
**Author:** [@crazyrationalist](https://community.developer.atlassian.com/u/crazyrationalist)\ **Replies:** 0\ **Last updated:** [July 2, 2024, 12:13pm UTC](https://community.developer.atlassian.com/t/how-do-i-extract-only-the-relevant-information-with-the-confluence-api/81500 "2024-07-02T12:13:33Z")
I am using CQL search with the confluence API like so: query = f'siteSearch ~ "{search\_term}"' But this yields several documents most of which are not directly talking about the search term. For example, if the search … --- ## [REST API CQL search with double quotes](https://community.developer.atlassian.com/t/rest-api-cql-search-with-double-quotes/80573)
**Author:** [@OrenZehavi](https://community.developer.atlassian.com/u/OrenZehavi)\ **Replies:** 2\ **Last updated:** [July 2, 2024, 12:58pm UTC](https://community.developer.atlassian.com/t/rest-api-cql-search-with-double-quotes/80573 "2024-07-02T12:58:01Z")
Hey, I have issues when searching pages using the search CQL API, using a string that contains double quotes. For example, I have page with the following title: what"s. When trying to search it using the REST API I ge… --- ## [How to create index schema and use CQL?](https://community.developer.atlassian.com/t/how-to-create-index-schema-and-use-cql/57007)
**Author:** [@anon39253398](https://community.developer.atlassian.com/u/anon39253398)\ **Replies:** 3\ **Last updated:** [April 1, 2024, 10:17am UTC](https://community.developer.atlassian.com/t/how-to-create-index-schema-and-use-cql/57007 "2024-04-01T10:17:47Z")
I’ve been wrestling with CQL for a while now, time to ask for help. Whatever I do (see below) I always get the same 400 response com.atlassian.confluence.api.service.exceptions.BadRequestException: Could not parse cql … --- ## [BUG: using cql to retrieve page data truncates page title](https://community.developer.atlassian.com/t/bug-using-cql-to-retrieve-page-data-truncates-page-title/77112)
**Author:** [@DaraOhEidhin](https://community.developer.atlassian.com/u/DaraOhEidhin)\ **Replies:** 3\ **Last updated:** [February 9, 2024, 9:26pm UTC](https://community.developer.atlassian.com/t/bug-using-cql-to-retrieve-page-data-truncates-page-title/77112 "2024-02-09T21:26:34Z")
Currently I have pages titled in the format \ - \<.page description\> As time goes by the \<.page description\> may be changed based on a central database but the \ is constant. As such I n… --- ## [How to create a CQL query using API that searches for an exact phrase](https://community.developer.atlassian.com/t/how-to-create-a-cql-query-using-api-that-searches-for-an-exact-phrase/41490)
**Author:** [@fbunting](https://community.developer.atlassian.com/u/fbunting)\ **Replies:** 4\ **Last updated:** [October 16, 2023, 1:16am UTC](https://community.developer.atlassian.com/t/how-to-create-a-cql-query-using-api-that-searches-for-an-exact-phrase/41490 "2023-10-16T01:16:32Z")
In the UI, if I want to search for the exact phrase “red line”, I just enclose it in quotes. However, this does not seem to work from the REST API. No matter what I do, I get back all results that have either the word ‘… --- ## [Are the sub-queries in CQL or are they planned?](https://community.developer.atlassian.com/t/are-the-sub-queries-in-cql-or-are-they-planned/71848)
**Author:** [@aron.gombas](https://community.developer.atlassian.com/u/aron.gombas)\ **Replies:** 0\ **Last updated:** [August 9, 2023, 2:08pm UTC](https://community.developer.atlassian.com/t/are-the-sub-queries-in-cql-or-are-they-planned/71848 "2023-08-09T14:08:10Z")
We query for the descendants of a page using the ancestor CQL field: ancestor = 123 So far, so good. Now I am in a use case, where I’d like to get the descendants of multiple ancestors where the ancestors themselves a… --- ## [Are space properties indexed and can be searched in CQL?](https://community.developer.atlassian.com/t/are-space-properties-indexed-and-can-be-searched-in-cql/71847)
**Author:** [@aron.gombas](https://community.developer.atlassian.com/u/aron.gombas)\ **Replies:** 0\ **Last updated:** [August 9, 2023, 1:54pm UTC](https://community.developer.atlassian.com/t/are-space-properties-indexed-and-can-be-searched-in-cql/71847 "2023-08-09T13:54:39Z")
Content properties in Confluence Cloud can be made searchable in CQL using Content Property Index Key Configuration entities. This is really powerful! Is something like this available also for space properties? (I hav… --- ## [CQL function now() returns a value in my own timezone (UTC+2), but startOfDay() always returns a value in UTC?!](https://community.developer.atlassian.com/t/cql-function-now-returns-a-value-in-my-own-timezone-utc-2-but-startofday-always-returns-a-value-in-utc/71608)
**Author:** [@aron.gombas](https://community.developer.atlassian.com/u/aron.gombas)\ **Replies:** 3\ **Last updated:** [August 4, 2023, 6:15am UTC](https://community.developer.atlassian.com/t/cql-function-now-returns-a-value-in-my-own-timezone-utc-2-but-startofday-always-returns-a-value-in-utc/71608 "2023-08-04T06:15:42Z")
Yesterday I was investigating a customer problem, and it seems to me that different CQL functions that return time values are working in inconsistent timezones. Note that the timezone being used is not documented at all… --- ## [Search attachements by file extensions using CQL](https://community.developer.atlassian.com/t/search-attachements-by-file-extensions-using-cql/52951)
**Author:** [@LukasGobelet](https://community.developer.atlassian.com/u/LukasGobelet)\ **Replies:** 11\ **Last updated:** [July 5, 2023, 10:20pm UTC](https://community.developer.atlassian.com/t/search-attachements-by-file-extensions-using-cql/52951 "2023-07-05T22:20:14Z")
Hi there my fellow devs :laughing:, I am trying to search attachements by file extensions by CQL with the server REST API. Until now I have tried following query type=attachment and title~"\*.bpmn" to find all attachmen… --- ## [REST-API Search content by attachment extension or type of media with CQL](https://community.developer.atlassian.com/t/rest-api-search-content-by-attachment-extension-or-type-of-media-with-cql/70810)
**Author:** [@MarkusWeigelt](https://community.developer.atlassian.com/u/MarkusWeigelt)\ **Replies:** 2\ **Last updated:** [July 4, 2023, 4:47pm UTC](https://community.developer.atlassian.com/t/rest-api-search-content-by-attachment-extension-or-type-of-media-with-cql/70810 "2023-07-04T16:47:28Z")
I would like to search for PDF attachments via CQL over REST-API. Unfortunately I have not found a way. The options found so far only concern Confluence Server/Data Center but not Confluence Cloud. title field of attach… --- ## [Is this possible to search for content in the Trash and in the Archived Pages section through the REST API using CQL?](https://community.developer.atlassian.com/t/is-this-possible-to-search-for-content-in-the-trash-and-in-the-archived-pages-section-through-the-rest-api-using-cql/69661)
**Author:** [@aron.gombas](https://community.developer.atlassian.com/u/aron.gombas)\ **Replies:** 0\ **Last updated:** [May 23, 2023, 1:54pm UTC](https://community.developer.atlassian.com/t/is-this-possible-to-search-for-content-in-the-trash-and-in-the-archived-pages-section-through-the-rest-api-using-cql/69661 "2023-05-23T13:54:19Z")
Hey, We have a use case where it would be beneficial if the /content/search endpoint in the Confluence Cloud REST API which supports CQL queries would also search among deleted contents (in the trash) and among archived… --- ## [Some CQL error messages are not helpful](https://community.developer.atlassian.com/t/some-cql-error-messages-are-not-helpful/68922)
**Author:** [@GaborDicsoMidori](https://community.developer.atlassian.com/u/GaborDicsoMidori)\ **Replies:** 0\ **Last updated:** [April 28, 2023, 12:36pm UTC](https://community.developer.atlassian.com/t/some-cql-error-messages-are-not-helpful/68922 "2023-04-28T12:36:49Z")
Hi, Executing the a + " CQL query, which is obviously invalid, results in the following error message: wiki/rest/api/search?cql=a+%2B+%22&limit=10 { "statusCode": 400, "data": { "authorized": true, "valid"… --- ## [CQL search after a migration](https://community.developer.atlassian.com/t/cql-search-after-a-migration/67695)
**Author:** [@Corentin](https://community.developer.atlassian.com/u/Corentin)\ **Replies:** 1\ **Last updated:** [March 24, 2023, 12:06am UTC](https://community.developer.atlassian.com/t/cql-search-after-a-migration/67695 "2023-03-24T00:06:15Z")
Hi, as part of our app’s migration process, we need to process pages migrated by the client to transform server macros to a format that is recognized by the cloud counterpart. To do that, we run a cql search on pages in… --- ## [Confluence cql to get only size?](https://community.developer.atlassian.com/t/confluence-cql-to-get-only-size/65064)
**Author:** [@AbhishekBiswas](https://community.developer.atlassian.com/u/AbhishekBiswas)\ **Replies:** 2\ **Last updated:** [January 16, 2023, 11:14am UTC](https://community.developer.atlassian.com/t/confluence-cql-to-get-only-size/65064 "2023-01-16T11:14:03Z")
hi, is there is way to get only the size in cql response ? like in Jira maxresults = 0 returns the total count only and not the expandable list [Next page](https://community.developer.atlassian.com/tag/cql/73.md?match_all_tags=true&page=1&tags%5B%5D=cql)