go to post Iryna Mykhailova · Aug 28 All points ticked! Some with photographic proof 😉 Went to the sea or a lake Hiked/enjoyed nature Traveled somewhere new Attended a concert or festival Watched a movie or series Read a book Earned points and redeemed a reward on Global Masters 🏆 Joined READY 2025 🎉 Spent time with family or friends
go to post Iryna Mykhailova · Aug 17 @Dmitry Maslennikov and @Robert Cemper I started doing some research regarding this, here is one mention of it being more efficient: link. Here it goes in a bit more detail.
go to post Iryna Mykhailova · Aug 15 I may be imagining things, but I think the "strange" names for the globals are there for a specific reason - to make access faster. I will have to do some research in documentation or in Learning materials, but it came up during my preparation for InterSystems SQL Specialist certification. So, I would suggest leave the names as they are unless you're planning to go directly through globals to work with data.
go to post Iryna Mykhailova · Jul 21 Congratulations to the winners! The ideas were really well presented in this contest!
go to post Iryna Mykhailova · Jun 13 Thanks for this summary, it doesn't sound too complicated to create an agent.
go to post Iryna Mykhailova · Mar 28 Points made by Enrico are 100% valid and you may need to consider them. In your case, because your column is not named, you can use GetData(n) to get the count: set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'" set resultset = ##class(%ResultSet).%New("%DynamicQuery:SQL") set SC = resultset.Prepare(sql) set SC = resultset.Execute(sql) write resultset.GetData(1) Obviously don't forget to check the statuses.
go to post Iryna Mykhailova · Mar 24 As far as I know training does not include certification but it will obviousely increase your chances to answer more questions correctly and thus receive certification. In any case, I would definitely recommend doing the offline course - it's money well invested.
go to post Iryna Mykhailova · Feb 20 Well deserved, congratulations! I always read your FAQ articles, useful stuff! Good luck with obtaining the black belt! Coming from a blue belt in Kung Fu 😁