public inbox for [email protected]  
help / color / mirror / Atom feed
From: Andreas Joseph Krogh <[email protected]>
To: David G. Johnston <[email protected]>
Cc: [email protected]
Subject: Re: How to ensure a log-entry is created based on state of data in other tables
Date: Thu, 9 Feb 2023 17:59:03 +0100 (CET)
Message-ID: <VisenaEmail.6b.d76438498ddf3620.186371b8050@visena.app.internal.visena.net> (raw)
In-Reply-To: <CAKFQuwYuYs0nmWpgLUwfTP5pF7zZgxJP+BqFj8gToZ4=RH89SQ@mail.gmail.com>
References: <VisenaEmail.3d.88fc3a77a99e504f.18635052f66@visena.app.internal.visena.net>
	<CAKFQuwYuYs0nmWpgLUwfTP5pF7zZgxJP+BqFj8gToZ4=RH89SQ@mail.gmail.com>



På torsdag 09. februar 2023 kl. 17:44:25, skrev David G. Johnston <
[email protected] <mailto:[email protected]>>:


On Thu, Feb 9, 2023 at 12:24 AM Andreas Joseph Krogh <[email protected] 
<mailto:[email protected]>> wrote:


Is there a better way, using some extra tables to do bookkeeping can the have 
constraints ensuring this business-requirement?





Every time an activity newly becomes "Not Done" increment a "not done seen 
counter" and likewise with a "done seen counter". Whenever the former is 
greater than the later you have one or more not done activities.

David J.

Ah, this is what I'm looking for, I think.






--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
[email protected] <mailto:[email protected]>
www.visena.com <https://www.visena.com;
 <https://www.visena.com;


view thread (7+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: How to ensure a log-entry is created based on state of data in other tables
  In-Reply-To: <VisenaEmail.6b.d76438498ddf3620.186371b8050@visena.app.internal.visena.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox