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 < [email protected]> wrote: > 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 <[email protected]> > 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: [email protected] >> +1 (541) 632-6623 >> >> On Wed, Mar 18, 2015 at 9:43 PM, Jason Pickering < >> [email protected]> 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" <[email protected]> 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: [email protected] >>>> +1 (541) 632-6623 >>>> >>>> _______________________________________________ >>>> Mailing list: https://launchpad.net/~dhis2-devs >>>> Post to : [email protected] >>>> Unsubscribe : https://launchpad.net/~dhis2-devs >>>> More help : https://help.launchpad.net/ListHelp >>>> >>>> >> > > > -- > Jason P. Pickering > email: [email protected] > tel:+46764147049 > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
