User bio
404 bio not found
Member since Nov 9, 2015
Posts:
Replies:
Have you had a look at %RoutineIndex::RebuildIndex? The documentation suggests this does what you want: https://docs.intersystems.com/irisforhealthlatest/csp/documatic/%25CSP.D.... It should be available in the version of Ensemble you're running.
You can also set this at a workspace or user level by going into Settings -> Extensions -> InterSystems ObjectScript and updating the "ObjectScript Compile Flags" setting:
Certifications & Credly badges:
Jolyon has no Certifications & Credly badges yet.
Global Masters badges:
Jolyon has no Global Masters badges yet.
Followers:
Jolyon has no followers yet.
Following:
Jolyon has not followed anybody yet.
You can use the SQL DATEDIFF function in ObjectScript to get the number of minutes and divide by 60:
write $system.SQL.Functions.DATEDIFF("mi","2024-07-12 08:30:00","2024-07-12 15:15:00")/60 6.75
Documentation is here: https://docs.intersystems.com/iris20252/csp/documatic/%25CSP.Documatic.c...
You can pass "hh" in as the first argument to get hours, but only returns whole hours rounded up. If you need second accuracy, you can pass in "ss" for "seconds" and divide by 3600 instead.