| Creating report filters [message #4780] |
Mon, 11 January 2010 19:48  |
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   |
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  |
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.
|
|
|