[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: James Busser
Subject: [Gnumed-devel] sample SQL commands (queries) for the Report generator?
Date: Sat, 29 Dec 2007 21:07:43 -0800

Anyone care to suggest any, including sample syntax with sample values? I can add them to the wiki page

- 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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]