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

Claudiagfx · February 28, 2020, 5:46pm

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

utaylor · February 28, 2020, 5:49pm

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).

jgiese.wci · February 28, 2020, 6:13pm

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

utaylor · February 28, 2020, 7:13pm

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