Well problem solved. Actually, I had the same problem twice with slightly different circumstances.
First case: If the partplant.costmethod equals the input record partplant.costmethod, then take the No branch. Problem was that if either of the partplant records matched, then the workflow followed the No branch. The solution was to add a test for the input partplant.plant value equals the partplant.plant value, then "and" it to the first test. The total result of the test worked.
Second case: If there is a quantity on hand, take the No branch. The recordset returns two warehouses, one with qty, the other without. It seemed that depending on which order they are in, you could get a different result. The solution was to use the Sum functiod for the nodeset PartOnHandWhse.QuantityOnHand, and then test the sum != 0. The xpath test must be first, with the default being last.
Thanks for everyone's input.
Jim Pratt
First case: If the partplant.costmethod equals the input record partplant.costmethod, then take the No branch. Problem was that if either of the partplant records matched, then the workflow followed the No branch. The solution was to add a test for the input partplant.plant value equals the partplant.plant value, then "and" it to the first test. The total result of the test worked.
Second case: If there is a quantity on hand, take the No branch. The recordset returns two warehouses, one with qty, the other without. It seemed that depending on which order they are in, you could get a different result. The solution was to use the Sum functiod for the nodeset PartOnHandWhse.QuantityOnHand, and then test the sum != 0. The xpath test must be first, with the default being last.
Thanks for everyone's input.
Jim Pratt
--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> I know everyone hates the subroutine answer, but that may get it done.
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of jmpratt7
> Sent: Tuesday, June 16, 2009 1:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Service Connect Choice Functoid
>
>
>
>
>
> That service returns the cost in dollars. It is not related to the
> costmethod on the part and partplant tables.
>
> Thanks,
>
> Jim
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "bw2868bond" <bwalker@> wrote:
> >
> > Did you try using PartCostSearch and the GetByID method?
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "jmpratt7" <james.pratt@> wrote:
> > >
> > > Hi all,
> > >
> > > I have a workflow that can update cost method (among other items),
> so I check to see if the input partplant.costmethod is the same or
> different than than the record stored in the database to determine if I
> actually want to update the value for this record. The problem is the
> recordset returns two partplant records one for each of my two plants
> where one matches and the other doesn't. The choice function sees one
> match and throws the choice the wrong way.
> > >
> > > I seem to remember someone talking about this behavior during the
> Service Connect webex, but I don't remember the details. Anyone know
> what I'm talking about and have a direction for me?
> > >
> > > Thanks,
> > >
> > > Jim Pratt
> > >
> > > Vantage 8.03.404B
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>