Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I'm trying to make a direct discovery and it works well on desktop , After i change a number in my database , data in qvw will be refreshed when i reopen it . but it keep unchanged on access point
what should i do?
thx
Few things:
- Check what version of QlikView (including SR) your server is running
- Check the cache time for Direct Discovery. I think this is 30 minutes by default (IIRC), but can be changed with a setting. If this time out is not reached yet, a new query will not be launched against your database.
Few things:
- Check what version of QlikView (including SR) your server is running
- Check the cache time for Direct Discovery. I think this is 30 minutes by default (IIRC), but can be changed with a setting. If this time out is not reached yet, a new query will not be launched against your database.
hey handsome~ thank you very much
maybe you are right , i wait for over half an hour, the number changed
counld you tell me how to set up the cache time ?
This should be the way to set it in your script:
set DirectCacheSeconds = 300;
So the setting is in seconds.
Note that you might not want to set the number TOO low, as the result it is will constantly trigger queries to your database (which might have a negative performance effect on your production system).