X-CGP-ClamAV-Result: CLEAN X-VirusScanner: Niversoft's CGPClamav Helper v1.22.2a (ClamAV engine v0.102.2) From: "Ramsey Gurley" Received: from [40.107.244.84] (HELO NAM12-MW2-obe.outbound.protection.outlook.com) by selbstdenker.ag (CommuniGate Pro SMTP 6.3.7) with ESMTPS id 26735024 for webobjects-dev@wocommunity.org; Wed, 03 Nov 2021 23:16:15 +0100 Received-SPF: pass receiver=post.selbstdenker.com; client-ip=40.107.244.84; envelope-from=Ramsey.Gurley@practicemojo.com ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=fxVQ6T5CKl25oU9H1bU8DjA84eZ5eDbb4goPQkku0WYemdhTLK9VFsXoDCU6ENnFWcy+ktLW36re8NBvkJTCgAOny18Xf7MF+iQZQaVnmUZhP7h/tmUEG9+9QCjffeRvt4JjAMjsIaEvXVrYsbPSvnsmM66e7sLXV/hvRrWBcu+u4knR8tBEr1ST9RHYoozY2HCkgQB5mLeMfqDVXKDgZ6W3DXs/aSNtTJVHGcJ8iP3KtXCaGvNKcjRaAPqUt4+ghFMLqbntlDdy739XnhQLFGgHPR6sELxwGXlQI5G3P2ozK6qAnZ9JI9Cl4rNvytZJodCeqxd4V/api0FLQ36xKA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=9FymBEWDmDNaBHjncr4eMwsdeuVJo1RID7xPP8wZUEQ=; b=QYZujQokIvwjJR1dRzSUZnSfHUkmXy0nYGmnXByrJOsm9JZ1MkbK0HSNxUjzQq+MVC3pCkQQbsoMCmOTv31Xylld6N0aPm70PsH9SM/2Ef+PMKsFS5kCL5BPeYlm7/wghY8PwWON9yCZ55WlnK/L5/Quk+2XxhRIjw8OL9Pa+ygAyhy3jTzM4XDvIF2YfigDcMhTDzMWD0jiZf0A+zJ5E1zfWtXdUewes7DnCuM4MfB9cuVGb6zFoavfVww3MeKCenPFulNss0Fp7GqP4+aNsqxlqGcbeuGbfipgnwYQzXzLfqx0h/yKLySfrI1AmjEM2AQaFS6chgaIWdGaei7Stg== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=practicemojo.com; dmarc=pass action=none header.from=practicemojo.com; dkim=pass header.d=practicemojo.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=prositesinc.onmicrosoft.com; s=selector2-prositesinc-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=9FymBEWDmDNaBHjncr4eMwsdeuVJo1RID7xPP8wZUEQ=; b=V7Vcs8/gOCJgpoqaczTPvzofinJPBbwqlLUzAKkYI0eTqsGXDNTzGaRSxFKddH5oho1VyXGOUl5DQ7CFHk0xUkjIAeKWt0ZICIz2Q+wozranMcOMMPmKrnnf7UCUKHu4cLgfEyvcoTRkiqb4O07W5ryt8joDSdRlfehC9p1Ay4Q= Received: from BYAPR18MB2534.namprd18.prod.outlook.com (2603:10b6:a03:12e::29) by BY5PR18MB3266.namprd18.prod.outlook.com (2603:10b6:a03:1a1::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4669.11; Wed, 3 Nov 2021 22:15:48 +0000 Received: from BYAPR18MB2534.namprd18.prod.outlook.com ([fe80::1ca7:5c4:9780:7848]) by BYAPR18MB2534.namprd18.prod.outlook.com ([fe80::1ca7:5c4:9780:7848%3]) with mapi id 15.20.4649.015; Wed, 3 Nov 2021 22:15:48 +0000 To: WebObjects & WOnder Development Subject: Re: [WO-DEV] How would you create such an EOQualifier representing Postgresql date_trunc(...)? Thread-Topic: [WO-DEV] How would you create such an EOQualifier representing Postgresql date_trunc(...)? Thread-Index: AQHX0QBaa0odBaOsUkqkbIoha+RV0w== Date: Wed, 3 Nov 2021 22:15:48 +0000 Message-ID: <72249CBE-CD66-470B-9429-58A8C8E273AA@practicemojo.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-mailer: Apple Mail (2.3608.80.23.2.2) authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=practicemojo.com; x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 3deb1a24-3e8a-47e7-fb1d-08d99f177d56 x-ms-traffictypediagnostic: BY5PR18MB3266: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:10000; x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: 5EnjNbbXpwkpUwiuMQWqTbxodNYj6Busl1QmVJeTMHnfsNvKzVGVAmkEmMi1fVdAO+rv2zfNt2Ck5ymROusrV4/cIPSJMvX0w+RpfT2O8JwPuisvTN7xnfx2qP+ZwTSjX8QeXJ9pmRngBfxSb7tJUEj7d9+CHxnUf5fzEqcDBDKzcXKYJTCrEtE9PWNTsc6rbS19uXr1NBU35r/wU6r21IeXqDOiQ67v7/8iiR5UzZvB3781gP9ZBa2U0V2DNAqaWP5Hcu1J9S3WnD423XPiYNtcNQzDeWXllABjFh7LqZZabq1z3oqkmyoCWaxlweqnKkDyxMIaXw9TlB4gQ8pMcLZFZ7xu+LmGrhucaxcgSFsc7jnlnWkUWF6+Na6h4sV3dKfTbTI9N59oiZeVmPKgSXMTwUoF8Q3qTTlGbB/PVP0iu6xzR+uTioXEcQPMLj9OiVn66HqRnOyVcN7DXMCtqFHpjhR0NasGIO+8DlnZF9fTozxJdtquk8uUjKKLuXfHrfqmvgWOLJ8Ivd3q/XV50T/vB4BnP/SAvITLLR69tyx0AjKYzD70XgT7q/hc1QStlxRV+ZAr47YQAPwLz+9APVMgWENaLG6U6SPDfzRt+zyUzKEiTVBaFMKYjMCBZ2kEThBp7ojMNZP24bChCf9D+HzvP75JmQ7pvSsg0aLvK6PZXHjgSKtTCt//XdD72vGoT6F7PEzcJymME4dwo6qWEU99Mbs+GV1gQ1XGKmatnnvMK+ZTlyUSBcEfbS9cl18S49F3irRJd3OsCMuYMFuY1yvwIoAHcQfBnSTtbW53rpXyyu/mRvwgXAu7SoU+FPR8 x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:BYAPR18MB2534.namprd18.prod.outlook.com;PTR:;CAT:NONE;SFS:(4636009)(376002)(346002)(366004)(396003)(136003)(39850400004)(26005)(6512007)(122000001)(38070700005)(2906002)(66946007)(508600001)(36756003)(71200400001)(316002)(91956017)(76116006)(86362001)(2616005)(186003)(6916009)(166002)(966005)(33656002)(8676002)(38100700002)(66476007)(5660300002)(8936002)(66446008)(64756008)(66556008)(53546011)(6486002)(6506007)(83380400001)(45980500001);DIR:OUT;SFP:1101; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?us-ascii?Q?ZDuxGUOX9Ez5EUldlw50sxPhnTqDDw3/HWQTOQOp5//IAEkvu3AeaI9TjPY3?= =?us-ascii?Q?MFXqJkH348RxsbSkNwJSYI7zbIGDmmsrU1bARubC3dtct5iN6XXLwGJw/AXd?= =?us-ascii?Q?YgoUV+lTgSKLGdMdrGB/l9wYjm28hTuhVcZaV675UmiSqYfRJ+1t1TrBBOKI?= =?us-ascii?Q?vb84yMRuIhYdJXThnAALyyVQraIdR/cVK9x58pBo85mOLqyAjoAJZjBwEIao?= =?us-ascii?Q?eS6Z2yZ7LMh3MNpNinWmJakkv+6Dx3bqP0xsapJmXHDvFvyM2tSCauvfZuql?= =?us-ascii?Q?1FurTtrfRmW0hK2i4PSuWfHfCcWPa0Ybhq7InFvFe1g6eNfSrMSw6Vcpm/IJ?= =?us-ascii?Q?89/WxC8WOEeQQ4x5rIrSVP0oG+NNYRR7UMPSQ71U4qWA++mmm0KthQSZlxPl?= =?us-ascii?Q?P9RHDEQTEzqdInXfl6DHL0OOkbgl7A7atwX+7UY1B4zDhffw6M+r3n/YRHbj?= =?us-ascii?Q?6yyJLeeLClZer+bsQMlI1s7l6L45zBWNzuulvG465QTx+fNBv7/vTxyd8oB3?= =?us-ascii?Q?p1IuLw+UC98Kh20QthGIW2NtCmqqzRGvtoBv4I4XmQdZwHpwpGYxDJTPA52l?= =?us-ascii?Q?P0c7kE3oolqmDSKSBYm9AQ2/PdFA4BZZ4GrfcoqTewsqy9HVMZyI4lLPNSYN?= =?us-ascii?Q?PLtNNhGhxDObYvda4IemYdW9XYxHyA8AU1Dtlmb5+WpPOPizQL60XseTIeqP?= =?us-ascii?Q?mDdoCyIK+fFv9fubBpK08Jr9GlYCnQ2nt/1csyFNmbyjGjzPvkwGI6paDUSH?= =?us-ascii?Q?9UlqIjQRS+pt0VGbvma68XvmTNrGsuWgssqfNwvn5rLk9b/di0r6VVMyiJMO?= =?us-ascii?Q?CO6IYI/7+sa8MIKA7nHYQztQCeAMHNXq7jEd4yeGaYNRVFxbrHClnP7ISISp?= =?us-ascii?Q?v+Zwf2LVJ7P9D52YuYMdFgbMioAIGqltKhDKNwQna+sfHzKKyydzg+tgRotQ?= =?us-ascii?Q?T0CkAfFXxZ+Y2Kdb6rxb7GvAbsL8iAtMM7tjk6HFMT2suEZvkCC6v/CfBotJ?= =?us-ascii?Q?MZIy46yGcUOOfDqYnRxUwZUwOcoaWjVL1MGb8OhF5LxkSWHC3IGrnrpLkN+M?= =?us-ascii?Q?unr/DgGaMbVwdiQOgjJ6XiI0M3BR7YMaKzCCtXCp2XV7HK6ZPTeyOrgc51cL?= =?us-ascii?Q?+qQxrinqETmUKG8yr0faNupIPSDnqj+e9uI7qw4AajRrDQ5+bYqY43tPtxP9?= =?us-ascii?Q?CMAi3HS4kp7I9l0TpeogoN9QCKfM27V8/EAtXYvrgib184T5rs9kbwN3EagE?= =?us-ascii?Q?s3lorSxupHMvTlf7S0pjphaV2eZOT9PK1N2/4+2jhKQM8Gck5bNyyO3ZCg7K?= =?us-ascii?Q?fyFXDziBpiU5HmcIyV9PdTsqL19IQ08qDk5tkldhk6+UR8jopnSkd6g2Ndjc?= =?us-ascii?Q?ZdI18PHmR4SsFGa1/JyUQjuBox5YpJrsknyzowOuZF8YF8/PI+ruZqiUjCJZ?= =?us-ascii?Q?19LrZGTmVnCE2fLj2VdikWYqXnHolIkr7DJ3U185J/WqLTUZM1OFvQU9bo9k?= =?us-ascii?Q?TAdUMNyKxvN6/uuw7Cl6RVW1xEbbtu3Eobxkjqgh7aYGgyVtNDKa1rgNWeqS?= =?us-ascii?Q?mU7VBM4SEXZvKLOQnv3HXxM5z6nBom6VmmbT8PYv6JICDFXSrAN4eVHXlHxa?= =?us-ascii?Q?hlWs/VahQFrdxqJszMnJiHIhV5h7GFhUHr0ZJ9VNKALBXURJwwxuTESMaqZz?= =?us-ascii?Q?JGsUVLAYo/MdmiuINS/E9tBj27I=3D?= Content-Type: multipart/alternative; boundary="_000_72249CBECD66470B942958A8C8E273AApracticemojocom_" MIME-Version: 1.0 X-OriginatorOrg: practicemojo.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BYAPR18MB2534.namprd18.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 3deb1a24-3e8a-47e7-fb1d-08d99f177d56 X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Nov 2021 22:15:48.2843 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: de0a5129-99d3-4d35-a928-09047a134775 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: a77fYLDlrBWoay0luZD0nwXOkxWeyLeRY16JcpPwdBIzPk6xNKn+JWSArm9HTNXAeQdPsTjQfLggXXqXvvTEtTaKx/8TlHtSs8cw756zpkI= X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY5PR18MB3266 --_000_72249CBECD66470B942958A8C8E273AApracticemojocom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi Markus, You could create a derived attribute in your model for the truncated value,= but it would calculate that every time you fetch rows as well. Ramsey On Nov 3, 2021, at 9:48 PM, Markus Ruggiero (rucotec) > 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) > wrote: Need to find objects satisfying the following condition: CHECK_IN_TIME must be at least on the same day or later than REQUESTED. Bot= h 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 ________________________________ Confidentiality Notice: This email, including all attachments and replies t= hereto, are covered by the Electronic Communications Privacy Act, 18 U.S.C.= Sections 2510-2521 and are legally privileged. This information is confide= ntial, and intended only for the use of the individuals or entities named a= bove. If you are not the intended recipient, you are hereby notified that a= ny disclosure, copying, distribution or the taking of any action in relianc= e on the contents of this transmitted information is strictly prohibited. P= lease notify us if you have received this transmission in error. Thank you. --_000_72249CBECD66470B942958A8C8E273AApracticemojocom_ Content-Type: text/html; charset="us-ascii" Content-ID: <4804CC04667CB54B98703A12C7E99CAA@namprd18.prod.outlook.com> Content-Transfer-Encoding: quoted-printable Hi Markus,

You could create a derived attribute in your model for the = truncated value, but it would calculate that every time you fetch rows as w= ell.

Ramsey

On Nov 3, 2021, at 9:48 PM, Markus Ruggiero (rucotec) <<= a href=3D"mailto:webobjects-dev@wocommunity.org" class=3D"">webobjects-dev@= wocommunity.org> wrote:

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

---markus---

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

Need to find objects satisfying the following condition:

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

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                       &nb= sp;web https://rucotec.ch
Steinenvorstadt 79                email markus.ru= ggiero@rucotec.ch
4051 Basel / Switzerland         mobile +41 79 508 4701










Confidentiality Notice: This email, including all attachments and= replies thereto, are covered by the Electronic Communications Privacy Act,= 18 U.S.C. Sections 2510-2521 and are legally privileged. This information = is confidential, and intended only for the use of the individuals or entities named above. If you are not the= intended recipient, you are hereby notified that any disclosure, copying, = distribution or the taking of any action in reliance on the contents of thi= s transmitted information is strictly prohibited. Please notify us if you have received this transmission in err= or. Thank you.
--_000_72249CBECD66470B942958A8C8E273AApracticemojocom_--