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"
