Filter get all data from DB instead of unique values

[jigapate]

Hello,

I have enabled filters,

    public function filters(): array
    {
        return [
            Filter::select('asset_symbol')
            ->dataSource(LiveFuture::all())
            ->optionLabel('asset_symbol')
            ->optionValue('asset_symbol'),
        ];
    }

But with this, it is getting all values from the table, instead of unique values, How to keep unique values only for the filter?

[marineusde]

I got this solution. it show the distinct of the second table and just elements are used in your first table:

    public function datasource(): null|QueryBuilder|EloquentBuilder
    {
        return FirstTable::query()
            ->select([
                'first_table.*',
                'second_table.test'
            ])
            ->leftJoin('second_table', 'second_table.id', 'second_table.first_table_id');
    }
    
    public function filters(): array
    {
        $testSource = $this->datasource()
            ->select(['second_table.test'])
            ->distinct()
            ->orderBy('second_table.test')
            ->get();

        return [
            Filter::select('test')
                ->dataSource($testSource)
                ->optionValue('test')
                ->optionLabel('test')
        ];
    }

[jigapate]

Why we need second table for filter?

[marineusde]

cause it filters the "no needed values". example:

second_table got the entrys "one", "two" and "three"
first_table just got connections to "one" and "two", "three" is not used

In my excample, the user cant filter with "three", cause he dont got a result.

But if you dont need it, maybe this helps:

    public function filters(): array
    {
        return [
            Filter::select('name', 'name')
                ->dataSource(LiveFuture::select('asset_symbol')->distinct()->orderBy('asset_symbol')->get())
                ->optionValue('name')
                ->optionLabel('name')
        ];
    }