I have a Query that is tagged to auto-refresh (refresh properties for the query) when a particular process (EXEC_SP stored proc) is run. The query is not refreshing. The process has indeed run. I check in the database, and the record which the query is based on has changed with the new values.
So, I expect the query to "refresh" itself based on the auto-refresh rules set as above.
As proof, when I click on the AIM refresh button above the query, and it refreshes the data correctly.
So, I believe this is a bug.
Dave
autorefresh of query when process is run not working(SOLVED)
autorefresh of query when process is run not working(SOLVED)
Last edited by ddumas on Mon Feb 24, 2020 3:38 pm, edited 1 time in total.
Re: auto refresh of a query when a process is run not workin
If your process is running by the scheduler, it is a limitation.
See the last few entries in posting
http://www.awareim.com/forum/viewtopic.php?t=4836
See the last few entries in posting
http://www.awareim.com/forum/viewtopic.php?t=4836
Bob
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: auto refresh of a query when a process is run not workin
Not just scheduling. If a process is started by rules, it will not cause auto-refresh either.
In other words, auto-refresh is only sensitive to processes (and objects) started (or edited) by the user explicitly,
In other words, auto-refresh is only sensitive to processes (and objects) started (or edited) by the user explicitly,
Aware IM Support Team
-
- Posts: 1471
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: auto refresh of a query when a process is run not workin
And by extension, a sub process does not trigger a refresh even if the min process is user initiated.aware_support wrote:In other words, auto-refresh is only sensitive to processes (and objects) started (or edited) by the user explicitly,
Re: auto refresh of a query when a process is run not workin
The auto-refresh rules allow you to select processes that will trigger auto-refresh. So it sounds like this may be a good opportunity to fix this, so that it works. As a stop gap, is there any "Refresh Query xxx" action that I can add to the process, or something that will actually trigger the query to refresh? Ex There is a refresh button for the query that works, so sounds like the code is already built and we just need a refresh action to call it.aware_support wrote:Not just scheduling. If a process is started by rules, it will not cause auto-refresh either.
In other words, auto-refresh is only sensitive to processes (and objects) started (or edited) by the user explicitly,
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: auto refresh of a query when a process is run not workin
In the Auto-refresh properties you can get the query to refresh every so many seconds
Aware IM Support Team
Re: auto refresh of a query when a process is run not workin
ok, I will look to see where that setting is...
Thanks.
Dave
Thanks.
Dave
Re: auto refresh of a query when a process is run not workin
sorry, I pulled up auto-refresh properties of the query and see nothing about refresh timing
Re: auto refresh of a query when a process is run not workin
Ver 8.4
- Attachments
-
- qar.png (131.28 KiB) Viewed 18964 times
Re: auto refresh of a query when a process is run not workin
Thanks!, That option was hidden. I had to pull down the dialog window to see it.
Dave
Dave