Firstsortedvalue in Partial Reload

BI_Dev — Wed, 06 Aug 2025 14:37:20 GMT

I have the below script but it is throwing error - Can FirstSortedValue be included within partial reload ?

App reloads without any error but when I reload from the front end, writeback table (Vizlib) it shows 'Data model out of sync error'.

Writeback_Comments_Tmp:
LOAD Distinct

"ID" &'-'& "Event Type" &'-'& date("Event Date") as Comments_IDKey,

FirstSortedValue(Comments,-num("CreatedAt_56ad3b3b8b024924aad736a339fa507b")) as CDR_Latest_Comments

FROM "Writeback Test.qvd"
(qvd)
group by "ID","Event Type","Event Date";

if IsPartialReload() then
add only Concatenate (Writeback_Comments_Tmp)

"ID" &'-'& "Event Type" &'-'& date("Event Date") as Comments_IDKey,

FirstSortedValue(Comments,-num("CreatedAt_56ad3b3b8b024924aad736a339fa507b")) as CDR_Latest_Comments

FROM "Writeback Test.qvd"
(qvd)
group by "ID","Event Type","Event Date";

end if;

left join Writeback_Comments_Tmp:
LOAD Distinct

"ID" &'-'& "Event Type" &'-'& date("Event Date") as Comments_IDKey,
"ID" AS "CDR WB Lease Option ID" ,

"Event Type",
date("Event Date") AS "Event Date",

Comments

CreatedBy_56ad3b3b8b024924aad736a339fa507b as "Created By",
CreatedAt_56ad3b3b8b024924aad736a339fa507b as "Created Time",
num("CreatedAt_56ad3b3b8b024924aad736a339fa507b") AS "Created Num"

FROM "Writeback Test.qvd"
(qvd)

EXIT SCRIPT;

topic Firstsortedvalue in Partial Reload in App Development

Firstsortedvalue in Partial Reload