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 <[email protected]>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 <[email protected]> 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 <[email protected]>
>> To: arslist <[email protected]>
>> 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"
