Added a new idea Add a "mentor mode" to Management portal
- Log in to post comments
Added a new idea Add a "mentor mode" to Management portal
My most sincere congratulations to the winners - the competition was really fierce this time!
Congratulations! You more than deserve it!
Congratulations to everyone! It was such an exciting initiative. Looking forward to next year!
Well, you should really keep track of your TSTARTs 😁
Love the initiative! I know what I'm going to write about next 😉
Your manor house looks like a bigger version of this
.png)
You can always gift some to me 😁
.png)
I can even be your test points receiver 😆😉
All points ticked! Some with photographic proof 😉
.png)
.png)
.png)
.png)
@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.
Well deserved, congratulations!
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.
Congratulations! Well done everyone!
Congratulations to the winners! The ideas were really well presented in this contest!
Code and minds unite,
In the Community space
InterSystems shines
9 out of 12, not bad
Congrats @Dmitry Maslennikov, well deserved!
It was a great event full of interesting info and people!
Thanks for this summary, it doesn't sound too complicated to create an agent.
Congratulations everyone! Great result.
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.
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.
Congratulations to everyone! Great articles all around!
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 😁
It's like it was done on purpose 😁
Wow, lots of interesting stuff happened last year!
I'm very honored to be among the best authors of the Developer Community in different nominations! Congratulations to everyone!