← Back to team overview

dhis2-devs team mailing list archive

Re: SQL View CSV/JSON/XML Refresh Rate

 

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@xxxxxxxxx> 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@xxxxxxxxx
> +1 (541) 632-6623
>
> On Wed, Mar 18, 2015 at 9:43 PM, Jason Pickering <
> jason.p.pickering@xxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxx
>>> +1 (541) 632-6623
>>>
>>> _______________________________________________
>>> Mailing list: https://launchpad.net/~dhis2-devs
>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049

Follow ups

References