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;
