Service Connect - sort or minimum issue

Thanks Dan,



I have some more pressing issues, but I will check into this when I can.



Karen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Dan Godfrey
Sent: Wednesday, September 09, 2009 10:25 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Service Connect - sort or minimum issue





Karen and Mark,

It is possible to receive muiltiple responses out of a sub-workflow.
I create my own return schema. I also make sure that the input schema
of the following conversion is my return schema and that I have
Multiplicity set to Multiple. I also have to make sure that all
possible exits of my sub-workflow returns my return schema.

Dan

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of spence_mk1
Sent: Tuesday, September 08, 2009 12:30 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Service Connect - sort or minimum issue

Karen,
There is the response object from your subworkflow, but be careful as
the data here is overwritten with each iteration through the
subworkflow.

The most reliable way I have found to do this is writing the data I want
out to a "temp table". In this case the temp table is one of the UD
tables in Vantage. Just add one of the UD## webservices to Service
Connect (be sure it isn't one you are doing something with in Vantage).
When you are in your subworkflow, write out your relevant data to the
UD## table and then retrieve it in the parent workflow. The best part of
using the UD tables is it is more reliable, takes all the data into
account (the subworkflow reponse resets every time and is only reliable
for the last run through the workflow), and allows for things like
running sums or group sums, or even your min and max. Good luck.

Mark D. Spencer

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"karen_schoenung" <kschoenung@...> wrote:
>
> Hi,
>
> I have the need to use a subworkflow to cycle through a dataset with
several "child" records, returning the data from the child record with
the earliest date.
>
> I can cycle through, I can save the date to the USR area, but I can't
seem to return it to the higher workflow for comparison against the
previous date found from the last cycle.
>
> Can anyone help? Or do you have any suggestions for another way to go
about this task?
>
> Thanks in advance,
> Karen
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
Hi,

I have the need to use a subworkflow to cycle through a dataset with several "child" records, returning the data from the child record with the earliest date.

I can cycle through, I can save the date to the USR area, but I can't seem to return it to the higher workflow for comparison against the previous date found from the last cycle.

Can anyone help? Or do you have any suggestions for another way to go about this task?

Thanks in advance,
Karen
Karen,
There is the response object from your subworkflow, but be careful as the data here is overwritten with each iteration through the subworkflow.

The most reliable way I have found to do this is writing the data I want out to a "temp table". In this case the temp table is one of the UD tables in Vantage. Just add one of the UD## webservices to Service Connect (be sure it isn't one you are doing something with in Vantage). When you are in your subworkflow, write out your relevant data to the UD## table and then retrieve it in the parent workflow. The best part of using the UD tables is it is more reliable, takes all the data into account (the subworkflow reponse resets every time and is only reliable for the last run through the workflow), and allows for things like running sums or group sums, or even your min and max. Good luck.

Mark D. Spencer

--- In vantage@yahoogroups.com, "karen_schoenung" <kschoenung@...> wrote:
>
> Hi,
>
> I have the need to use a subworkflow to cycle through a dataset with several "child" records, returning the data from the child record with the earliest date.
>
> I can cycle through, I can save the date to the USR area, but I can't seem to return it to the higher workflow for comparison against the previous date found from the last cycle.
>
> Can anyone help? Or do you have any suggestions for another way to go about this task?
>
> Thanks in advance,
> Karen
>
Thanks Mark, I will look into this possibility!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of spence_mk1
Sent: Tuesday, September 08, 2009 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect - sort or minimum issue





Karen,
There is the response object from your subworkflow, but be careful as
the data here is overwritten with each iteration through the
subworkflow.

The most reliable way I have found to do this is writing the data I want
out to a "temp table". In this case the temp table is one of the UD
tables in Vantage. Just add one of the UD## webservices to Service
Connect (be sure it isn't one you are doing something with in Vantage).
When you are in your subworkflow, write out your relevant data to the
UD## table and then retrieve it in the parent workflow. The best part of
using the UD tables is it is more reliable, takes all the data into
account (the subworkflow reponse resets every time and is only reliable
for the last run through the workflow), and allows for things like
running sums or group sums, or even your min and max. Good luck.

Mark D. Spencer

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"karen_schoenung" <kschoenung@...> wrote:
>
> Hi,
>
> I have the need to use a subworkflow to cycle through a dataset with
several "child" records, returning the data from the child record with
the earliest date.
>
> I can cycle through, I can save the date to the USR area, but I can't
seem to return it to the higher workflow for comparison against the
previous date found from the last cycle.
>
> Can anyone help? Or do you have any suggestions for another way to go
about this task?
>
> Thanks in advance,
> Karen
>





[Non-text portions of this message have been removed]
Karen and Mark,

It is possible to receive muiltiple responses out of a sub-workflow.
I create my own return schema. I also make sure that the input schema
of the following conversion is my return schema and that I have
Multiplicity set to Multiple. I also have to make sure that all
possible exits of my sub-workflow returns my return schema.

Dan

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of spence_mk1
Sent: Tuesday, September 08, 2009 12:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect - sort or minimum issue




Karen,
There is the response object from your subworkflow, but be careful as
the data here is overwritten with each iteration through the
subworkflow.

The most reliable way I have found to do this is writing the data I want
out to a "temp table". In this case the temp table is one of the UD
tables in Vantage. Just add one of the UD## webservices to Service
Connect (be sure it isn't one you are doing something with in Vantage).
When you are in your subworkflow, write out your relevant data to the
UD## table and then retrieve it in the parent workflow. The best part of
using the UD tables is it is more reliable, takes all the data into
account (the subworkflow reponse resets every time and is only reliable
for the last run through the workflow), and allows for things like
running sums or group sums, or even your min and max. Good luck.

Mark D. Spencer

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"karen_schoenung" <kschoenung@...> wrote:
>
> Hi,
>
> I have the need to use a subworkflow to cycle through a dataset with
several "child" records, returning the data from the child record with
the earliest date.
>
> I can cycle through, I can save the date to the USR area, but I can't
seem to return it to the higher workflow for comparison against the
previous date found from the last cycle.
>
> Can anyone help? Or do you have any suggestions for another way to go
about this task?
>
> Thanks in advance,
> Karen
>






[Non-text portions of this message have been removed]