Add table name on edit page query

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

Here I use scope to fetch product for that types,
The

id

id

Ambiguous issue is occur while try to edit and view the individual product,
Is there any way to add table name on where

id

id

clause on filament to fetch individual record.
like

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "products.id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "products.id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

Filament•2y ago•

1 reply

Asmit

Add table name on edit page query

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

Here I use scope to fetch product for that types,
The

id

id

Ambiguous issue is occur while try to edit and view the individual product,
Is there any way to add table name on where

id

id

clause on filament to fetch individual record.
like

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "products.id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

select
  "products".*
from
  "products"
  inner join "categories" on "products"."category_id" = "categories"."id"
where
  "products.id" = 8
  and "categories"."type_id" = 1
  and "products"."deleted_at" is null
limit
  1

Add table name on edit page query

Similar Threads

Add table name on edit page query

Similar Threads

Similar Threads

Similar Threads