Hi Roger,
How do I refresh the table in the filter before I perform the workflow?
My mind's drawing a blank.
Thanks,
Derek
Roger Justice wrote:
**
Yes I have done table loops with a filter and yes you have to do a
refresh table as part of the work flow.
Roger
-----Original Message-----
From: [EMAIL PROTECTED]
To: [email protected]
Sent: Mon, 23 Apr 2007 12:29 PM
Subject: Table Looping in a filter
Hi listers,
I am trying to loop though a table in a filter. First, is this even
possible? (I haven't done anything like this before)
I am trying to count the number of times something shows up in a
table, however, it is not working. This is how I have set it up
1) I have a filter that fires on submit/modify of the form that the
table is on:
a) sets up some counters (outboundmessagecount = 0, loopcount = 1).
b) Calls a filter guide with a Table Loop on the table I want to
loop though.
2) The Filter Guide calls one filter (below)
3) Filter that loops through the table: Loops though the table if
columnName = "Outbound" AND loopcount < 3 (*I want to see if the first
2 rows of the table are "Outbound" messages* *- this is the end goal
of doing this - I want an integer value with this number*).
a) If Action - outboundmessagecount = outboundmessagecount + 1
loopcount = loopcount + 1
b) Else Action - loopcount = loopcount + 1
All I get is loopcount = 2 and outboundmessagecount = 0 , so the If
Action never fires. Is this because the table has to be refreshed
before it can "read" from the table? How do you do this from a filter?
Help.
Thanks,
Derek
-- Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta T2N 1N4
403.210.9879
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
<http://www.arslist.org/> ARSlist:"Where the Answers Are"
------------------------------------------------------------------------
AOL now offers free email to everyone. Find out more about what's free
from AOL at *AOL.com* <http://www.aol.com?ncid=AOLAOF00020000000437>.
__20060125_______________________This posting was submitted with HTML
in it___
--
Derek Fernandes
Programmer Analyst
U of C Information Technologies
ES 1010, University of Calgary
Calgary, Alberta T2N 1N4
403.210.9879
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
