I have created custom table in metabase i need to connect with my main filter Widget it was showing error
Error: A text variable in this card can only be connected to a text filter with Is operator.
This is my code
SELECT
"INV"."INVENTORY"."MATERIAL_CODE_DESCRIPTION" AS "MATERIAL_CODE_DESCRIPTION",
"INV"."INVENTORY"."UOM" AS "UOM",
"INV"."INVENTORY"."MATERIAL_IN_OUT" AS "MATERIAL_IN_OUT",
"INV"."INVENTORY"."QTY_CONSUMED_REFILLED" AS "QTY_CONSUMED_REFILLED",
"INV"."INVENTORY"."ASSET_GROUP_CODE" AS "ASSET_GROUP_CODE",
"INV"."INVENTORY"."MONTH" AS "MONTH",
"INV"."INVENTORY"."POS_REF_ID" AS "POS_REF_ID",
"INV"."INVENTORY"."POS_SUBGROUP_ID" AS "POS_SUBGROUP_ID",
"INV"."INVENTORY"."NEW_CATEGORY_LEVEL_1" AS "NEW_CATEGORY_LEVEL_1", -- Added comma here
SUM(
CASE
WHEN "INV"."INVENTORY"."MATERIAL_IN_OUT" = 'IN' THEN "INV"."INVENTORY"."QTY_CONSUMED_REFILLED"
ELSE 0
END
) AS "ADJUSTED_QTY_IN",
SUM(
CASE
WHEN "INV"."INVENTORY"."MATERIAL_IN_OUT" = 'OUT' THEN "INV"."INVENTORY"."QTY_CONSUMED_REFILLED"
ELSE 0
END
) AS "ADJUSTED_QTY_OUT",
SUM(
CASE
WHEN "INV"."INVENTORY"."MATERIAL_IN_OUT" = 'IN' THEN "INV"."INVENTORY"."QTY_CONSUMED_REFILLED"
ELSE 0
END
) - SUM(
CASE
WHEN "INV"."INVENTORY"."MATERIAL_IN_OUT" = 'OUT' THEN "INV"."INVENTORY"."QTY_CONSUMED_REFILLED"
ELSE 0
END
) AS "Material Available"
FROM
"PARAM"."INV"."INVENTORY"
WHERE
"INV"."INVENTORY"."NEW_CATEGORY_LEVEL_1" = 'Consumables'
GROUP BY
"INV"."INVENTORY"."MATERIAL_CODE_DESCRIPTION",
"INV"."INVENTORY"."UOM",
"INV"."INVENTORY"."NEW_CATEGORY_LEVEL_1",
"INV"."INVENTORY"."MATERIAL_IN_OUT", -- Added to GROUP BY
"INV"."INVENTORY"."QTY_CONSUMED_REFILLED", -- Added to GROUP BY
"INV"."INVENTORY"."ASSET_GROUP_CODE", -- Added to GROUP BY
"INV"."INVENTORY"."MONTH", -- Added to GROUP BY
"INV"."INVENTORY"."POS_REF_ID", -- Added to GROUP BY
"INV"."INVENTORY"."POS_SUBGROUP_ID" -- Added to GROUP BY
LIMIT
1048575;
