I have created some custom fields in the Engineering Workbench to hold such data as Furnace temps; Metal Temp target, Mold temp target, etc. which can vary based on the Revision of the Item number.
Upon creating a new Job; I want to reach into the ECORev table and extract the data from those fields and display in the Job Entry Screen on the Revision tab. If those fields are empty in the ECORev table, I want to fire a BPM to alert Document Control that the required data is missing.
I’ve tried creating a FKV and STV, and am able to pull in the PartNumber, Revision Number, but nothing from my “Number01”; “Number02” fields, etc.
Any suggestions, thoughts, or different ideas on how to go about this?
At the time of job creation wouldn’t you want to get the data from PartRev? You can have multiple ECORev records for each PartRev.
If I am going down the PartRev path, then on post processing of JobEntry.GetDetails I would use ABL code like below.
For the alert you can do a BAM for a Jobhead record released with those fields empty. With a BAM .p you can gather any other data you need for the email.
Greg
/* set fields from partRev */
Message " IN POST JOB GET DETAILS ".
for each ttJobHead where ttJobHEad.JobReleased:
for each PartRev where JobHead.partNum = PartRev.PartNum and JobHead.Company = PartRev.Company:
Assign ttJobHead.Field = PartRev.Field.
END.
END.
You are right … I need to go down the PartRev path.
Thank you for the reply … I am not very savvy with ABL code and this question may sound fairly naive, but is that the only code needed to do the check?
The edited code is to copy the fields from PartRev to the Jobhead for the display.
Is the alert to document control a message or an email?
A info message can be done in the same abl code. If you want an email alert I would do in a BAM with an additional alert procedure. I have samples of the BAM procedures you can use to get started.
I did a simple BAM on JobHead with the JobReleased = True. In the BAM check for your fields in the If CheckBox16 = True. You can add a find for the PartRev record and email what is correct or missing from the data.
Alert procedures are run from your servers Server\ud directory
