Hi Norman,
Quote() method of %Global might be what you are lookig for:
USER>write ##class(%Global).Quote($lb("abc", """", $c(13, 10)))
$lb("abc","""",$c(13,10))
Hi Yone,
There is the class iscru.util.StreamUtils designed exactly for the purpose to solve problems like yours. The class contains streamLike() method that can be called directly or from SQL. It can also be used within business rules via iscru.util.FunctionSet.
If you want to enable searching on stream properties with Like/NotLike operators in the Message Viewer, then you would need to import
set ^EnsPortal.Settings("MessageViewer","AssistantClass") = "iscru.util.MsgFilterAssistant"
Once you've done that, you can try Like operator against stream properties in the Message Viewer.
DISCLAIMER: The classes mentioned above have not been used much in real world projects yet. However there are some unit tests in the repo.
HTH, Dmitry
Please visit OEX page for updated installation instructions for 2020.4 or newer versions of InterSystems IRIS for Health.