Glen,
The simplest way to find that data is to use the EXISTS() function in SQL. Something like this:
exists(select 1 from joblabor where jobplan.jobplanid = joblabor.jobplanid)
... should return any Job Plan that has at least one Planned Labor record from the Job Plans application.
Hope this helps,
Alex
------------------------------
Alex Walter
A3J Group, LLC
------------------------------
Original Message:
Sent: 04-22-2024 17:42
From: Glen Holt
Subject: Job Plan Query for planned labor
Hi All, I'm looking for a query that I can run against the Maximo job plans table to find any JPs that have planned labor associated.
No luck so far. Any assistance would be greatly appreciated!
Thanks much!
#EverythingMaximo
------------------------------
Glen Holt
King County
------------------------------