Home » ClearHealth Forums » ClearHealth Forms/Reports » Creating report filters
Creating report filters [message #4780] Mon, 11 January 2010 19:48 Go to next message
aesellars  is currently offline aesellars
Messages: 46
Registered: October 2008
Location: Cincinnati Ohio
The documentation on this is a little lacking. But here's what I'm trying to do. I want to develop a report that lets me filter both by practice and provider. here's what I've got. I'll attach a screenshot of what it looks like in the report. The issue is that the second filter box isn't populatiing.

---[Provider_and_Facility]---
select person.last_name, person.first_name, person.date_of_birth 
from person inner join patient on patient.person_id = person.person_id 
where person.primary_practice_id = '[practice:query:select prac.id, prac.name as practice from practices prac order by prac.name]' 
and patient.default_provider = '[provider:query:select provider.person_id. concat(person.last_name, ', ', person.first_name) as provider from provider inner join person on person.person_id = provider.person_id ]' 
and person.inactive = '0'



  • Attachment: report.tiff
    (Size: 52.69KB, Downloaded 125 time(s))

Re: Creating report filters [message #4794 is a reply to message #4780 ] Fri, 15 January 2010 15:10 Go to previous messageGo to next message
aesellars  is currently offline aesellars
Messages: 46
Registered: October 2008
Location: Cincinnati Ohio
I figured this out. A lot of havoc a simple period can create.

On a related note:

Is there a way to create a report filter from a check box or radio button? I want to be able to filter on active/inactive.

Also, the "export to CSV" function isn't working in my reporting. It says "export to csv action does not exist"

Any insight?
Re: Creating report filters [message #4802 is a reply to message #4794 ] Sun, 31 January 2010 14:50 Go to previous message
jay.walker  is currently offline jay.walker
Messages: 961
Registered: January 2008
Location: Tucson AZ
On export to csv check the forum, there was a small name change in the function that is probably what is breaking the link. I am pretty sure there was a patch posted for it.

For checkbox or radio, we typically use select with the simpleToggle enumeration (yes/no).

'[includeArchive:enum:simpleToggle]' I think...


-Jay Walker
Customer Service
ClearHealth Inc.
Previous Topic:Fee Schedule history SQL
Next Topic:creating forms
Goto Forum:
  


Current Time: Fri Sep 10 01:52:52 EDT 2010

Total time taken to generate the page: 0.01519 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 2.7.6.
Copyright ©2001-2006 FUD Forum Bulletin Board Software