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

[Jerzy Luszawski]

On 25-08-2013 12:47 Karsten Hilbert <address@hidden> wrote:

> On Sat, Aug 24, 2013 at 10:22:37PM +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

The rest is untouched, that's why I didn't create separate view.

--
Regards,
Jerzy Luszawski



-- 
Pozdrawiam,
Jerzy Luszawski