Forum Discussion
Helper IIDelay Queries
To my knowledge it is not possible to let one query start after another one has finished. As it is not possible to influence the order of queries. So the options you have are:
1) make the Function.InvokeAfter-time long enough plus some buffer
2) allocate your queries into 2 different folders and manually start the refresh of the 1st one and then start the refresh of the other ones manually again
3) Always refresh twice (this would only work if the data doesn't change in between)
Community ChampionTo my knowledge it is not possible to let one query start after another one has finished. As it is not possible to influence the order of queries. So the options you have are:
1) make the Function.InvokeAfter-time long enough plus some buffer
2) allocate your queries into 2 different folders and manually start the refresh of the 1st one and then start the refresh of the other ones manually again
3) Always refresh twice (this would only work if the data doesn't change in between)
hmokkapatiHello Imke,
I think i will go with the first option for now with enough buffer.
Thanks for your response. Appreciate your time.
Thank You,
Harisha
- hmokkapati
Hello Imke,
As a second thought, even if we have queries in different folders and decide to refresh each folder separately how can I achieve the same once the file is published to the Online Service? Any pointers?
Thank You,
Harisha
- ImkeF
Sorry, no - this is not my field.