How to filter options in a select2_grouped field based on webshop_id?

[ceeckhout]

Hi,

I’ve created a select2_grouped field in my Backpack CRUD:

CRUD::field('most_sold_product_1_id')
    ->label('Meest verkocht product 1')
    ->type('select2_grouped')
    ->entity('most_sold_product_1') // Method defining the relationship in the Model
    ->attribute('title')
    ->group_by('sub_categories') // Relationship to the grouping entity
    ->group_by_attribute('title') // Attribute to show for the group
    ->group_by_relationship_back('products') // Relationship back to this model
    ->wrapper(['class' => 'form-group col-md-6']);

Now, I need to filter the products shown in the dropdown, so it only displays products where webshop_id = $this->webshopId.

I’ve successfully implemented a filter for a simple select field like this:

CRUD::field('parent_cat')
    ->attribute('title')
    ->label('Categorie')
    ->options(function ($query) {
        return $query->where('webshop_id', $this->webshopId)
            ->where('active', 1)
            ->orderBy('title', 'ASC')
            ->get();
    });

However, I’m not sure how to apply a similar filter to a select2_grouped field. Is there a way to achieve this?

Thanks in advance for your help!

[backpack-ai-bot[bot]]

To filter options in a select2_grouped field based on webshop_id, you can use the options attribute similar to how you did it for the simple select field. Here's how you can modify your select2_grouped field to include the filter:

CRUD::field('most_sold_product_1_id')
    ->label('Meest verkocht product 1')
    ->type('select2_grouped')
    ->entity('most_sold_product_1')
    ->attribute('title')
    ->group_by('sub_categories')
    ->group_by_attribute('title')
    ->group_by_relationship_back('products')
    ->options(function ($query) {
        return $query->where('webshop_id', $this->webshopId)
            ->where('active', 1)
            ->orderBy('title', 'ASC')
            ->get();
    })
    ->wrapper(['class' => 'form-group col-md-6']);

This approach should filter the products shown in the dropdown to only display products where webshop_id matches $this->webshopId and are active, ordered by title in ascending order.

However, it's important to note that the options method for select2_grouped fields is not explicitly documented in the provided knowledge sources. If this approach doesn't work as expected, you might need to consider alternative solutions.

One such alternative could be to create a custom model that includes the filtering logic, as suggested in the How to filter the options in a select field documentation. You could create a new model that extends your original model and includes a global scope for the webshop_id filter, then use this new model in your select2_grouped field.

If you encounter any issues or need further assistance, I recommend reaching out to the Backpack community or consulting the official documentation for the most up-to-date information on handling complex filtering scenarios with select2_grouped fields.

ℹ️ Please note our AI Bot does not reply to follow-ups, this will be the only AI answer in this thread. If the AI helped you find the answer, please mark it as answered or write details below so it can learn. Then close the conversation. If not, please give more information for when a human reads this. ℹ️

Relevant sources:

Github Issue (closed): Add a scope to Select2
Fields|select2_grouped PRO
Github Issue (closed): Select(2) for grouped options
FAQs for CRUDs|How to filter the options in a select field
Filters PRO|Examples
[Feature][3.5][Ready] Select2 grouped
Bugfix "select2 grouped" not working
Github Issue (closed): How to add filtering clauses to the create/update drop downs in forms?
Github Issue (closed): filter by pivot table
CRUD Fluent API|Examples Part 3
Github Issue (closed): [Feature Request]Add a filter to an ajax relationship Field request
Github Issue (closed): [Field Type] addClause on select, select2, select_multiple, select2_multiple, checklist, checklist_dependency

[ceeckhout]

Unfortunately, this did not work with options in select2_grouped, but ultimately, based on the additional information, a good solution was found with static::addGlobalScope() in the model.

[ceeckhout]

Fixed with static::addGlobalScope() in the model

[jcastroa87]

Hello @ceeckhout I'm glad you make this work, and thanks for sharing the way to do it.

I will close this issue, but please feel free to re-open or create a new one if needed.

Cheers.