On Fri, Oct 29, 2021 at 1:25 AM Stephane Potvin via 4D_Tech <
[email protected]> wrote:
> Hello all.
>
> Hoping someone can help me.
>
> I have two questions.
>
> 1. My partner provides piano tuning services and I built a DB for us to
> keep track of her clients, their pianos, and the tuning/services she
> provided on each piano.
> Main table is client information, linked table for services provided.
>
> So that I can contact clients who have not had their piano tuned in a year
> of more, I want to search for only those clients whose last service was a
> year or more ago.
>
> Is there a not too complicated method that will accomplish that?
>
Stephane,
I would do the task in several steps:
1. Find out all clients that are eligible for tuning service - maybe this
are all clients, maybe you may want to restrict them to active clients
(say, ordered some service in last 5 years.)
2. Find all treatments after specified date, and project selection of
treatments into Client table - this will create a set of clients that
had tuning service after specific date.
3. make a difference between two sets.
The actual code becomes exceptional simple with ORDA, where it would look
like (coode not tested)
var $allClients; $tunedClients; $notTunedClients : cs.ClientSelection
$allClients := ds.Client.all()
$tunedClients := ds.Tuning.query("TuningDate >=
:1";$tunedAfterDate).TuningToClientRelation
$notTunedClients := $allClients.minus($tunedClients)
Client and Tuning are names of tables, TuningToClientRelation is the name
of the relation from Tuning to Client table.
The same can be achieved with old syntax, using sets.
> 2. Having migrated my db to v. 18, the File, Edit, and User menus display
> numbers instead of text menu items. (see attached)
>
> How can I get the menus to display properly in MacOSX 10.14.6?
>
Menus should work properly, I converted several DBs. You have not included
screenshot, but just screenshot probably is not sufficient to find out
where is the problem.
HTH,
--
Peter Bozek
**********************************************************************
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
