Pulling Job Released Date into a query

Correct. And that is what happens with the BPM. It updates the JobHead.Date01 and JobHead.Date02.
Here is the ABL code using the Labor.Update.Pre-Processing method:

FOR EACH ttLaborDtl where ttlabordtl.RowMod="U" NO-LOCK:
FIND FIRST JobHead WHERE JobHead.Company = ttLaborDtl.Company AND JobHead.JobNum = ttLaborDtl.JobNum NO-ERROR.
IF AVAILABLE JobHead THEN DO:
Assign JobHead.Date01 = ttLaborDtl.ClockInDate . /*Last Labor*/
IF Jobhead.Date02 = ? then
Assign JobHead.Date02 = ttlabordtl.ClockInDate . /*First Labor*/
END.
END.

Basically spends no time at all.


Charlie Smith
ESSNER Manufacturing, L.P.
6651 Will Rogers Blvd.
Fort Worth, TX 76140
csmith@...<mailto:csmith@...>
ph: (817) 529-6165
fx: (817) 568-2625
[LOGO_Essner_Manufacturing]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 26, 2015 2:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Pulling Job Released Date into a query.



Are you able to make assumptions about the first and last labor that you can use to filter? For me to save the last labor date to the job header, I'd have to update a field with the current date every time more labor was added.



[Non-text portions of this message have been removed]

Hello,


Have a quick search setup, but would like to pull in all jobs based on the released date.  I see that date for released jobs in available in the change log, but would like to pull it into a quick search prompt.

'

Thanks.

Probably use a BAQ search rather than a quick search.

Charlie Smith
ESSNER Manufacturing, L.P.
6651 Will Rogers Blvd.
Fort Worth, TX 76140
csmith@...<mailto:csmith@...>
ph: (817) 529-6165
fx: (817) 568-2625
[LOGO_Essner_Manufacturing]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, March 25, 2015 4:14 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Pulling Job Released Date into a query.



Hello,



Have a quick search setup, but would like to pull in all jobs based on the released date. I see that date for released jobs in available in the change log, but would like to pull it into a quick search prompt.

'

Thanks.



[Non-text portions of this message have been removed]
Charles, 

Thanks for the response.  The quick search does use a BAQ.   So, I'm assuming the only way to get the Release Date is to parse the Change log for that text based on the job?
I wrote a BPM that populates JobHead.Datexx when the Released box is checked. Then it was usable in BAQs. I have also added First and Last Labor dates to the job header using BPMs.
So in essence in the job header I have the Required By, Scheduled Start, Scheduled Due, Released Date, First Labor, Last Labor, Completed and Closed Dates.

Charlie Smith
ESSNER Manufacturing, L.P.
6651 Will Rogers Blvd.
Fort Worth, TX 76140
csmith@...<mailto:csmith@...>
ph: (817) 529-6165
fx: (817) 568-2625
[LOGO_Essner_Manufacturing]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 26, 2015 9:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Pulling Job Released Date into a query.



Charles,

Thanks for the response. The quick search does use a BAQ. So, I'm assuming the only way to get the Release Date is to parse the Change log for that text based on the job?



[Non-text portions of this message have been removed]
Charlie, do those BPMs fire every time a labor detail is added to a job? Does it not slow down time entry?
No slowdown. The first and last labor update from MES/labor entry without a problem.
The system currently records the last labor on an operational basis but these people are so used to seeing it on a job basis that I had to add it to the header. Since I was adding the last labor I figured I would add the first labor as well.

Charlie Smith
ESSNER Manufacturing, L.P.
6651 Will Rogers Blvd.
Fort Worth, TX 76140
csmith@...<mailto:csmith@...>
ph: (817) 529-6165
fx: (817) 568-2625
[LOGO_Essner_Manufacturing]

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, March 26, 2015 10:46 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Pulling Job Released Date into a query.



Charlie, do those BPMs fire every time a labor detail is added to a job? Does it not slow down time entry?



[Non-text portions of this message have been removed]
Are you able to make assumptions about the first and last labor that you can use to filter? For me to save the last labor date to the job header, I'd have to update a field with the current date every time more labor was added.