Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
Wow! It’s great having a benevolent resident genius here! Thanks Miyako. Paul > Le 7 mars 2017 à 08:10, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Thank you Arnaud your code gave me the needed inspiration :) > > https://github.com/miyako/4d-component-classic-query-editor/ > > 2017/03/07 5:42、Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> のメール: > I just translated some comments, and, again, I never ended the job. HTH… > > > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
You missed my point on your point ;-) You can offer all of that without giving the user access to that in case you DON’T want them to have it. For example, you could create a set via a query, then give your users access to ONLY query the selection, or whatever. You don’t need that new 4D weird editor to do that. In a complex application it is normal to have to do a little extra coding. For example, we have a multi-company accounting system. When a user connects to one company we want to shield him from inadvertently access data from another company. So no matter what query he does, we will narrow the selection programmatically to exclude data we don’t want displayed. The nice thing about Miyako’s component is you can customize it to do these types of things, whereas 4D’s new query editor doesn’t leave you any choice. Cheers, Paul > Le 7 mars 2017 à 16:59, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > You missed my point. Let's say I have a db where users can only see only > certain regions of data. So You code that when you launch the process for > them, their all records actually shows a subset. In the old quest editor if > you had a command query selection that is all the user could do. In the new > query editor, the user can switch to create a new selection, into a set etc. > > Thus you as a developer must add extra code every time they do a query, > where in previous versions you did not > > Regards > > Chuck ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
On Tue, Mar 7, 2017 at 1:23 AM, Paul Lovejoy via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Chuck, > > As a developer I’ve already offered the functionality to query in the > selection, join to the existing selection or use a query result to exclude > from the selection. > You missed my point. Let's say I have a db where users can only see only certain regions of data. So You code that when you launch the process for them, their all records actually shows a subset. In the old quest editor if you had a command query selection that is all the user could do. In the new query editor, the user can switch to create a new selection, into a set etc. Thus you as a developer must add extra code every time they do a query, where in previous versions you did not Regards Chuck -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Sever connectivity http://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
> Le 7 mars 2017 à 08:10, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Thank you Arnaud your code gave me the needed inspiration :) I wonder when the inspiration leaves you some time to rest ;-) Thanks! -- Arnaud de Montard ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
Thank you Arnaud your code gave me the needed inspiration :) https://github.com/miyako/4d-component-classic-query-editor/ 2017/03/07 5:42、Arnaud de Montard via 4D_Tech <4d_tech@lists.4d.com> のメール: I just translated some comments, and, again, I never ended the job. HTH… ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
Chuck, As a developer I’ve already offered the functionality to query in the selection, join to the existing selection or use a query result to exclude from the selection. > Le 6 mars 2017 à 21:29, Charles Miller via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > On Mon, Mar 6, 2017 at 3:25 PM, truegold via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >> Our users have also found the new query dialog less intuitive. They >> expressed that having to use popup buttons required extra steps. And >> because some checkboxes are now hidden in the popup they forget about it. >> And other more subtle things. >> >> So for them it’s extra work! >> >> And, yes, I agree some things are more intuitive but I still prefer the >> “Classic” view myself. >> >> So I have used Miyako's dialog and the clients are happier. >> >> Not sure why 4D had to do away completely with a common editor that has >> been used for many years. Couldn’t the have offered both? >> >> Anyway, my thoughts. >> > > One more thing the new query dialog allows user to control whether query > selection or create new selection. Sometimes the developer needs those > controls in place > > Regards > > Chuck > > > -- > - > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Sever connectivity > http://www.informed-solutions.com > - > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
On Mon, Mar 6, 2017 at 3:25 PM, truegold via 4D_Tech <4d_tech@lists.4d.com> wrote: > Our users have also found the new query dialog less intuitive. They > expressed that having to use popup buttons required extra steps. And > because some checkboxes are now hidden in the popup they forget about it. > And other more subtle things. > > So for them it’s extra work! > > And, yes, I agree some things are more intuitive but I still prefer the > “Classic” view myself. > > So I have used Miyako's dialog and the clients are happier. > > Not sure why 4D had to do away completely with a common editor that has > been used for many years. Couldn’t the have offered both? > > Anyway, my thoughts. > One more thing the new query dialog allows user to control whether query selection or create new selection. Sometimes the developer needs those controls in place Regards Chuck -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Sever connectivity http://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
Hey Keith, Our users have also found the new query dialog less intuitive. They expressed that having to use popup buttons required extra steps. And because some checkboxes are now hidden in the popup they forget about it. And other more subtle things. So for them it’s extra work! And, yes, I agree some things are more intuitive but I still prefer the “Classic” view myself. So I have used Miyako's dialog and the clients are happier. Not sure why 4D had to do away completely with a common editor that has been used for many years. Couldn’t the have offered both? Anyway, my thoughts. John... > … >> For a number of reasons we decided to shield our users from 4D’s new query >> dialog, which we find not intuitive… > > That surprises me. > We found the v15 4D search interface really easy to understand. > I guess we must be used to very different interfaces. > Cheers, Keith ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
Hi Arnaud, Funny, I just got asked about this on Friday. I would also be interested to know the bets way to handle older (I think they’re all from v12) Query files. Appreciate, John... >> Le 6 mars 2017 à 13:45, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> a >> écrit : >> >> Miyako's dialog works quite well but has just one drawback: it can’t open >> .4DF files created with v12. [...] I was hoping to find a way to do this in >> a batch process programmatically. Our users have hundreds of .4DF files to >> convert… >> >> Any suggestions? > > I had some code to read 4df document that I began to adapt to v11 but gave > up. It could be a starter, if you don't find better. > > -- > Arnaud de Montard ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
… > For a number of reasons we decided to shield our users from 4D’s new query > dialog, which we find not intuitive… That surprises me. We found the v15 4D search interface really easy to understand. I guess we must be used to very different interfaces. Cheers, Keith ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Saved query files (.4df) and changes from v12 to v15 - automated conversion?
> Le 6 mars 2017 à 13:45, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > Miyako's dialog works quite well but has just one drawback: it can’t open > .4DF files created with v12. [...] I was hoping to find a way to do this in a > batch process programmatically. Our users have hundreds of .4DF files to > convert… > > Any suggestions? I had some code to read 4df document that I began to adapt to v11 but gave up. It could be a starter, if you don't find better. -- Arnaud de Montard ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **