All
Accepted answers
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!

Iryna Mykhailova · Oct 11, 2024 go to post

Thank you for this suggestion.

PS. Being fluent in Russian won't help in this case, because the interface is in Ukrainian 😁