We are using the vizlib write back in front end and the partial load in the scipt as follows.
We need to show the most recent comments enterd by the client but we are getting all comments.
IF IsPartialReload() THEN
Writeback_Comments: Replace only LOAD "Lease ref", text("Lease ref") as MR_Comments_Lease_ID, CreatedBy,CreatedAt FROM [lib://NZ360/QVDs/WIPcomments_MRI_test.qvd] (qvd);
join (Writeback_Comments) Replace only Load
text("Lease ref") as MR_Comments_Lease_ID, FirstSortedValue(Comments,-CreatedAt) as MostRecent_Comments
FROM [lib://NZ360/QVDs/WIPcomments_MRI_test.qvd] (qvd) group by "Lease ref";
else
Writeback_Comments: LOAD "Lease ref", text("Lease ref") as MR_Comments_Lease_ID, CreatedBy,CreatedAt FROM [lib://NZ360/QVDs/WIPcomments_MRI_test.qvd] (qvd);
join (Writeback_Comments) Load
text("Lease ref") as MR_Comments_Lease_ID, FirstSortedValue(Comments,-CreatedAt) as MostRecent_Comments
FROM [lib://NZ360/QVDs/WIPcomments_MRI_test.qvd] (qvd) group by "Lease ref";
