Error with join query while exporting selected items

[eafarooqi]

Livewire PowerGrid version

6.1.11

Livewire version

3.5.19

Laravel version

11.41.3

Which PHP version are you using?

PHP 8.2

Which Theme are you using?

Bootstrap 5

Have you published the resource files and customized them? (php artisan vendor:publish)

Yes

What is the problem?

With a complex query as datasource with joins, when exporting selected items you get an ambiguous primary key error. Table name is missing in the where query.

Integrity constraint violation: 1052 Column 'id' in where clause is ambiguous

Code snippets

Any query with relations and joins. code in the related PR #1843

How do you expect it to work?

should export the selected items without error.

Please confirm (incomplete submissions will not be addressed)

• I have provided easy and step-by-step instructions to reproduce the bug.
• I have provided code samples as text and NOT images.
• I understand my bug report will be removed if I haven't met the criteria above.