[Gnumed-devel] sample SQL commands (queries) for the Report generator?

[James Busser]

Anyone care to suggest any, including sample syntax with sample  
values? I can add them to the wiki page
        http://wiki.gnumed.de/bin/view/Gnumed/GnumedReportGenerator

- a query that would help by providing more fields (and sample  
values) that could be altered and used to find a patient when the  
standard patient search field did not permit a patient to be found,  
perhaps including the communication channels (phone numbers)

- a query that can search for patients based on the diagnostic code  
(would this come from clin_diag or maybe Clin.Coded_Narrative where  
it may be necessary to specify both the desired code and  
xfk_coding_system

- a query that would result the number of distinct patients in the  
database

- a query that would find patients based on a medication that is  
being used