Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
this is my script :
Binary "\\ukbraa06\Source Documents\QVD\QVD Monitor\QVD_Monitor.qvw";
QVD_legend:
LOAD
rowno() as Leg_QvdId,
QvdShortFileName as Leg_QvdShortFileName,
QvdDesc as Leg_QvdDesc,
QvdReloadFreq as Leg_QvdReloadFreq,
QvdReloadFreq_In_Days as Leg_QvdReloadFreq_In_Days
RESIDENT Qvd_Params
WHERE BSC = 'Y';
LEFT JOIN(QVD_legend)
LOAD
QvdShortFileName as Leg_QvdShortFileName,
QvdCreateDate as Leg_QvdCreateDate
RESIDENT Qvd_Info;
LEFT JOIN(QVD_legend)
LOAD
QvdShortFileName as Leg_QvdShortFileName,
QvdMaxDate as Leg_QvdMaxDate
RESIDENT QVDmaxdate;
LEFT JOIN(QVD_legend)
LOAD
Leg_QvdShortFileName,
Num(Today() - date(Leg_QvdReloadFreq_In_Days + Leg_QvdCreateDate)) as Leg_QvdDelay,
if(Num(Today() - date(Leg_QvdReloadFreq_In_Days + Leg_QvdCreateDate))<=0,0,1) as Leg_QvdIsLate
RESIDENT QVD_legend;
Hi Palla,
Your QvdShortFileName field doesn't exist in the Qvd_Info table of your QVD_Monitor.qvw app.
Review the QVD_Monitor.qvw data model, you should find the right field to use.
Hope that helps you,
Martin Favier
Hi,
Your Qvd_Info doesn't Contain the Field QvdShortFileName .Check QVD .
Regards,
Divya
Thanks For all ,problem solved
So,
Could you mark the post as "answered' please ? thx
Martin Favier