Hi,
The site i am working at, recently moved to Digital X-rays, with orders being placed from Bahmni and fulfillment through DCM4CHEE PACS.
So far the site was using the “Radiology Upload” module and the Obs count by concept class report to get the Radiology counts as mentioned on the wiki
https://bahmni.atlassian.net/wiki/display/BAH/Reports#Reports-9.ObsCountByConceptClassReport
However with the new way of working it seems that this report won’t give the required counts.
Can a new report be created as part of Bahmni to support this?
( Not sure if its feasible to have a report generic enough to support any type of orders and fullfilment)
Hi,
For now i have setup a custom SQL report to show up count of different radiology orders placed.
select concept_name.name, count(*) from orders, concept_name, order_type where
order_type.name = 'Radiology Order'
and orders.order_type_id = order_type.order_type_id
and date(orders.date_created) between '#startDate#' and '#endDate#'
and concept_name.concept_id = orders.concept_id
and concept_name_type = 'FULLY_SPECIFIED'
GROUP BY concept_name.name;