Notifications
Clear all
Topic starter
Does anyone know the best way to get the form component count from EMR? We would like to know how many forms are in our EMR.
Posted : July 1, 2015 6:42 am
You can run a simple Crystal Report to return this number...
1. Use the FORM table
2. Group by FORM.FID
3. Insert summary of DistinctCount of FORM.FID
4. Done!
This will return every form component including obsolete. The EMR application keeps the versions of a form page to support users who still have a chart update in progress using an older version of an on-screen form.
If you want only active form components add {FORM.ACTIVE}="D" to Record Selection.
If you would prefer to get a count on the form sets then...
1. Use the FORMSET table
2. Group by FORMSET.FSID
3. Insert summary of DistincCount of FORMSET.FSID
4. Done
If you want only active forms add {FORMSET.ACTIVE}="D" to Record Selection.
Posted : July 1, 2015 8:40 am
If you would like to do this directly in SQL you can use the following query:
SELECTcount([FID])asCountofForms
FROM[FORM]
whereactive='d'
Posted : July 1, 2015 9:13 am
Topic starter
Thank you both.
Posted : July 1, 2015 4:23 pm
Are there any known performance issues with having a high count in the FORM table?
Posted : July 2, 2015 11:12 am
