Announcement Evgeny Shvarov · Oct 1, 2016 Developer Community Articles and Questions Digest, September 2016 Hi, Community!Here is the digest of Articles and Questions published on InterSystems Developer Community in September 2016.Most viewedMirroring 101: a brief guide and FAQ - 238NewBie's Corner Session 27 Traversing A Global with $Order Part 1 - 214Cache for Raspberry Pi? - 209Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!* - 199REST in Pieces - 196User authentication using Arduino with RFID - 146Windows 7 performs shutdown too fast for Cache to close and so it gets forced down - 143Cache or Caché? - 141NewBie's Corner Session 28 Various Methods to Traverse a Global - 134Cache Certification - 128Most votedEnsemble and file outbound adapters - a small hint - 11Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!* - 9Windows write caching - 9Advanced URL mapping for REST - 6Windows 7 performs shutdown too fast for Cache to close and so it gets forced down - 6Featured InterSystems Video: OAuth 2.0 Overview - 6The Art of Mapping Globals to Classes (2 of 3) - 5Running HealthShare XSLTs from Terminal - 5Cache for Raspberry Pi? - 5Cache or Caché? - 5Most commentedNewBie's Corner Session 27 Traversing A Global with $Order Part 1 - 16Cache for Raspberry Pi? - 14question on ExternalFreeze on windows platform -- - 14Cache or Caché? - 12Mirroring 101: a brief guide and FAQ - 10Windows 7 performs shutdown too fast for Cache to close and so it gets forced down - 9Multiple namespaces in web application - 8cleaning up CSP sessions (aka where/who/what is the %CSP.Daemon?) - 8NewBie's Corner Session 28 Various Methods to Traverse a Global - 8Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!* - 7 #Digest #Developer Community Official 0 0 0 351
Question Evgeny Shvarov · Sep 19, 2016 Tag for the newbies posts Hi, Community!We want to introduce tag for the posts, which are related to the newbies.What is the best tag for it?Newbie's corner?Newbie?Beginner?Your option? #DC Feedback 0 6 0 217
Announcement Evgeny Shvarov · Sep 13, 2016 Developer Community FAQ Hi, Community!I've introduced new "Developer Community FAQ" tag, which gathers all the posts on "How to make this on Developer Community".Also, you can find this link in the Learn menu. See the screenshot: #Developer Community Official 2 2 0 281
Announcement Evgeny Shvarov · Sep 1, 2016 InterSystems Developer Community August 2016 Digest Here is the digest of the most interesting and valuable posts on Developer Community published in August 2016.Here we go!News, events, releasesJSON changes in Caché 2016.2Announcement about the Caché 2016.2 and 2016.3 Field Test ProgramsAlert: Database Compaction2016.1.2 Maintenance ReleaseMost viewedAnnouncement about the Caché 2016.2 and 2016.3 Field Test Programs - 406JSON changes in Caché 2016.2 - 306What is causing the journals to grow rapidly? - 197Writing forward compatible JSON in 2016.1 - 190how to connect to the Cache database from node.js ? - 188Caché MapReduce - introduction to BigData and MapReduce concept - 155NewBie's Corner Session 17 New command - 153Global references done internally by Cache - 145Tips & Tricks - Process-private Globals as a class storage - 118ZUTILS - 114Most votedImprove SQL Performance for Date Queries, AGAIN! - 8JSON changes in Caché 2016.2 - 8Caché MapReduce - introduction to BigData and MapReduce concept - 7Announcement about the Caché 2016.2 and 2016.3 Field Test Programs - 7Writing forward compatible JSON in 2016.1 - 7HealthShare's new SDA extensions - 6The Art of Mapping Globals to Classes 1 of 3 - 6Enterprise Monitor and HealthShare - 5What is causing the journals to grow rapidly? - 4TLS v1.2 support in Caché - 4Most commentedSetting ContentType in Rest Service - 13Use of $ZUTIL(49) is deprecated - 11CSP CONFIGURATION - 10Announcement about the Caché 2016.2 and 2016.3 Field Test Programs - 10Calling javascript method from Zen method, with parameters - 9Git Continuous Integration - What are the most important differences between CacheGitHubCI and CacheUpdater? - 8how to connect to the Cache database from node.js ? - 7What is causing the journals to grow rapidly? - 7Problem in the Property parameters (DISPLAYLIST | VALUELIST) [ SOLVED ] - 7NewBie's Corner Session 17 New command - 7 #Digest #Developer Community Official 0 0 0 337
Article Evgeny Shvarov · Aug 31, 2016 1m read DeepSee cubes building troubleshooting Hi! Sometimes you see that call to DeepSee cube building method: w ##class(%DeepSee.Utils).%BuildCube("CubeName") does nothing. Here are my 2 cents on possible reasons. 1. Run DeepSee Reset method in certain Namespace: NAMESPACE> w ##class(%DeepSee.Utils).%Reset() and try again. 2. Make sure, that all the indices in your base class for the cube are rebuilt, rebuild them and run it again: #InterSystems Reports (DeepSee, BI) #Cubes #Tips & Tricks 1 2 0 390
Article Evgeny Shvarov · Aug 16, 2016 1m read Yet another use case for $translate: date conversion Have you tried $Translate for date conversion? USER>write $Translate("Dd.Mm.WwYy","WwYy-Mm-Dd","2015-08-02") 02.08.2015 Stolen from Russian forum and Alexander Koblov. #Code Snippet #ObjectScript #Tips & Tricks #Caché 1 1 0 607
Announcement Evgeny Shvarov · Aug 1, 2016 Developer Community July 2016 Digest Hi, Community!Here is the digest of the most interesting and valuable posts on Developer Community published in July 2016.Here we go!News, events, releases2015.2.4 Maintenance ReleaseDeveloper Community email notification subscriptionsSerenji 2.6 is now available #Digest #Developer Community Official 1 0 0 304
Discussion Evgeny Shvarov · Jul 29, 2016 Tag proposal - Performance Do we need tag Performance to mark posts related to recipes of better performance for InterSystems based solutions? Vote please, if we need it! #DC Feedback 2 0 0 203
Question Evgeny Shvarov · Jul 28, 2016 Pivot variables deployment Hi!How do you guys deploy DeepSee pivot variables?Haven't found it in documentation.Thank you in advance! #InterSystems Reports (DeepSee, BI) 0 5 0 339
Article Evgeny Shvarov · Jul 27, 2016 1m read Tips & Tricks. Be aware of Month->Week hierarchy in DeepSee Hi, Community!You know, that when we build hierarchies in DeepSee dimension all the members of lower level should be the part of one member of the higher level.If not you'll get some empty results in MDX queries with this hierarchy.With Time dimensions the obvious valid hierarchy is Year->Month->Day, cause every Month consists of one Year and every day consists of one month. #InterSystems Reports (DeepSee, BI) #Tips & Tricks 2 3 0 404
Question Evgeny Shvarov · Jul 27, 2016 Add Tag Tips&Tricks discussion Hi, Community!We want to introduce tag Tips & tricks.It's not a snippet sometimes, but some small piece of best practice and useful experience. Please vote if you think it makes sense and we need this tag and we'll introduce it as the first level tag in taxonomy. #DC Feedback 4 1 0 154
Article Evgeny Shvarov · Jul 25, 2016 2m read Developer Community email notification subscriptions Hi, Community!Today there are two main settings for your email notification subscriptions.1. Subscribe to all new posts, all comments, all answersYou can do it in your subscription settings in the Content Types. Click on My Account, go to Subscriptions and click on Content types tab: #DC Feedback #Developer Community FAQ 1 15 1 826
Article Evgeny Shvarov · Jul 14, 2016 1m read Caché Haiku Alex Koblov posted today a #CachéHaiku: Full command names Make your code more readable Than compact versions My haiku: Caché Globals Shows you keys to the value If you $order it Your variant? ;) #Caché 8 19 1 1K
Question Evgeny Shvarov · Jul 8, 2016 Top from the group SQL query in Caché Hi!There is interesting question in Stackoverflow.This query works for MS SQL: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY client_id ORDER BY date_updated DESC) AS rn FROM client_address ) a WHERE a.rn = 1 There is one answer there, which solves the task: #SQL #Caché 2 5 0 2.3K
Announcement Evgeny Shvarov · Jul 1, 2016 Developer Community June 2016 Digest Hi!Here is the digest of the most interesting and valuable posts on Developer Community published in June 2016.Here we go!News, Events, releasesUpdate to 2016.1.1 Maintenance Release2016.1.1 Maintenance Release2016.2 Field Test Kit 2016.2.0.677.0Most viewed #Digest #Developer Community Official 4 0 0 422
Announcement Evgeny Shvarov · Jun 30, 2016 June 30th DC release Hi, Community!I'm pleased to announce the new Developer Community release today. Meet the changes!New voting systemNow you can vote for the post or comment with like or dislike buttons to change the post/comment rating.Previous ratings converted to the new rating with the following rule:4,5 stars = +11,2,3 stars=0.Improved email notificationsYou should receive HTML notifications now on new posts and comments on DC.Please share your feedback with the recent release. #DC Feedback #Release 4 4 0 213
Question Evgeny Shvarov · Jun 23, 2016 How to extract the root in Caché properly Hi! Here is the question in Russian Forum regarding roots extracting. In Caché ObjectScript we use exponentiation operator (**) to raise an exponent to power. F.e. let's raise 3 to power of 3: USER> write 3**3 27 And we use the same operator to extract the root. USER> write 27**(1/3) 2.999999999999999963 And 2.999999999999999963 is not 3, obviously. How to extract roots properly in Caché ObjectScript? #Caché #ObjectScript 0 5 0 391
Article Evgeny Shvarov · Jun 13, 2016 1m read Debug: using locks for breakpoints Hi, Community! Want to share with you one debugging approach from the Russian forum. Suppose I want to debug the application and I want it to stop the execution on a particular line. I add in code this line: l +d,-d When I want to start debugging in this line I block d in terminal USER> l +d And execute the app. The app stops on this line and lets me connect to it with Studio debugger. #Best Practices #Debugging #ObjectScript #Caché 0 8 1 628
Article Evgeny Shvarov · Jun 8, 2016 1m read How to post an article from Word or Google Docs Hi, Community!If you prepare your longread for DC in Microsoft Word or Google Docs there is one very easy way how to add your formatted text and images in DC post at once.To make it do the following:1.Click Create Post on Developer Community.2. Copy all the text in Word o GDocs to the buffer.3. Click the button Paste from word (see the shot):4. Paste the text to the opened window an press OK. #DC Feedback #Developer Community FAQ 0 7 0 505
Announcement Evgeny Shvarov · Jun 1, 2016 Developer Community May Digest Hi!Here is the digest of the most interesting and valuable posts on Developer Community published in May 2016.Here we go!News and EventsCaché and Ensemble 2016.3 field test now available2016.2 Field Test Kit 2016.2.0.665.0 #Digest #Developer Community Official 1 0 0 500