JobOper Complete Date - Email found in subject

The LaborDtl record has the job number, but how to I first check to see if JobOper.Date20 exists, and if it doesn't update it when the LaborDtl record is created?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Scott Litzau
Sent: Tuesday, March 09, 2010 8:20 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] JobOper Complete Date - Email found in subject



Look at LaborDtl Table.

Ken Williams wrote:
> We're trying to capture the date an operation is marked complete. We've been successful in other job related areas (Job Released for instance) with BPM actions based on code that looks like:
>
> for each ttJobHead where ttJobHead.RowMod = 'U'.
> assign ttJobHead.Date20 = TODAY.
> end.
>
> We use similar code for three other processes and it works great. Our condition for the one above is simply ttJobHead.Released field has been changed from false to true.
>
> We want to mimic this behavior when someone marks an operation complete to grab the date completed. Following tracelogs, it appears perhaps this isn't as straight forward. There seems to be no time that the JobOper table is updated when jobbing out - though it obviously is at some point.
>
> My question is, does anyone know the process called when jobbing out that updates the JobOper table?
>
> Thanks for any insight,
> Ken
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.<http://groups.yahoo.com/group/vantage/files/>
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>



[Non-text portions of this message have been removed]
We're trying to capture the date an operation is marked complete. We've been successful in other job related areas (Job Released for instance) with BPM actions based on code that looks like:

for each ttJobHead where ttJobHead.RowMod = 'U'.
assign ttJobHead.Date20 = TODAY.
end.

We use similar code for three other processes and it works great. Our condition for the one above is simply ttJobHead.Released field has been changed from false to true.

We want to mimic this behavior when someone marks an operation complete to grab the date completed. Following tracelogs, it appears perhaps this isn't as straight forward. There seems to be no time that the JobOper table is updated when jobbing out - though it obviously is at some point.

My question is, does anyone know the process called when jobbing out that updates the JobOper table?

Thanks for any insight,
Ken


[Non-text portions of this message have been removed]
Look at LaborDtl Table.

Ken Williams wrote:
> We're trying to capture the date an operation is marked complete. We've been successful in other job related areas (Job Released for instance) with BPM actions based on code that looks like:
>
> for each ttJobHead where ttJobHead.RowMod = 'U'.
> assign ttJobHead.Date20 = TODAY.
> end.
>
> We use similar code for three other processes and it works great. Our condition for the one above is simply ttJobHead.Released field has been changed from false to true.
>
> We want to mimic this behavior when someone marks an operation complete to grab the date completed. Following tracelogs, it appears perhaps this isn't as straight forward. There seems to be no time that the JobOper table is updated when jobbing out - though it obviously is at some point.
>
> My question is, does anyone know the process called when jobbing out that updates the JobOper table?
>
> Thanks for any insight,
> Ken
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
>