use SQL_CALC_FOUND_ROWS

[shamim2883]

Now we can not use SQL_CALC_FOUND_ROWS
May you please support this?

[shadowhand]

What is preventing you from using it? A SELECT with an Expression as the column should work fine.

[shamim2883]

Thank you for such a quick reply.
With an Expression will create a comma, But there will be no comma with SQL_CALC_FOUND_ROWS

[shadowhand]

Ah, right. Would something like this work for you?

$query = $queryFactory->select(/* ... */)->calcFoundRows(true);

[shamim2883]

yes, i think that will be fine.

[shamim2883]

or more generic, any word can be added, eg
$query = $queryFactory->select(/* ... */)->addString( string ...$string );
$string can be DISTINCT SQL_CALC_FOUND_ROWS etc any word which does not need any comma