topic Re: Partial Reload by Hour of Day in App Development

Partial Reload by Hour of Day

m_perreault — Thu, 02 Aug 2018 16:34:18 GMT

Hi All,

My script has two sections which each read from a different datasource

Section 1:

Takes 10 minutes and the data is only updated once a day (overnight)

Section 2:

Takes 1 minute and updates hourly.

I'd like to set a reload task to reload this app once every hour but after a certain time of day say 7 am, I only want to reload Section 2 because Section 1 is static.

Does anyone have any ideas on how to accomplish this.

Thanks!
Mark

Re: Partial Reload by Hour of Day

juraj_misina — Fri, 03 Aug 2018 10:34:36 GMT

Hi Mark,

in your script set up a condition to navigate script execution to corresponding section. Something like:

If(Hour(Now()<7) then
//section one
Else
//section two
EndIf

Hope this helps.

Juraj

Re: Partial Reload by Hour of Day

m_perreault — Fri, 03 Aug 2018 13:12:55 GMT

Thanks Juraj however wouldn't this mean that after 7 the data from Section 1 will no longer be in the application? I only want to load Section 2 after 7 but I still want all the data from Section 1 to remain.

Thanks,

Mark

Re: Partial Reload by Hour of Day

juraj_misina — Fri, 03 Aug 2018 14:22:19 GMT

Hi Mark,

in that case store results of section 1 into QVD files and load those QVD files in section two.

Juraj

Re: Partial Reload by Hour of Day

dapostolopoylos — Fri, 03 Aug 2018 14:26:22 GMT

Try:

LOAD

FROM

Section1;

IF (Hour(Now()>7) THEN

LOAD

FROM

Section2;

ENDIF;

Re: Partial Reload by Hour of Day

m_perreault — Fri, 03 Aug 2018 14:50:58 GMT

That's the route I think I am going to take thanks Juraj