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 20 1 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.4K
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 444
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 237
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 436
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 697
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 566
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 521
Question Evgeny Shvarov · May 30, 2016 Solution for T9 Spelling Problem in Caché ObjectScript Hi, Community! Last weekend we held the Final of InterSystems Contest on Caché, DeepSee and iKnow under the aegis of IT Planet Student Championship in Ekaterinburg. BTW, this year we had more than 1,400 participants in InterSystems Contest. #Caché #ObjectScript 3 20 0 1.3K
Announcement Evgeny Shvarov · May 16, 2016 DC Statistics: 2000 comments! 1000+ posts! Hi, Community!Today we reached 2000 comments and answers on DC! The comment was made by Fabio Gonsalves!Also, a couple of weeks ago we had the 1000th post by Murray Oldfield!And we have 1,227 DC members today! #Digest #Developer Community Official 2 1 0 194
Announcement Evgeny Shvarov · May 13, 2016 Meet InterSystems Developer Community Twitter! Hi, Community!We've launched Twitter for InterSystems Developer Community!Follow us to be in touch what happens on InterSystems Developer Community. Find valuable postings, hot discussions and best practices links there. You can also retweet and like what you find significant!See how it looks:Join! #Developer Community Official 3 5 0 514
Question Evgeny Shvarov · May 12, 2016 Full series of dates in Time Dimensions in DeepSee Hi!Sometimes, especially when I work with Combined Cubes, I need to have all the dates in Date Dimension, not only members with rows in Fact table.Is there any way to switch it on? #InterSystems IRIS BI (DeepSee) 1 6 0 383
Article Evgeny Shvarov · May 11, 2016 1m read The simplest snippet to read from file in InterSystems IRIS Hi! I believe the simplest is (to work with csv delimited by ";"): set file = ##class(%File).%New( "data.csv" ) set sc = file.Open( "R" ) if $$$ISERR(sc) quit ; or do smth while 'file.AtEnd { set str=file.ReadLine() for i=1:1:$length( str, ";" ) { set id=$piece( str, ";" ,i ) write !, id // or do smth } } do file.Close() Possible options: different variants of error handling with sc code. Embrace while loop into try/catch block. And what's yours? #Code Snippet #CSV #ObjectScript #Caché #InterSystems IRIS 3 16 0 7.2K
Announcement Evgeny Shvarov · May 5, 2016 Developer Community April 2016 Digest Hi!Here is April digest of most interesting and valuable postings on Developer Community in April 2016.Here we go!News and EventsInterSystems Global Summit 2016 - Session ContentSources for InterSystems Global Summit 2016 Sessions and Expereiences2015.2.3 Maintenance Release #Digest #Object Data Model #Developer Community Official 1 0 0 379
Question Evgeny Shvarov · Apr 24, 2016 Import/export data from InterSystems IRIS Hi! Suppose I have full access to InterSystems IRIS database instance A and want to export a consistent part of the data and import it into another InterSystems IRIS instance B. Classes are equal. What are the most general and convenient options for me? TIA! #Databases #Data Import and Export #Object Data Model #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 18 0 7.2K
Article Evgeny Shvarov · Apr 16, 2016 1m read Try catch block I usually use in InterSystems ObjectScript Hi! Want to share with you code snippet of try catch block I usually use in methods which should return %Status. { try { $$$TOE(sc,StatusMethod()) } catch e { set sc=e.AsStatus() do e.Log() } Quit sc } Here $$$TOE is a short form of $$$TROWONERROR macro. Inside macro StatusMethod is any method you call which will return %Status value. This value will be placed into sc variable. #Code Snippet #ObjectScript #Caché #InterSystems IRIS 6 21 2 3.4K
Question Evgeny Shvarov · Apr 16, 2016 Atelier project hidden files. What should I commit? Hi!In every Atelier project you can find following hidden files:.buildpath.version.connection.project.Should I include all of them into commit?I understand that .project is mandatory. But what about the rest? Is there any general rule?F.e. if we work in team and everybody has their own connection on locale machine .connection should not be included. Yes? 1 1 0 401
Article Evgeny Shvarov · Apr 15, 2016 2m read Sources for InterSystems Global Summit 2016 Sessions and Experiences Hi! Please find all the source code Global Summit 2016 Sessions and Experiences in following GitHub repositories: #Global Summit 2016 #ObjectScript #Summit 4 1 0 970
Question Evgeny Shvarov · Apr 5, 2016 How to avoid writing duplicate code in dtl InterSystems Ensemble Hi! There is a question for Ensemble on Stackoverflow:I have the below dtl. In the foreach loop, I am just copying the same code in another part under anif condition. How can I avoid this redundancy? Can I reuse using sub transformation?Here is the dtl class file :https://docs.google.com/document/d/1snJXElyw13hAfb8Lmg5IaySc7md_DE8J40FB79hBaXU/edit?usp=sharing #Ensemble 1 2 0 594
Announcement Evgeny Shvarov · Apr 1, 2016 Developer Community March 2016 Digest Hi, Community!Here is the digest of the most interesting and valuable articles published on Developer Community in March 2016.If we missed something interesting, please feel free to add it in comments.So, here we go!News and EventsCaché and Ensemble 2016.1 ReleaseNew Book, Caché and MUMPS – Part II #Digest #Developer Community Official 3 0 0 413