Is there a way to query what jobnumber is active on screen by user?

I’m trying to find a way to query what job number is user logged into and is active on the screen.

There is a table called LaborDtl. Find the rows where LaborDtl.ActiveTrans = 1 (true). Then return LaborDtl.JobNum. You can also see the assembly and operation. I believe that will give you those jobs that are punched into. You can join empbasic on labor dtl to get the full employee record (name, address, etc).

If you have access to it use Shop Vision under Executive Analysis and Trackers.

2 Likes

Nice, there is that too! Forgot about that one! @jgiese.wci

Thank you both, very helpful : )