The Query is run from code; no forms involved. “Execute Query by Formula on Server” is Off (the same problem happens when it is On). I also tried using SQL joins for Query By Formula but it made no difference.
Interestingly, this bug goes back to at least 4D v13 yet no one else seems to have encountered it. We ran into it during a subtable conversion where we replaced Query Subrecords with Query Selection by Formula because because Query Subrecords also uses formulas (multiple criteria combined) and so it is an easy substitution. ------------------------------------------------ Richard Wright DataDomain rwri...@datadomainsoftware.com ------------------------------------------------ > Date: Thu, 2 Aug 2018 23:23:46 +0000 > From: Keisuke Miyako <keisuke.miy...@4d.com <mailto:keisuke.miy...@4d.com>> > > thank you for the correction and clarification! > > incidentally, is the query executed from a UI (i.e. running the query on a > table form)? > > what is the status of the "execute formula on server" compatibility setting? > > 2018/08/03 2:47、Richard Wright via 4D_Tech <4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com><mailto:4d_tech@lists.4d.com > <mailto:4d_tech@lists.4d.com>>>のメール: > > The incorrect behavior in step 2 is not dependent on the query conditions or > whether or not any records are found. It happens if you simply do the > following: > > Query Selection by Formula ([Many_Table];True) > ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
