Re: [Gnumed-devel] jl-gui et alii - v_emr_tree

[Karsten Hilbert]

On Mon, Aug 26, 2013 at 06:19:05PM +0200, Jerzy Luszawski wrote:

> > > *** clin.v_pat_encounters ***
> > > I expanded the "standard" view by adding columns reflecting auditing.
> > > All earlier columns are preserved, so I decided not to create
> > > separate view.
> > 
> > The file you sent does not seem to contain a
> > clin.v_pat_encounters different from what I know. Can you
> > take a look and perhaps send an updated suggestion ?
> 
> But the file you got does contain differences (just after
> xmin_encounter field):
> 
> c_enc.row_version, c_enc.pk_audit, c_enc.modified_when,
> c_enc.modified_by, 
> COALESCE(( SELECT staff.short_alias FROM dem.staff
> WHERE staff.db_user = c_enc.modified_by), ('<'::text ||
> c_enc.modified_by::text) || '>'::text) AS provider

True enough. I didn't see those. I have, however, already
gotten the changes from your git tree.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346