SQL View CSV/JSON/XML Refresh Rate

Hello there DHIS2

How often are the download links through the api refreshed for sqlviews? Is this an option we can manipulate?

Thanks!

More info

If I go to an sqlviews GUI page the query always seems to be rerun:

/dhis/dhis-web-maintenance-dataadmin/exportSqlView.action?id=SQLVIEWID

If I go to the api download page it goes with the first run of the query:

dhis/api/sqlViews/UID/data.csv
rather than rerunning each time.

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623

Hi Tim,

Are you sure the second part of your question is not cache related?

Regards,

Jason

···

On Mar 18, 2015 11:48 PM, “Timothy Harding” hardingt@gmail.com wrote:

Hello there DHIS2

How often are the download links through the api refreshed for sqlviews? Is this an option we can manipulate?

Thanks!

More info

If I go to an sqlviews GUI page the query always seems to be rerun:

/dhis/dhis-web-maintenance-dataadmin/exportSqlView.action?id=SQLVIEWID

If I go to the api download page it goes with the first run of the query:

dhis/api/sqlViews/UID/data.csv
rather than rerunning each time.

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Yes sir indeed!

I’ve tried with multiple machines, multiple browsers, and in incognito mode, it will always download the CSV file instantaneously and reflects the same data as the first time the query was run. The GUI will show an updated view and reruns every time, but the download never seems to refresh, or refreshes on a timer.

···

On Wed, Mar 18, 2015 at 9:43 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Tim,

Are you sure the second part of your question is not cache related?

Regards,

Jason

On Mar 18, 2015 11:48 PM, “Timothy Harding” hardingt@gmail.com wrote:

Hello there DHIS2

How often are the download links through the api refreshed for sqlviews? Is this an option we can manipulate?

Thanks!

More info

If I go to an sqlviews GUI page the query always seems to be rerun:

/dhis/dhis-web-maintenance-dataadmin/exportSqlView.action?id=SQLVIEWID

If I go to the api download page it goes with the first run of the query:

dhis/api/sqlViews/UID/data.csv
rather than rerunning each time.

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623

Hi Tim,
Can you provide temporary access to the system in question so that I can have a look at it?

Regards,

Jason

···

On Thu, Mar 19, 2015 at 6:24 AM, Timothy Harding hardingt@gmail.com wrote:

Yes sir indeed!

I’ve tried with multiple machines, multiple browsers, and in incognito mode, it will always download the CSV file instantaneously and reflects the same data as the first time the query was run. The GUI will show an updated view and reruns every time, but the download never seems to refresh, or refreshes on a timer.

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623

On Wed, Mar 18, 2015 at 9:43 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Tim,

Are you sure the second part of your question is not cache related?

Regards,

Jason

On Mar 18, 2015 11:48 PM, “Timothy Harding” hardingt@gmail.com wrote:

Hello there DHIS2

How often are the download links through the api refreshed for sqlviews? Is this an option we can manipulate?

Thanks!

More info

If I go to an sqlviews GUI page the query always seems to be rerun:

/dhis/dhis-web-maintenance-dataadmin/exportSqlView.action?id=SQLVIEWID

If I go to the api download page it goes with the first run of the query:

dhis/api/sqlViews/UID/data.csv
rather than rerunning each time.

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Hi Tim,

the SQL views follow the standard setting for caching which you can find under apps > settings > general > cache strategy. By default, data output responses are cached until next morning. You can disable it completely if you like. It could be that you have a server-side cache where the sql view response sits. A default sql view is not “materialized” so it should return fresh data every time.

Unfortunately, the setting applies to all analytical output like pivots and maps as well. We might want to split this into multiple settings, or even down to the individual sql view.

regards,

Lars

···

On Thu, Mar 19, 2015 at 6:26 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Tim,
Can you provide temporary access to the system in question so that I can have a look at it?

Regards,

Jason


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Thu, Mar 19, 2015 at 6:24 AM, Timothy Harding hardingt@gmail.com wrote:

Yes sir indeed!

I’ve tried with multiple machines, multiple browsers, and in incognito mode, it will always download the CSV file instantaneously and reflects the same data as the first time the query was run. The GUI will show an updated view and reruns every time, but the download never seems to refresh, or refreshes on a timer.

Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623

On Wed, Mar 18, 2015 at 9:43 PM, Jason Pickering jason.p.pickering@gmail.com wrote:

Hi Tim,

Are you sure the second part of your question is not cache related?

Regards,

Jason

On Mar 18, 2015 11:48 PM, “Timothy Harding” hardingt@gmail.com wrote:

Hello there DHIS2

How often are the download links through the api refreshed for sqlviews? Is this an option we can manipulate?

Thanks!

More info

If I go to an sqlviews GUI page the query always seems to be rerun:

/dhis/dhis-web-maintenance-dataadmin/exportSqlView.action?id=SQLVIEWID

If I go to the api download page it goes with the first run of the query:

dhis/api/sqlViews/UID/data.csv
rather than rerunning each time.

Timothy Harding

RPCV Vanuatu

Skype: hardingt@gmail.com

+1 (541) 632-6623


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp