- Log in to post comments
User bio
404 bio not found
Member since Feb 4, 2016
Posts:
Replies:
@Brett Saviano Is there something needed to enable Show Plan. I checked my extensions and none of them say I need updating. Additionally while it is great to have the action to Show Plan for a class query, InterSystems Studio allowed us to select any text-Right Click-Show Plan. This is useful when either you have a Dynamic SQL statement inside of a method or you are using embedded SQL with or without a cursor such as
&SQL(DECLARE Loop CURSOR FOR
SELECT %Id,Super
INTO :tClass,:tSuper
FROM %Dictionary.CompiledClass
WHERE %Id %STARTSWITH :Prefix AND GeneratedBy IS NULL AND COALESCE(Deployed,0)=0
AND (Super not like '%DeepSee.KPIPlugIn')
FOR READ ONLY
)
&SQL(OPEN Loop)
For {
&SQL(FETCH Loop)- Log in to post comments
Hooray for
- Show Plan
- Open Error Location
Great work and many thanks
- Log in to post comments
Certifications & Credly badges:
Followers:
Following:
Stephen has not followed anybody yet.
The Whole Record/Composite View is controled by Composite Record Definition which controls
A Composite Record definition can contain several kinds of elements, including:
Property groups
Trust blocks
The composite Record Definition includes the method
classmethod displayResults(nobjArray, meta, metaStatic)
which you may find useful to change the meta data/field labels of your choice. While this isnt formal localization you may find you can accompilsh your goal in this method.