Skip to content

The alias doesn't work to filter the added columns (aggregated column here) #1037

@Jiizen

Description

@Jiizen

Hello everyone.

I have a problem with the alias on new column to filter my values.

I have a count in my custom query.

->addSelect('(COUNT(house.cats)) as numberCats')

I add a column as next :

$numberCats = new NumberColumn(
            [
                'id'              => 'numberCats',
// => I WOULD PUT MY ALIAS HERE. Works only if I write select(count()) than previous
                'field'           => '(COUNT(house.cats))', 
                'title'           => 'nb. cats',
                'defaultOperator' => 'eq',
                'operators'       => ['eq', 'neq', 'btwe'],
                'filterable'      => true,
                'export'          => true,
                'groups'          => ["group1", "group2"],
                'isManualField'   => true,
                'isAggregate'     => true,
                'source'          => true,
            ]
        );

I searched in others issues (#473) and I tried with the options :
'isManualField' => true,
'isAggregate' => true,
'source' => true,
but it doesn't work.

It works with the (COUNT(house.cats)) in field, but it's not clean... I have an alias, what a pity to write the same thing.

Would anyone have a solution to use the alias ?

Thank for the help !

Have a nice day.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions