autorefresh of query when process is run not working(SOLVED)

If you think that something doesn't work in Aware IM post your message here
Post Reply
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

autorefresh of query when process is run not working(SOLVED)

Post by ddumas »

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
Last edited by ddumas on Mon Feb 24, 2020 3:38 pm, edited 1 time in total.
BobK
Posts: 451
Joined: Thu Jan 31, 2008 2:14 pm
Location: Cincinnati, Ohio, USA

Re: auto refresh of a query when a process is run not workin

Post by BobK »

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
Bob
aware_support
Posts: 7191
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: auto refresh of a query when a process is run not workin

Post by aware_support »

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,
Aware IM Support Team
PointsWell
Posts: 991
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: auto refresh of a query when a process is run not workin

Post by PointsWell »

aware_support wrote:In other words, auto-refresh is only sensitive to processes (and objects) started (or edited) by the user explicitly,
And by extension, a sub process does not trigger a refresh even if the min process is user initiated.
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Re: auto refresh of a query when a process is run not workin

Post by ddumas »

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,
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
Posts: 7191
Joined: Sun Apr 24, 2005 12:36 am
Contact:

Re: auto refresh of a query when a process is run not workin

Post by aware_support »

In the Auto-refresh properties you can get the query to refresh every so many seconds
Aware IM Support Team
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Re: auto refresh of a query when a process is run not workin

Post by ddumas »

ok, I will look to see where that setting is...
Thanks.
Dave
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Re: auto refresh of a query when a process is run not workin

Post by ddumas »

sorry, I pulled up auto-refresh properties of the query and see nothing about refresh timing
Rennur
Posts: 1172
Joined: Thu Mar 01, 2012 5:13 am
Location: Sydney, Australia

Re: auto refresh of a query when a process is run not workin

Post by Rennur »

Ver 8.4
Attachments
qar.png
qar.png (131.28 KiB) Viewed 5870 times
ddumas
Posts: 389
Joined: Tue Apr 23, 2013 11:17 pm

Re: auto refresh of a query when a process is run not workin

Post by ddumas »

Thanks!, That option was hidden. I had to pull down the dialog window to see it.
Dave
Post Reply