Anyone building BPM's with queries?

Yahoo Archive
1
danisrow, I could kiss you. I've been working on a BPM for a month
now, and what you've just given me was the key to the puzzle. Thank you!

--- In vantage@yahoogroups.com, "dansirow" <dansirow@...> wrote:
>
>
> I have done many of these to add edits that I think are needed.
>
> For example, Sales Order allows the Order Quantity to be changed to an
> amount less than the quantity already shipped, so I added the following
> query:
>
> for each ttorderdtl where ttorderdtl.RowMod = 'U' and
> ttorderdtl.orderQty < ttorderdtl.TotalShipped
>
> if the number of rows in the query is not less than 1 - raise an
> exception
>
>
> --- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@> wrote:
> >
> > I'm trying to create a BPM that raises an alert to the client whenever
> > someone adds an item from an order that has been placed on hold.
> >
> > I'm applying it to the CustShip object and the GetOrderInfo directive,
> > however there are no static fields to check within it, so it appears
> my
> > only method of checking that order hold status is to use a query.
> >
> > However.. I have no idea what tables or values I need to be checking
> > for the query to work let alone what format the language needs to be
> in.
> >
> > So, I throw this out there in case anyone else has done this or would
> > like to work with me on adding this functionality for held orders.
> >
>
2
I'm trying to create a BPM that raises an alert to the client whenever
someone adds an item from an order that has been placed on hold.

I'm applying it to the CustShip object and the GetOrderInfo directive,
however there are no static fields to check within it, so it appears my
only method of checking that order hold status is to use a query.

However.. I have no idea what tables or values I need to be checking
for the query to work let alone what format the language needs to be in.

So, I throw this out there in case anyone else has done this or would
like to work with me on adding this functionality for held orders.
3
I got it figured out.. it nicely prompts the user when they pull in any
order that's currently on hold into a customer shipment.

--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...> wrote:
>
> I'm trying to create a BPM that raises an alert to the client
whenever
> someone adds an item from an order that has been placed on hold.
>
> I'm applying it to the CustShip object and the GetOrderInfo
directive,
> however there are no static fields to check within it, so it appears
my
> only method of checking that order hold status is to use a query.
>
> However.. I have no idea what tables or values I need to be checking
> for the query to work let alone what format the language needs to be
in.
>
> So, I throw this out there in case anyone else has done this or would
> like to work with me on adding this functionality for held orders.
>
4
Out of curiosity, what did your query look like?


--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...> wrote:
>
> I got it figured out.. it nicely prompts the user when they pull in any
> order that's currently on hold into a customer shipment.
>
> --- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@> wrote:
> >
> > I'm trying to create a BPM that raises an alert to the client
> whenever
> > someone adds an item from an order that has been placed on hold.
> >
> > I'm applying it to the CustShip object and the GetOrderInfo
> directive,
> > however there are no static fields to check within it, so it appears
> my
> > only method of checking that order hold status is to use a query.
> >
> > However.. I have no idea what tables or values I need to be checking
> > for the query to work let alone what format the language needs to be
> in.
> >
> > So, I throw this out there in case anyone else has done this or would
> > like to work with me on adding this functionality for held orders.
> >
>
5
I added a Post-Process on CustShip.GetOrderInfo.

My condition was "number of rows in query is more than 0"
The actual query was:
for each OrderHed where OrderHed.OrderHeld = 'yes' and
OrderHed.OrderNum = '%orderNum%'

My action was:
show informational message based on template - and the template was
below:
Order (<orderNum/>) just added to the packing slip is currently on
hold.

You MUST check with sales/finance before shipping this item.

--- In vantage@yahoogroups.com, "laidig.systems" <laidig.systems@...>
wrote:
>
> Out of curiosity, what did your query look like?
>
>
> --- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@> wrote:
> >
> > I got it figured out.. it nicely prompts the user when they pull
in any
> > order that's currently on hold into a customer shipment.
> >
> > --- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@>
wrote:
> > >
> > > I'm trying to create a BPM that raises an alert to the client
> > whenever
> > > someone adds an item from an order that has been placed on hold.
> > >
> > > I'm applying it to the CustShip object and the GetOrderInfo
> > directive,
> > > however there are no static fields to check within it, so it
appears
> > my
> > > only method of checking that order hold status is to use a
query.
> > >
> > > However.. I have no idea what tables or values I need to be
checking
> > > for the query to work let alone what format the language needs
to be
> > in.
> > >
> > > So, I throw this out there in case anyone else has done this or
would
> > > like to work with me on adding this functionality for held
orders.
> > >
> >
>
6
I have done many of these to add edits that I think are needed.

For example, Sales Order allows the Order Quantity to be changed to an
amount less than the quantity already shipped, so I added the following
query:

for each ttorderdtl where ttorderdtl.RowMod = 'U' and
ttorderdtl.orderQty < ttorderdtl.TotalShipped

if the number of rows in the query is not less than 1 - raise an
exception


--- In vantage@yahoogroups.com, "Patrick Parker" <pbparker@...> wrote:
>
> I'm trying to create a BPM that raises an alert to the client whenever
> someone adds an item from an order that has been placed on hold.
>
> I'm applying it to the CustShip object and the GetOrderInfo directive,
> however there are no static fields to check within it, so it appears
my
> only method of checking that order hold status is to use a query.
>
> However.. I have no idea what tables or values I need to be checking
> for the query to work let alone what format the language needs to be
in.
>
> So, I throw this out there in case anyone else has done this or would
> like to work with me on adding this functionality for held orders.
>