I tried to include a printscreen, but couldn't, but yes - in the trace I
see two order releases (an existing and my new one) and the existing
release has nothing in the Rowmod fields but gets SellingReqQty updated
anyway.
I'll try the link condition though I'm already doing a similar thing by
testing for SellingReqQty=0.
see two order releases (an existing and my new one) and the existing
release has nothing in the Rowmod fields but gets SellingReqQty updated
anyway.
I'll try the link condition though I'm already doing a similar thing by
testing for SellingReqQty=0.
--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> So when you call the update method in the workflow, other records in
the database are changed? even though the trace shows the rowmod's as
blank? (the field in the trace will be changed but the actual record in
the db should not be touched....)
>
> I would not consider that correct functioning of the product.
>
> You could maybe try a link condition - (right click on the right hand
side of the link) condition is RowMod = A
>
> --- In vantage@yahoogroups.com, "wapnerj" jwapner@ wrote:
> >
> >
> > That's how I thought it would work - only the records with rowmod =
'A
> > 'would update. But the SellingReqQty in my existing order releases
is
> > getting updated as well.
> >
> > I believe what others are suggesting is correct - that I have to go
to
> > another subworkflow. I'm already one subflow level deep (each of my
> > spreadsheet rows is being handled as a subflow) and was hoping to
avoid
> > the extra complexity.
> >
> > This is another case where the trace really doesn't give you the
full of
> > idea of how Vantage is handling things.
> >
> >
> > --- In vantage@yahoogroups.com, "bw2868bond" <bwalker@> wrote:
> > >
> > > Once you have called the 'GetNew' request, the returned dataset
has
> > only one record that has the RowMod value of 'A' ?
> > >
> > > map your incoming values to the appropriate fields. When you call
the
> > Update Method, ony the row with RowMod 'A' will update - all the
other
> > RowMod values should be blank
> > >
> > > test you workflow without calling the Update Method and examine
the
> > Rows in the document tracking screen for the last conversion before
you
> > would call the update....
> > >
> > > --- In vantage@yahoogroups.com, "wapnerj" jwapner@ wrote:
> > > >
> > > > I'm using Service Connect to try to add Order Releases calling
the
> > GetNewOrderRel method. This returns a dataset which include ALL
existing
> > order releases (one would think that it might just include the newly
> > created order release).
> > > >
> > > > I'm trying to use a conditional functoid to update SellingReqQty
> > from my customer's EDI file if SellingReqQty is zero (presuming that
> > zero means it's the new record added by GetNewOrderRel).
> > > >
> > > > My dataset would look something like this
> > > >
> > > > NeedByDate SellingReqQty What to do
> > > > 6/1/9 115 Existing Order Rel (leave as is)
> > > > 6/7/9 0 New Order Rel (update with cust qty)
> > > >
> > > > It seems as if the conditional functoid is not working. I
believe
> > that someone in the recent Service Connect session said that
conditional
> > functoids don't work with multiple records (it returns true for all
of
> > the records if one record is true). Can someone confirm that?
> > > >
> > > > Thanks,
> > > >
> > > > John Wapner
> > > > Bracalente Mfg.
> > > >
> > >
> >
>