Have a query with list of work orders and trying to only get summary of Finish Good cost and Labor Hours reported. Below is an example:
wo.num part.num description qtyUsed code cost dateFinished 101:001 ELD-M0102-002- 1.1 Frame with Rods 2 ea 102.505274634 3/25/2022 9:35:00 AM 101:002 ELD-M0102-002- 1.2 Frame with Rods 2 ea 89.712984834 3/25/2022 9:36:00 AM 101:003 ELD-M0102-002- 2.1 Frame with Rods 2 ea 110.180648514 3/25/2022 9:36:00 AM 101:004 ELD-M0102-002- 2.2 Frame with Rods 2 ea 107.622190554 3/25/2022 9:36:00 AM 101:004 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:36:00 AM 101:001 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:35:00 AM 101:003 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:36:00 AM 101:002 ELD-MANF-0001 FRAME ASSEMBLY 4' X 8' 2 ea 79.479152994 3/25/2022 9:36:00 AM 101:002 ELD-MANF-0014 -1 .250 ROD 40 ft 10.23383184 3/25/2022 9:36:00 AM 101:003 ELD-MANF-0014 -1 .250 ROD 120 ft 30.70149552 3/25/2022 9:36:00 AM 101:004 ELD-MANF-0014 -1 .250 ROD 110 ft 28.14303756 3/25/2022 9:36:00 AM 101:001 ELD-MANF-0014 -1 .250 ROD 90 ft 23.02612164 3/25/2022 9:35:00 AM 101:001 Frame Assembly Labor Labor 2.866 hr 0 3/25/2022 9:35:00 AM 101:003 Frame Assembly Labor Labor 7.416 hr 0 3/25/2022 9:36:00 AM 101:004 Frame Assembly Labor Labor 6.416 hr 0 3/25/2022 9:36:00 AM 101:002 Frame Assembly Labor Labor 2.5 hr 0 3/25/2022 9:36:00 AM