Thank you Lyle and Tim.. It is working now.
Thanks again for your help.
Brandi
|------------>
| From: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|Lyle Taylor <tayl...@ldschurch.org>
|
>----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|arslist@ARSLIST.ORG
|
>----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|05/28/2009 06:43 PM
|
>----------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>----------------------------------------------------------------------------------------------------------------------------------------|
|Re: Walking through table - server side, maybe?
|
>----------------------------------------------------------------------------------------------------------------------------------------|
I don't think I understand what you mean by setting the table field to n
+10000000. Are you trying to set the qualification for the table field?
If so, an easy way around that would be to add a display only field to
the form (let's say "Table Qualification" and then define the table so
that it's qualification is "EXTERNAL($Table Qualification$)" (without
the quotes). You would then have your filter set the qualification
field with the correct qualification, and then you could iterate over
the table.
Or am I completely missing what you're trying to do here?
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:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: 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"
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"
