Add "count(*)" result in list table.

I am trying like this, but no luck.

Controller

    $Invoices = Invoices::find(["group" => "status, date","order" => "id"]);

    $this->view->setVar($count= Invoices::count(
        [
            "group" => "status,date",
            "order" => "id"]
        ]
    ));

View

<tr>

    <td>{{ invoice.id }}</td>

    <td>{{ invoice.inv_number }}</td>

    <td>{{ invoice.cust }}</td>

    <td>{{ invoice.date }}</td>

    <td>{{ invoice.status }}</td>

    <tb>{{ '(count)' }}</tb>

</tr>

Try this:

$Invoices = Invoices::find([
    "columns" => "id, inv_number, cust, date, status, count(*) as count",
    "group" => "status, date",
    "order" => "date"
]);

Thank you so much!

oooh. I cant get the record from relation model. I need to get rid of "Columns". But I need them to add results of group_Concat and Count(). Is there any solution?

Try this:

        $hydration = new Invoices();
        $table = $hydration->getSource();
        $sql = "select id, inv_number, cust, date, status, count(*) as count from $table group by status, date order by date";
        $invoices = new \Phalcon\Mvc\Model\Resultset\Simple(null, $hydration, $hydration->getReadConnection()->query($sql));

You can always use query builder and make joins and get both full models and group count.