Replies: 1 comment
-
Ive been solve, because 2 both table using the name fields id_users, |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Hi
I am getting following exception on filtering.
SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id_users' in where clause is ambiguous
select count(*) as aggregate from 'lapor_izins' left join 'izins' on 'lapor_izins'.'id_izins' = 'izins'.'id' where 'id_users' = 6
if I comment following column, then filter works perfectly
Column::make("Jenis Izin", "izins.nama_izin")->sortable(),
======
Here is my builder
public function builder(): Builder { return LaporIzin::query() ->where('id_users', auth()->user()->id) ->with(['izins']); }
Please help, thanks
Beta Was this translation helpful? Give feedback.
All reactions