Skip to content

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

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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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