how to display withCount in table?

[tarikhagustia]

Hello,
i have following query

public function builder(): Builder
    {
        return ContactList::query()
            ->withCount('contacts')
            ->where('user_id', auth()->id()); // Select some things
    }

but when adding this line on column, this error appear

SQLSTATE[42703]: Undefined column: 7 ERROR: column contact_lists.contacts_count does not exist

how can i display contacts_count ?

[giles247]

Try this
Column::make('Contacts Count') ->label(function ($row) { return $row->contacts_count; }),

[tarikhagustia]

thanks, its work!

[DanielGSoftware]

@redactuk works, but I wonder how you'd make this work when you also want to use search/enable? 😄

[giles247]

@DanielGSoftware Can't help you with that. I use this package in one project under long-term development, and since move to v2 pretty much all my previous methods of enabling search/sort are broken. I believe there is a least one PR related to broken sorting, so until some further fixes get done on this package I've not bothered to try and get examples like this to work for search/sort.

[DanielGSoftware]

Hmm I get that, we decided to upgrade to v2 one week ago. A lot of problems are arising during the process, and some functionality just doesn't work exist/work anymore, which I wonder why. Now I'm wondering if we should just stay at v1 for now as well.