Issue encountered with Database.countQuery() and ORDER BY filter

[Anuja-dadheech20]

An exception will occur in the AsyncProcessor class at line 94 when retrieving the record count using Database.countQuery if the query includes an "ORDER BY" expression. The exception message will read as follows: "System.UnexpectedException: COUNT() and ORDER BY may not be used together."

Could you please review the code snippet below and share your thoughts on whether this is an effective way to resolve the issue?

String recordCountQuery = query.replace(query.substringBeforeLast(' from '), 'select count() ');
Integer indexOfOrderBy = query.lastIndexOf('order by');
if (indexOfOrderBy != -1) {
    recordCountQuery = recordCountQuery.replace(query.substring(indexOfOrderBy), ' ');
}

[jamessimone]

@Anuja-dadheech20 let me take a look at this today - I will push up a fix for this

[jamessimone]

@Anuja-dadheech20 - this is all set, thanks for pointing this out!