This issue has been created
There are 2 updates.
 
 
CQL / cid:jira-generated-image-avatar-69e41962-f4e8-4f13-be74-0f679fed8f21 CQL-8 Open

Reject greater than and less than operators for id, parent and ancestor fields

 
View issue   ·   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-3ccfc2d0-9e74-41fe-8b78-8133324eb90b Raphaël Jakse created this issue on 14/Aug/25 10:06
 
Summary: Reject greater than and less than operators for id, parent and ancestor fields
Issue Type: cid:jira-generated-image-avatar-69e41962-f4e8-4f13-be74-0f679fed8f21 Improvement
Affects Versions: 0.1.0
Assignee: Unassigned
Created: 14/Aug/25 10:06
Priority: cid:jira-generated-image-static-major-01768842-bb56-471e-849b-104960b5cacb Major
Reporter: Raphaël Jakse
Description:

The way we convert CQL to solr, we can't support these operators for these fields. I don't think they make sense even in Confluence, you are probably not supposed to compare page ids which are database unique keys and which order don't have any particular meaning (you can't even rely on a page with a higher id being more recent for instance)

 
 

2 updates

 
cid:jira-generated-image-avatar-3ccfc2d0-9e74-41fe-8b78-8133324eb90b Changes by Raphaël Jakse on 14/Aug/25 10:06
 
Description: Examples of rejected expressions: {{parent > 42}}, {{id <= 1337}}, {{ancestor => 64}}.

The way we convert CQL to solr, we can't support these operators for these fields. I don't think they make sense even in Confluence, you are probably not supposed to compare page ids which are database unique keys and which order don't have any particular meaning (you can't even rely on a page with a higher id being more recent for instance)
Assignee: Raphaël Jakse