Re: [Gnumed-devel] Sort order and clin_when

[Karsten Hilbert]

On Sun, Jul 17, 2011 at 09:05:42AM -0700, Jim Busser wrote:

> Those GNUmed tables which contain at *least* one date column may contain
> 
>       modified_when
>       clin_when
> 
> So, what I *should* have more clearly asked concerns which
> of the two dates get used in the UI and how.

It depends. Most of the time it is .clin_when. Sometimes it
is the time of the encounter to which something is linked.
At other times it is the .modified_when. Sometimes it can
even be mixed.

> There can be:
> 
> - explicit presentation (being "shown" to the user) where it would maybe be 
> obvious
> 
> - implicit presentation (specification of query ranges of interest, sort 
> order) when the dates themselves may not appear in the UI.
> 
> So I am wondering whether this choice has already needed to be made in any 
> queries that would present such information to the user, or not yet?

That choice has been made numerous times for different
queries, and has also been discussed on-list for some
instances of said choice.

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