Re: Query By Formula ([Table]) v17 Loss of Functionality
Hello Tim, Thanks for clearing that up for me. Sometimes I'm pretty thick! I really like the ability to copy actual fields from line 1 to line 2! This option seems to be available in the standard query window, so there seems to be no reason to have a separate menu item for query by formula? Thanks, Alan On Thu, Jan 17, 2019 at 3:14 PM Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote: > On Jan 17, 2019, at 1:57 PM, Alan Tilson wrote: > > > I'm not sure what you mean. The window had 2 or 3 boxes per line. The > first > > one seems only to allow fields to be entered. The 2nd for non-boolean > > fields is the comparison box, equals, is different from, etc. The 3rd is > a > > value. > > > > This is the default query window created from this code: QUERY SELECTION > BY > > FORMULA([Table]). It appears to be exactly the same query window as QUERY > > SELECTION([Table]). > > > > If you have something that works please let me know what steps to go > > through to do it! > > > > Ps My understanding is that we cannot send images here. Is that still > true? > > To access the query by formula option in the new query editor you need to > option-click on the “+” button at the far right of a line. When you do > that, you get a new query line that allows you to enter a formula. You can > delete the first line in the query editor with the “-“ button. > > An interesting and hidden feature of the new query editor is that you can > mix field lines and formula lines into a single query. > > And no, you cannot send images to this message board. You have to pass a > link to something like this: > > > https://www.dropbox.com/s/aerxv021dfzllxz/Screen%20Shot%202019-01-17%20at%202.09.45%20PM.PNG?dl=0 > > Tim > > * > Tim Nevels > Innovative Solutions > 785-749-3444 > timnev...@mac.com > * > > ** > 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 > ** ** 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 **
Re: Query By Formula ([Table]) v17 Loss of Functionality
On Jan 17, 2019, at 1:57 PM, Alan Tilson wrote: > I'm not sure what you mean. The window had 2 or 3 boxes per line. The first > one seems only to allow fields to be entered. The 2nd for non-boolean > fields is the comparison box, equals, is different from, etc. The 3rd is a > value. > > This is the default query window created from this code: QUERY SELECTION BY > FORMULA([Table]). It appears to be exactly the same query window as QUERY > SELECTION([Table]). > > If you have something that works please let me know what steps to go > through to do it! > > Ps My understanding is that we cannot send images here. Is that still true? To access the query by formula option in the new query editor you need to option-click on the “+” button at the far right of a line. When you do that, you get a new query line that allows you to enter a formula. You can delete the first line in the query editor with the “-“ button. An interesting and hidden feature of the new query editor is that you can mix field lines and formula lines into a single query. And no, you cannot send images to this message board. You have to pass a link to something like this: https://www.dropbox.com/s/aerxv021dfzllxz/Screen%20Shot%202019-01-17%20at%202.09.45%20PM.PNG?dl=0 Tim * Tim Nevels Innovative Solutions 785-749-3444 timnev...@mac.com * ** 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 **
Re: Query By Formula ([Table]) v17 Loss of Functionality
Hello Christian, I'm not sure what you mean. The window had 2 or 3 boxes per line. The first one seems only to allow fields to be entered. The 2nd for non-boolean fields is the comparison box, equals, is different from, etc. The 3rd is a value. This is the default query window created from this code: QUERY SELECTION BY FORMULA([Table]). It appears to be exactly the same query window as QUERY SELECTION([Table]). If you have something that works please let me know what steps to go through to do it! Thanks, Alan Ps My understanding is that we cannot send images here. Is that still true? On Wed, Jan 16, 2019 at 4:16 PM Christian Sakowski < christian.sakow...@heubach-media.de> wrote: > Hi, > > have you tried holding „Option“-Key and „+“ so you can enter a formula? > -- > > Grüße/Regards, > [heubach-media] | Christian Sakowski > christian.sakow...@heubach-media.de > Tel: +49/(0)40/52 10 59-23 > > > > > > Am 16.01.2019 um 21:02 schrieb Alan Tilson via 4D_Tech < > 4d_tech@lists.4d.com>: > > > > Hello out there, > > > > I just noticed in our v17 system which we upgraded from v13 that the > system > > (4D) generated query box for Query By Formula is basically the same box > > that is for standard queries. > > > > I see no way to simply query for Field1 # Field2. I cannot even manually > > type in Field2 (at least in the case of real fields). > > > > I'd love some help getting this to work or confirmation that it is no > > longer possible. > > > > Thanks, > > Alan > > ** > > 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 > > ** > > > -- > heubach media > Osterfeldstr. 12-14 | Haus 1 | Eingang Nord > 22529 Hamburg > tel: 040 / 52 10 59 - 10 | fax: -99 > mail: i...@heubach-media.de > home: www.heubach-media.de > Geschäftsführer|CEO: Matthias Heubach > > Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei: > http://www.milo-rental.com > > Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte > Informationen. > Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich > erhalten haben, > informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. > Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist > nicht gestattet. > > This e-mail may contain confidential and/or privileged information. > If you are not the intended recipient (or have received this e-mail in > error) > please notify the sender immediately and destroy this e-mail. > Any unauthorized copying, disclosure or distribution of the > material in this e-mail is strictly forbidden. > ** 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 **
Re: Query By Formula ([Table]) v17 Loss of Functionality
Hi, have you tried holding „Option“-Key and „+“ so you can enter a formula? -- Grüße/Regards, [heubach-media] | Christian Sakowski christian.sakow...@heubach-media.de Tel: +49/(0)40/52 10 59-23 > Am 16.01.2019 um 21:02 schrieb Alan Tilson via 4D_Tech <4d_tech@lists.4d.com>: > > Hello out there, > > I just noticed in our v17 system which we upgraded from v13 that the system > (4D) generated query box for Query By Formula is basically the same box > that is for standard queries. > > I see no way to simply query for Field1 # Field2. I cannot even manually > type in Field2 (at least in the case of real fields). > > I'd love some help getting this to work or confirmation that it is no > longer possible. > > Thanks, > Alan > ** > 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 > ** -- heubach media Osterfeldstr. 12-14 | Haus 1 | Eingang Nord 22529 Hamburg tel: 040 / 52 10 59 - 10 | fax: -99 mail: i...@heubach-media.de home: www.heubach-media.de Geschäftsführer|CEO: Matthias Heubach Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei: http://www.milo-rental.com Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet. This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ** 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 **
Query By Formula ([Table]) v17 Loss of Functionality
Hello out there, I just noticed in our v17 system which we upgraded from v13 that the system (4D) generated query box for Query By Formula is basically the same box that is for standard queries. I see no way to simply query for Field1 # Field2. I cannot even manually type in Field2 (at least in the case of real fields). I'd love some help getting this to work or confirmation that it is no longer possible. Thanks, Alan ** 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 **
