Robert Mann Comments - Answer Overflow

Robert Mann

•Created by Robert Mann on 1/23/2024 in #❓┊help

Space in table between first text column and all the rest of the columns.

@Matthew you were spot on. I moved the resources/views/vendor folder out and ran npm run build and everything is back to normal. Thank you.

10 replies

FFilament

•Created by Robert Mann on 1/23/2024 in #❓┊help

Space in table between first text column and all the rest of the columns.

That is a great place to start I appreciate it. I will report back.

10 replies

FFilament

•Created by Robert Mann on 1/10/2024 in #❓┊help

I am using Laravel Scout with Meilisearch issue with Default Sortting

The following is a way to do it but renders the column sort orders useless if there is something in the search field. I have not put time in to figuring that part out yet but it might be possible to exclude the orderByRaw if there is a column sort order being used. But this works as expected and returns the order exactly how Meilisearch returns the results In the following License is the eloquent class and usi is the ID field sent to Meilisearch.

    protected function applySearchToTableQuery(Builder $query): Builder
    {
        $this->applyColumnSearchesToTableQuery($query);

        if (filled($search = $this->getTableSearch())) {
            $query
                ->whereIn('usi', License::search($search)->keys())
                ->orderByRaw('FIELD(usi, ' . License::search($search)->keys()->join(',') . ') ASC');
        }

        return $query;
    }

    protected function applySearchToTableQuery(Builder $query): Builder
    {
        $this->applyColumnSearchesToTableQuery($query);

        if (filled($search = $this->getTableSearch())) {
            $query
                ->whereIn('usi', License::search($search)->keys())
                ->orderByRaw('FIELD(usi, ' . License::search($search)->keys()->join(',') . ') ASC');
        }

        return $query;
    }

3 replies

FFilament

•Created by Vinny on 8/14/2023 in #❓┊help

Table Builder + Scout: Search Result Order

@Patrick Boivin did you accomplish this with MySQL and if so would you mind sharing your new applySearchToTableQuery function so I don't have to reinvent the wheel?

11 replies

FFilament

•Created by Robert Mann on 12/2/2023 in #❓┊help