X-CGP-ClamAV-Result: CLEAN X-VirusScanner: Niversoft's CGPClamav Helper v1.22.2a (ClamAV engine v0.102.2) From: "Jesse Tayler" Received: from mail-qk1-f176.google.com ([209.85.222.176] verified) by selbstdenker.ag (CommuniGate Pro SMTP 6.3.7) with ESMTPS id 26732121 for webobjects-dev@wocommunity.org; Wed, 03 Nov 2021 14:26:15 +0100 Received-SPF: none receiver=post.selbstdenker.com; client-ip=209.85.222.176; envelope-from=jtayler@oeinc.com Received: by mail-qk1-f176.google.com with SMTP id r8so2226736qkp.4 for ; Wed, 03 Nov 2021 06:26:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=oeinc-com.20210112.gappssmtp.com; s=20210112; h=from:mime-version:subject:date:references:to:in-reply-to:message-id; bh=9em/nAXAhtm7lm5eWuSZAGK4/IzPwvZimcsEl559dM8=; b=0bGgXxqoa93UN15N6BIBlTD2yxcXTlaPK+LBvsSdW3PuVzhlcIGESKTK6lLzQGYQog ZCJ/4FHy1SUTOAXodHAt/ttQw2/rGPFQsiEzGfEKyPSHHlNpiWMUD90QgcJsOkVlkV1m 2tFpULRFlfIO6HJEIAjSogqg4J+6RYKiNE7FnlVmXBclxd+/leCk7ujTE5bT8WQ1mcpb RdTYnhnbhA5gC7RcGul2JxrrDdzhXRkf0kUsrG305dRvUZOzRYNYhRI6FhZC5i6zlVHJ a/JcQbtOuqDnrC27WhyjJoAXzvCCgm/2Lt35pE8iMA++u5sndg23HgPWDpavATOQycFy 9jSg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:mime-version:subject:date:references:to :in-reply-to:message-id; bh=9em/nAXAhtm7lm5eWuSZAGK4/IzPwvZimcsEl559dM8=; b=k9Zr0C57awgoRspEyhrt/Z8FsBLcnVoE8WuYlII2z83cpscJg6tjSICwU6zdRtcmP0 05GmwoHEVWol3Uy0y3XhVIatxrg0y5jthJVgmdWg0gcNPmlIRN3yn/4rNcuZopdRajAv k78VcNxso/FRQntossZATrg5NnDep8YdSZSSjtOwgC7q5KYrHMxW3DMtMRYMOZzqHhrD HWND8qVz4JMyqX/Ue4JIc5i9LnzgDK4UqMimHyyKJym98luqm/Km7B27X92nfpnDU0J+ ZsdBW1pc1Zd8wQOQoVroLA212SB/coEd/qggPr59HdQoI8Q6SY/xIVgnmlDSiE4cX8Ch WRdQ== X-Gm-Message-State: AOAM532a1xmckCOO+F38YUBvsQUx+rW0lLaz/sac9n60mekW6LVqpy0H /auu7QokzMH3SgqHGbnObV2X/G8fADDWjg== X-Google-Smtp-Source: ABdhPJzgATfEiT4vWAkC8eNKaZoX2/AwGAlTTVb8SCyoN8BJ3tu//AVb9tBAaHaeGWB+lR4r5iBqEg== X-Received: by 2002:a37:8e44:: with SMTP id q65mr33810102qkd.372.1635945953589; Wed, 03 Nov 2021 06:25:53 -0700 (PDT) Return-Path: Received: from [192.168.1.16] ([69.169.5.176]) by smtp.gmail.com with ESMTPSA id i14sm1601839qti.25.2021.11.03.06.25.52 for (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 03 Nov 2021 06:25:53 -0700 (PDT) Content-Type: multipart/alternative; boundary="Apple-Mail=_EC11D940-0688-415C-B6AE-CD83B072A3E3" Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.60.0.2.2\)) Subject: Re: [WO-DEV] How would you create such an EOQualifier representing Postgresql date_trunc(...)? Date: Wed, 3 Nov 2021 09:25:51 -0400 References: To: WebObjects & WOnder Development In-Reply-To: Message-Id: X-Mailer: Apple Mail (2.3654.60.0.2.2) --Apple-Mail=_EC11D940-0688-415C-B6AE-CD83B072A3E3 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 I generally use ERXKeys and fancy methods called dot() and these good = ideas let you code into the compiler the structure of whatever query you = like to do. I don=E2=80=99t see anything unusual about your qualifier? Want an = example? > On Nov 3, 2021, at 8:48 AM, Markus Ruggiero (rucotec) = wrote: >=20 > No one? > I can live with raw rows but would have been great if anyone knows >=20 > ---markus--- >=20 >> On 1 Nov 2021, at 12:54, Markus Ruggiero (rucotec) = > = wrote: >>=20 >> Need to find objects satisfying the following condition: >>=20 >> CHECK_IN_TIME must be at least on the same day or later than = REQUESTED. Both values are stored as NSTimestamp with a 15 minutes = precision. >>=20 >> In Postgres I would write >>=20 >> ...where date_trunc('day', CHECK_IN_TIME) >=3D date_trunc('day', = REQUESTED) >>=20 >> How can I create a qualifier for this? Is this possible at all or do = I have to resort to raw rows for SQL? >>=20 >> Thanks >> ---markus--- >>=20 >>=20 >>=20 >> Markus Ruggiero >>=20 >> rucotec GmbH web https://rucotec.ch = >> Steinenvorstadt 79 email markus.ruggiero@rucotec.ch = >> 4051 Basel / Switzerland mobile +41 79 508 4701 >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >=20 >=20 --Apple-Mail=_EC11D940-0688-415C-B6AE-CD83B072A3E3 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 I = generally use ERXKeys and fancy methods called dot() and these good = ideas let you code into the compiler the structure of whatever query you = like to do.

I = don=E2=80=99t see anything unusual about your qualifier? Want an = example?

On Nov 3, 2021, at 8:48 AM, Markus Ruggiero = (rucotec) <webobjects-dev@wocommunity.org> wrote:

No one?
I= can live with raw rows but would have been great if anyone = knows

---markus---

On 1 Nov = 2021, at 12:54, Markus Ruggiero (rucotec) <webobjects-dev@wocommunity.org> wrote:

Need to find objects = satisfying the following condition:

CHECK_IN_TIME must be at least on the = same day or later than REQUESTED. Both values are stored as NSTimestamp = with a 15 minutes precision.

In Postgres I would write

...where date_trunc('day', CHECK_IN_TIME) >=3D = date_trunc('day', REQUESTED)

How can I create a qualifier for this? = Is this possible at all or do I have to resort to raw rows for = SQL?

Thanks
---markus---



Markus = Ruggiero

rucotec GmbH              =           web https://rucotec.ch
Steinenvorstadt 79          =       email markus.ruggiero@rucotec.ch
4051 Basel / = Switzerland         mobile +41 79 508 4701











= --Apple-Mail=_EC11D940-0688-415C-B6AE-CD83B072A3E3--