Checkbox attribute

[musumbidenis]

I have noticed that PowerGrid's uses the "id" attribute to fetch selected rows. How can I change that to my table's primary key such that I can export data for selected rows only

[dansysanalyst]

Hi @musumbidenis,

You must specify the primary key, read more here and set your "id" in the showCheckBox method.

The documentation needs some clarification on this.

For example, I have created a database table restaurants with the id restaurant_id.

        Schema::create('restaurants', function (Blueprint $table) {
            $table->id('restaurant_id');
            $table->string('name');
            $table->timestamps();
        });

This is how my PowerGrid table looks like:

<?php

final class RestaurantTable extends PowerGridComponent
{
    use ActionButton;

    public string $primaryKey = 'restaurants.restaurant_id';
    public string $sortField = 'restaurants.restaurant_id';

    public function setUp(): array
    {
        $this->showCheckBox('restaurant_id');

//....

[musumbidenis]

Thank you so much it worked fine