Summary

We are working on an app for Confluence and are using the search REST api using CQL. We are facing challenges with escaping the special characters (related to https://developer.atlassian.com/cloud/confluence/cql-functions/)

Use Case

1. Use contains operator
2. Use a Special character
3. Multi-character wIldcard search

I have a page with title "Parties @MJs". I have tested searching with the REST API browser with the following results:

The following examples return the page as a result

title='Parties @MJs'

title ~ 'Parties @MJs'

title ~ "Parties MJ*"

title ~ "Parties @"

The following examples do not return results

title ~ 'Parties @M*'

title ~ "Parties @M*"

title ~ 'Parties @M'

Notes

I would really appreciate if you can raise the request to not have this limitation. If it is considered a limitation and not a bug, maybe it could be added into the documentation as well.

Search functionality is an important feature in our app. We have 3.5k installations.

I can also verify that this does not work in cloud either.