OK, Thank to both of you for the early answer! Let's create another service!
Jose Manuel Huerta http://theremedyforit.com/ On Fri, Aug 10, 2012 at 3:03 PM, Shellman, David <[email protected]>wrote: > Jose, > > I do similar things. However for me to get the process to work, I do a > table loop in the first form. This table loop pushes values to a second > form which contains the second table that I need to loop through. The > results from here are pushed to a third form where they are aggregated. > > A little bit of a kludge but it works. > > Dave > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of Longwing, LJ CTR MDA/IC > Sent: Friday, August 10, 2012 8:34 AM > To: [email protected] > Subject: Re: Tables, filters and refreshing > > Jose, > I myself have also experienced the situation that you are describing. The > only solution I have found is to go with direct sql for count/sum/etc type > of things to get the information I need because, as you describe, there is > no 'table refresh' on filters. Another option that may work is to make the > entire thing a service action, meaning within a service action set the > parentID to Entry ID, then loop...and then return the results in your > output, then do the next one... > > -----Original Message----- > From: Action Request System discussion list(ARSList) [mailto: > [email protected]] On Behalf Of Jose Manuel Huerta Guillén > Sent: Friday, August 10, 2012 5:54 AM > To: [email protected] > Subject: Tables, filters and refreshing > > ** Hi, > > I have a table in a form that is used to compute some aggregated funtion. > I use it inside a loop in a guide. So I check this value several times > during execution. The content of the table changes, but not the fields used > at the table qualification. The strange behavior is that ARS only computes > the value at the first iteration, so the value is not correct for second or > next executions. > > To be more clear: > > I have a table with a qualification: 'ParentID' = $Entry ID$ > > Then I have a guide with the next filters: > > Label: Loop > > Filter 1: SET > I use a field of the table and compute the MAX. > > Filter 2: CALL SERVICE > I call a service that changes values at the database > > Filter 3: If some condition is meet GOTO Loop. > > > Looking at the log I see that the first time Filter 1 is executed, a > SELECT is sent to the database, so the MAX value is retrieved correctly. > Then the service executes and I can see the SQL going to the database with > INSERTS and UPDATES followed by a COMMIT WORK. So the Database is correctly > updated. > > But next time Filter 1 is called, no SELECT to the database is done (seems > that the Server has some kind of Cache and thoughts that the database > hasn't changed) > > > Well, the question: Is there any process command that forces a refresh on > table on filter side? > > Regards, > > Jose Manuel Huerta > http://theremedyforit.com/ > > > _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
