[Vantage 8.03.409c] Starting activity on multiple operations sim

Yahoo Archive
1
Disregard. I think that I got it working. In case anyone needs it in the future, the logic that I used was:

..........

number of rows in the below query is more than 0

for each LaborDtl where ( LaborDtl.ActiveTrans = TRUE) no-lock , each LaborHed where ( LaborHed.LaborHedSeq = '%LaborHedSeq%' ) and (LaborDtl.Company = LaborHed.Company and LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq) no-lock

..........

Seems to be working, so far, but haven't had a lot of time to test it, yet.

--- In vantage@yahoogroups.com, "jeppersn" <jepperson@...> wrote:
>
> I am trying to create a BPM that displays an informational message each time a shop employee attempts to start activity on multiple labor operations simultaneously. Basically, as long as they currently have no active LaborDtl records tied to their LaborHed, the message will not display, but when they have one or more "true" LaborDtl.ActiveTrans fields, they message will display.
>
> I have tried multiple methods, including changes to the ttLaborDtl field, as well as: "Number of rows in this query are more than 0:
>
> for each LaborDtl where (LaborDtl.ActiveTrans = TRUE ) no-lock , last LaborHed where ( LaborHed.EmployeeNum = CurrentEmployeeID ) and (LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq )"
>
> But I can't seem to get the BPM to work correctly. It will either display at the wrong time or not at all.
>
> I'm sure this is a simple BPM for most of you, but it's the first that I have attempted.
>
> Any ideas?
>
2
I am trying to create a BPM that displays an informational message each time a shop employee attempts to start activity on multiple labor operations simultaneously. Basically, as long as they currently have no active LaborDtl records tied to their LaborHed, the message will not display, but when they have one or more "true" LaborDtl.ActiveTrans fields, they message will display.

I have tried multiple methods, including changes to the ttLaborDtl field, as well as: "Number of rows in this query are more than 0:

for each LaborDtl where (LaborDtl.ActiveTrans = TRUE ) no-lock , last LaborHed where ( LaborHed.EmployeeNum = CurrentEmployeeID ) and (LaborDtl.LaborHedSeq = LaborHed.LaborHedSeq )"

But I can't seem to get the BPM to work correctly. It will either display at the wrong time or not at all.

I'm sure this is a simple BPM for most of you, but it's the first that I have attempted.

Any ideas?