Error While Fetching data from related field query..
Hey I am having a Widget Table which is related to ShopifyProduct table and i can see a column shop in shopifyProduct table which has shopId's.
Now I want to fetch the widget data filter by shopId.
I followed the instruction from the documentation, maybe I am doing something wrong.
https://docs.gadget.dev/api/videoselz/development/sorting-and-filtering#filtering-across-belongsto-and-hasone-relationships
The query I am using->
await api.Widget.findMany({
filter: {
product: {
shopId: { equals: "shopId" }, // Filter for shopId
},
},
select: {
product: {
id: true,
shopId: true,
},
},
});
With this query I am always getting error as Field "shopId" is not defined by type "IDFilter"."
I tried with "shop", "shopifyShop" too but the result is same.
widget table has column named "product" which is related to ShopifyProduct.
Now I want to fetch the widget data filter by shopId.
I followed the instruction from the documentation, maybe I am doing something wrong.
https://docs.gadget.dev/api/videoselz/development/sorting-and-filtering#filtering-across-belongsto-and-hasone-relationships
The query I am using->
await api.Widget.findMany({
filter: {
product: {
shopId: { equals: "shopId" }, // Filter for shopId
},
},
select: {
product: {
id: true,
shopId: true,
},
},
});
With this query I am always getting error as Field "shopId" is not defined by type "IDFilter"."
I tried with "shop", "shopifyShop" too but the result is same.
widget table has column named "product" which is related to ShopifyProduct.
