Notifications
Clear all
General Discussion
2
Posts
2
Users
0
Reactions
67
Views
Topic starter
Hi,
I am trying to track all service orders where the unit value is >1. Is there anyway to track this?
Thanks.
Posted : July 11, 2017 7:26 am
You can look at this query - you'll probably need to adjust the criteria:
select p.searchname, p.medrecno, o.authnum, o.ordertype, o.description, o.code, o.status, o.duration, o.durationunits, o.numvisits, o.clincomments
from orders o, person p where o.pid = p.pid
and numvisits is not null
and numvisits > 1
and xid = 1e35
order by searchname
Posted : July 11, 2017 11:37 am
