Just for fun I ran a log to see if my theory is correct. These two (MS) SQL statements were issued right after the Call Guide was issued.
SELECT COUNT(*) FROM T1296 WHERE ((T1296.C536870915 = 'Application Accounts') AND (T1296.C536870916 = 0) AND ('ID9C2B20524153EZ5ZTQv6PtoAFVUV' = T1296.C600017002) AND ((T1296.C536870914 LIKE '%%' ) OR (0 != 0)) AND (T1296.C600010001 IS NOT NULL)) ORDER BY 1 ASC SELECT TOP 1001 T1296.C1,C536870914,C600010101 FROM T1296 WHERE ((T1296.C536870915 = 'Application Accounts') AND (T1296.C536870916 = 0) AND ('ID9C2B20524153EZ5ZTQv6PtoAFVUV' = T1296.C600017002) AND ((T1296.C536870914 LIKE '%%' ) OR (0 != 0)) AND (T1296.C600010001 IS NOT NULL)) ORDER BY C536870914 ASC, 1 ASC I thought the *LIKE '%%'* was kind of odd until I looked at the table field qualification: ('Menu Name' = "Application Accounts") AND ('Status-Resource' = "Active") AND ($GUID$ = 'Parent Request ID-WARDD') AND (('Menu Item' LIKE (("%" + $SystemSearch$) + "%")) OR ($SystemSearch$ = " ")) AND ('chkSelectedAccount-WARDD' != $NULL$) The table field works with a character field to limit results based on a keyword, purely for UI purposes. I use the same UI table field in the filter loop. According to my theory it makes complete sense but never thought about it in this context and I didn't consider it when I build the table field query. Jason On Sun, Mar 13, 2011 at 8:37 PM, Jason Miller <jason.mil...@gmail.com>wrote: > It almost sounds like she has a table field but referring to it as a just a > table and back end table is the form the table field is referencing. The > way I am reading it she already has the filter guide firing but it is not > looping how she expects. > > If this is the case, and you are using all ARS functionality (table field > vs. back end SQL table directly), there is no need to refresh the table > field in a filter guide/loop. ARS is smart enough to know how to handle > it. A table field is more or less a UI component. The ability to do filter > loops was added later (version 6.0 I think) and my belief is ARS uses the > table field definition to build the SQL query to get the record set for a > filter guide loop. > > Please describe the issue you are experiencing so we can better help you. > > My wild guess is that you are doing a push fields with the data in the > table field and may need to override filter phasing with *`!* at the end > of the filter name. Just a guess with what little we have to work with. > > Jason > > > On Sun, Mar 13, 2011 at 3:55 PM, Roger Justice <rjust2...@aol.com> wrote: > >> ** >> Please explain better what you are doing. >> >> If you are using email to update an ARS table directly you cannot fire a >> filter since this is an API call. You could try an Escalation if you can >> determine a timing that would work. >> >> >> >> -----Original Message----- >> From: Mary Estrada <mestr...@blizzard.com> >> To: arslist <arslist@ARSLIST.ORG> >> Sent: Sun, Mar 13, 2011 6:49 pm >> Subject: Urgent please help! how to refresh table using filters >> >> Thanks in advance. >> >> Having email update a back end table, then call filter guide to check data in >> columns in table. >> Need to refresh the table before filter call guide to loop thru all rows. >> >> Thanks, >> >> ~Mary >> >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"