Iryna Mykhailova · Oct 13, 2025 go to post

My most sincere congratulations to the winners - the competition was really fierce this time!

Iryna Mykhailova · Sep 16, 2025 go to post

Congratulations to everyone! It was such an exciting initiative. Looking forward to next year!

Iryna Mykhailova · Aug 28, 2025 go to post

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
Iryna Mykhailova · Aug 15, 2025 go to post

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.

Iryna Mykhailova · Mar 28, 2025 go to post

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.

Iryna Mykhailova · Mar 24, 2025 go to post

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.

Iryna Mykhailova · Feb 20, 2025 go to post

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 😁

Iryna Mykhailova · Jan 22, 2025 go to post

I'm very honored to be among the best authors of the Developer Community in different nominations! Congratulations to everyone!