ambiguous column name: id

Hello, I have an exporter on my User relation manager. sometimes when I export, it fails with the following error:

General error: 1 ambiguous column name: id (Connection: sqlite, SQL:

General error: 1 ambiguous column name: id (Connection: sqlite, SQL:

 select distinct "users"."id" from "users" inner join "course_user" on "users"."id" = "course_user"."user_id" where "course_user"."course_id" = 1 order by "users"."id" asc, "id" asc limit 1000)

 select distinct "users"."id" from "users" inner join "course_user" on "users"."id" = "course_user"."user_id" where "course_user"."course_id" = 1 order by "users"."id" asc, "id" asc limit 1000)

Solution

I couldn't figure out how to change the query on the exporter to change the order by clause, so I removed the normal exportAction entirely and kept only the bulkAction which doesn't attempt to sort the results

Jump to solution

Filament•2y ago•

4 replies

dotdotdot

ambiguous column name: id

Hello, I have an exporter on my User relation manager. sometimes when I export, it fails with the following error:

General error: 1 ambiguous column name: id (Connection: sqlite, SQL:

General error: 1 ambiguous column name: id (Connection: sqlite, SQL:

 select distinct "users"."id" from "users" inner join "course_user" on "users"."id" = "course_user"."user_id" where "course_user"."course_id" = 1 order by "users"."id" asc, "id" asc limit 1000)

 select distinct "users"."id" from "users" inner join "course_user" on "users"."id" = "course_user"."user_id" where "course_user"."course_id" = 1 order by "users"."id" asc, "id" asc limit 1000)

Solution

Jump to solution

ambiguous column name: id

ambiguous column name: id

Similar Threads

Similar Threads

Similar Threads