eQL to order documents so that A100, A101, A102 revisions are below A99

Hi Julie, can you send me your current script that you have written?

Morning Carma,

Thanks for your response. My eQL is:

START WITH Document
SELECT
Id,
Code,
Revision,
Name,
Class.Name,
Attributes["CR_RSAR", "Review Status"].Value,
CAST( AuditDetails.AuditDate AS STRING, 'dd/MM/yyyy' ),
DISPLAY_NAME( ApprovalStatus ),
CAST( RIGHT( Revision, LENGTH( Revision ) - 1 ) AS INTEGER ) TestRev
WHERE
Code CONTAINS @code
AND Name CONTAINS @name
AND Projects.Project.Code LIKE @Area
AND Projects.Project.Code LIKE @Project
AND Attributes["CR_RSAR", "Function Code"].Value LIKE @Function
AND Attributes["CR_RSAR", "Review Status"].Value LIKE @Review
AND AuditDetails.AuditDef.ActionType = 1
AND Class.Path LIKE '%' + @classPath + '%'
AND IsTemplate = 'N'
AND AuditDetails.AuditDef.ActionType = 1
ORDER BY
Code,
CAST( RIGHT( Revision, LENGTH( Revision ) - 1 ) AS INTEGER )

Many thanks,
Julie

Julie, I will get back to your shortly. Neil Braybrooke is also looking at this and said it will take some time as they have to figure out something. Meanwhile I will forward this to him and this should help him to understand what you need.

Thank you Carma and Neil :)

Hi Julie,

Is the above eQL issue resolved? If not, could you please help me to understand the result you want after search.