I will use pRequest.CS from now. :-)
1) $replace(pRequest.GetValueAt("MSH::MessageType.MessageType),"^","") instead of pRequest.GetValueAt("MSH::MessageType.MessageStructure",,tSC)
2) $e($zdt($h,8),1,8) instead of $tr($zdt($h,3),"-: ","")
Where Ucase(FirstName||' '||LastName) Like '%PRAJA%'
Like old good days. ;-)
I didn't notice that you have your "personal" schema category : ORUBeakerLAB
You forget that : PIDgrpgrp().
I don't have ?!?
What purpose for the max RowId ?
I don't have a great knowledge about InterSystems plans.
But, generally, you just should first delete your plan and then recreate the index.
35 seconds were quite important!
How much records or mostly probably different jointures on tables?
Don't rely too much on this !
To leave a comment or answer to post please log in
Please log in