Pass a field from a foreign table which is in an array relationship to the filter in useList hook ?
const query = useList<IOrganization>({
resource: "organizations",
metaData: {
fields: ["id", { organization_units: ["id", "active"] }],
},
config: {
filters: [
{
field: "organization_units.active",
operator: "eq",
value: true,
},
],
},
});
here organization_units table is in foreign relationship with organization table. I need to access the active field of the organization_units table.
resource: "organizations",
metaData: {
fields: ["id", { organization_units: ["id", "active"] }],
},
config: {
filters: [
{
field: "organization_units.active",
operator: "eq",
value: true,
},
],
},
});
here organization_units table is in foreign relationship with organization table. I need to access the active field of the organization_units table.
