Pivot Table with no PK - Deselecting 'id' from Query

[freshbitsweb]

Pivot Table with no PK - Deselecting 'id' from Query

[gauravmak]

I will need to check this.

[gauravmak]

I haven't put pivot table data in Datatables before.

Are you trying to get the pivot data directly? i.e. Using the model of the pivot table to prepare the datatables data? Or fetching the many to many relationship from a model?

[ervansanjaya]

I haven't put pivot table data in Datatables before.

Are you trying to get the pivot data directly? i.e. Using the model of the pivot table to prepare the datatables data? Or fetching the many to many relationship from a model?

Thank you for your response @gauravmak

I tried both of it.

1. Using the model of pivot table, it requires to have ID on the pivot table, while I didn't have one.

2. Using the many to many relationship, I'm having issue on accessing my extra attribute in my pivot table, i tried using() + withPivot('extraAttributeColumnName') but it said property extraAttributeColumnName doesn't exist.

My example data is I have two many-to-many table items and users and it has item_user that contains quantity, and two referencing foreign key to items and users.

I want to be able to display in my datatable as such:

User Name | Item Name | Quantity

[gauravmak]

You can treat quantity as a custom column.

Then, you can use laratablesQueryConditions() to load the relation.

[ervansanjaya]

You can treat quantity as a custom column.

Then, you can use laratablesQueryConditions() to load the relation.

But how about the issue I have which is the query keep selecting ID of my pivot table when it actually didn't have one?

I only

columns: [
                { title: 'Use Name', name: 'user.name' },
]

But it keeps selecting 'id' of item_user table.

[ervansanjaya]

Thank you so much @gauravmak

[ervansanjaya]

@gauravmak I ended up 'faking' my $primaryKey attribute on my pivot model to finally able to show my desired output. So I just named my pivot table's primary key with one column name of the referencing key, and voila, it's all solved.

But I'm hoping that this will be fixed soon (if it's actually a bug).

Thank you.

[gauravmak]

Ervan,

My example data is I have two many-to-many table items and users and it has item_user that contains quantity, and two referencing foreign key to items and users.

I want to be able to display in my datatable as such:

User Name | Item Name | Quantity

I didn't get how you want to display the data here. A user can have multiple items. You need to customize the value to maybe display them comma-separated or something. Example -

    /**
     * Returns comma-separated name for the datatables.
     *
     * @return string
     */
    public function laratablesItemsName()
    {
        return $this->items->pluck('name')->implode(', ');
    }

I just tried that and it worked for me. Reply if you're still facing any issues.