I realize that there is an older posting from back in 2018, but I’m wondering if there was ever an update or work around that anyone found.
I’m trying to create a BAQ that shows what open jobs were scheduled with the finite check box checked (finite) or if the job was scheduled without it checked (infinite).
It would seem like a simple true/false baq, but I can’t find the binding for that check box as it isn’t an available table. Has anyone recently found a work around since the 2018 posting?
I don’t think it’s getting stored in the DB anywhere. It looks like it’s a parameter (name: Finite) getting passed in the MoveJobItem method on the ScheduleEngine BO. You might be able to write a BPM to store that parameter in a UD field then call it in your BAQ from there.
I ended up trying a calculated field. It seems to do the job as far as I can tell.
case
when count(ResourceTimeUsed.SysRowID) > 0 then ‘Finite’
when sum(case when JobOper.StartDate is not null then 1 else 0 end) > 0 then ‘Infinite’
else ‘Unscheduled’
end
