Reload and store QVD with Partial Reload

Asuod_ — Thu, 10 Aug 2023 22:25:10 GMT

Hi,

I have a QVD that i am trying to change using a partial reload button on the dashboard. So when they hit the partial reload button it load the QVD data into a temp table then perform an ORDER BY and gives a row number then stores it back into the QVD. Ive tried Replace Only Load and Replace Load, none seem to have an affect. The script works when i reload normally but the partial load is giving me issue. Any help is appreciated.

Simple partial load Script im using:

IF IsPartialReload() THEN

drop Table Data;

End If;

Temp:

Replace Load

Priority,

Total_Score,

id,

FROM QVD

(qvd);

Data:

Replace Load

RowNo() as Ranking,

if( Priority< 1,'', RowNo()) as Leadership Priority,

Total_Score,

id,

Resident Temp Order By Priority asc, Total_Score desc;

drop table Temp;

Store Data into QVD

topic Reload and store QVD with Partial Reload in App Development

Reload and store QVD with Partial Reload