Brandi,
Check the Workflow Objects Guide for 7.1, p. 222. You can see that old kludgy
notation was replaced by the Table Loop feature in the Call Guide action. See
page 114 for details on the Call Guide action for active links and filters.
Looping over a table works pretty much the same on the client as it does on the
server, except that when you do it in an active link, you can restrict the
action to only those rows that are selected. Of course that wouldn't make
sense in a filter.
--Tim
________________________________
From: Brandi Barbour <barbour.bra...@epamail.epa.gov>
To: arslist@ARSLIST.ORG
Sent: Thursday, May 28, 2009 5:32:05 PM
Subject: Re: [ARSLIST] Walking through table - server side, maybe?
To do that would I not need to set the Table Field = n+10000000, when I
do a set fields on the filter the "Table Field" does not appear in the
available fields?
Thanks,
Brandi,
|------------>
| From: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|Lyle Taylor <tayl...@ldschurch.org>
|
>----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|arslist@ARSLIST.ORG
|
>----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|05/28/2009 06:20 PM
|
>----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|Re: Walking through table - server side, maybe?
|
>----------------------------------------------------------------------------------------------------------------------------------------|
You can do the same thing with a filter guide to loop over the table
with filters performing the actions on each record, essentially just
list you did with the active links.
Lyle
-----Original Message-----
From: Action Request System discussion list(ARSList) [
mailto:arsl...@arslist.org] On Behalf Of Brandi Barbour
Sent: Thursday, May 28, 2009 4:17 PM
To: arslist@ARSLIST.ORG
Subject: Walking through table - server side, maybe?
All,
Happy Thursday.
I am hoping that there is an easy solution for a problem I am having.
We are on ARS 7.1, SQL 2005, Window 2003.
I have a view form created to look at an external table. There is an
escalation that runs that pushes the "main" record from the view form to
a mid form. In this mid form I have a table that does a look back at
the view form to see what other "Child" tickets exist in that external
form.
For example in the external table
The columns look something like this:
Account Number, Order Number, Label for temp field, and value for temp
field, along with about 20 other fields.
There will then be anywhere between 1 - 12 rows for each Account
Number/Order Number combination with the only fields changed being the
"Label for temp field" and "Value for temp field"
So we need all the rows for the combination of Account Number and Order
Number to be combined into 1 record within the mid form.
We have created a table walk scenario with Active Links to be able to
populate each row into its own Temp fields 1-12. However, this is not
going to work because we need this action to occur through a filter on
the server side instead of client side.
Any ideas how to do this? I hope I am making this way more difficult
then needed.
Thanks for your help.
Brandi
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged information.
Any unauthorized review, use, disclosure or distribution is prohibited.
If you are not the intended recipient, please contact the sender by
reply email and destroy all copies of the original message.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers
Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
