[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] forms concept (instead of placeholders)
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] forms concept (instead of placeholders) |
Date: |
Tue, 20 Oct 2009 11:43:10 +0200 |
User-agent: |
Mutt/1.5.20 (2009-06-14) |
Hello Jerzy,
> > 4. The key for implementation is the decission to fetch
> > data for the template directly from backend using SQL query.
> > This query is stored together with template (a new field in
> > ref.paperwork_templates is required, I added
> > 'sql_query'::text). It may have parameters just like any
> > other query executed via gmPG2.run_ro_queries. It returns
> > all data at once, no need to collect data from multiple
> > objects.
I am currently integrating your approach into GNUmed.
I am not really fond of adding non-generic fields to the
paperwork_templates table. However, you do need a place to
store the SQL query. I've been thinking why don't we make
the SQL part of the template XML itself ? We could then
a) manage the query right inside the XSLT template
b) extract the query from the retrieved template
Jerzy, can you supply an XSLT template that you have in use ?
Could you make a suggestion as to how to store the query in
the template ? (as in which XML tag etc)
Thanks,
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- [Gnumed-devel] forms concept (instead of placeholders), Jerzy Luszawski, 2009/10/03
- Re: [Gnumed-devel] forms concept (instead of placeholders), Sebastian Hilbert, 2009/10/04
- Re: [Gnumed-devel] forms concept (instead of placeholders), Karsten Hilbert, 2009/10/15
- Re: [Gnumed-devel] forms concept (instead of placeholders),
Karsten Hilbert <=
- Re: [Gnumed-devel] forms concept (instead of placeholders), Karsten Hilbert, 2009/10/20
- Re: [Gnumed-devel] forms concept (instead of placeholders), Karsten Hilbert, 2009/10/20
- Re: [Gnumed-devel] forms concept (instead of placeholders), Jerzy Luszawski, 2009/10/20
- Re: [Gnumed-devel] forms concept (instead of placeholders), Karsten Hilbert, 2009/10/26
- Re: [Gnumed-devel] forms concept (instead of placeholders), Karsten Hilbert, 2009/10/27
- Re: [Gnumed-devel] forms concept (instead of placeholders), Jerzy Luszawski, 2009/10/20