Notifications
Clear all
Topic starter
When running reports for service orders only, does anyone know of the best way to eliminate duplicates? I notice that all of the orders.change fields are 0 and the orders.ordernum fields are the same.
Stacey LaGrange
Software Developer/Analyst
St. Mary's Health System
[email protected]
(207) 777-8410
Posted : June 6, 2012 11:57 pm
add
{ORDERS.XID} = 99999999999999997000000000000000000 // active
to your select. this gets the last changes for a particular order.
Posted : June 7, 2012 12:13 am
jjordet said:
add
{ORDERS.XID} = 99999999999999997000000000000000000 // active
to your select. this gets the last changes for a particular order.
Oh, please don't. Use {ORDERS.XID} = 10^35 instead. Easier to read and remember.
Posted : June 7, 2012 12:18 am
Topic starter
I just realized that I never thanked you both for your feedback, my report is working great now.
Posted : June 14, 2012 4:32 am
