Re: [Gnumed-devel] forms concept (instead of placeholders)

[Karsten Hilbert]

Jerzy,

I have checked into CVS all the relevant code, too.

Karsten

On Tue, Oct 20, 2009 at 11:43:10AM +0200, Karsten Hilbert wrote:
> Subject: Re: [Gnumed-devel] forms concept (instead of placeholders)
> 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 mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/gnumed-devel

-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346