Notify Engineer for the First Job of a New Part

[hkeric.wci (Haso Keric)]

@Asz0ka

image829×589 29.7 KB

Dont join on ttTables.

E10 BPM Slow due to Join?

[image]

Joining "TT" records to regular DB records in BPMs

I re-wrote the BPM making sure to make ttTable the first and to drag the arrow from tt to the actual table [image] The LINQ (Code behind generated looks like this) private bool C001_QuerySizeCondition() { var query = from dbQuery in ( from rowABCCode in this.Db.ABCCode where ((rowABCCode.Company == null || rowABCCode.Company == "" || rowABCCode.Company == (this.Session…