What version of Origam are you using: 2025.10.14038
I was trying to use a filter set with multiple filters
I was expecting to get a working DB script
Instead I’ve got a script with multiple issues like parameter declaration with “:“ (should be without) and its assignment with “=“ only (should be “:=“).
The interesting thing is that when not using parameters of Timestamp type, it works even when not correctly scripted but with dates it fails.
Here is declaration documentation.
Generated incorrect script:
-- SQL statements for data structure: Allotment
DO $$
DECLARE :Allotment_parDateFrom Timestamp;
DECLARE :Allotment_parDateTo Timestamp;
DECLARE :Allotment_parService_Id Uuid;
BEGIN
:Allotment_parDateTo = NULL;
:Allotment_parDateFrom = NULL;
:Allotment_parService_Id = NULL;
CREATE TEMP TABLE “tmptable23eca626-a6d6-4d4e-960d-3dad82bc0305” ON COMMIT DROP AS
– Allotment
SELECT
“Allotment”.“Service_Id” AS “Service_Id”,
“Allotment”.“Date” AS “Date”,
“Allotment”.“ServiceBlockStatus_Id” AS “ServiceBlockStatus_Id”,
“Allotment”.“RecordCreated” AS “RecordCreated”,
“Allotment”.“RecordUpdatedBy” AS “RecordUpdatedBy”,
“Allotment”.“Id” AS “Id”,
“Allotment”.“RecordCreatedBy” AS “RecordCreatedBy”,
“Allotment”.“RecordUpdated” AS “RecordUpdated”
FROM
“Allotment” AS “Allotment”
WHERE (
(“Allotment”.“Date” BETWEEN Allotment_parDateFrom AND Allotment_parDateTo) AND
(“Allotment”.“Service_Id” = Allotment_parService_Id));
END $$;
SELECT * FROM “tmptable23eca626-a6d6-4d4e-960d-3dad82bc0305”;