Production message filtering: How could we find a substring inside a GlobalCharacterStream?

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  iscru.util.MsgFilterAssistant class as well, then give  permission to run iscru_util.FunctionSet_streamLike stored procedure to the user, and run the following command in your namespace: 

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

Hola Yone, 

es posible que tengas que utilizar una consulta SQL utilizando la funcion "substring" para acceder al contenido del stream.

Algo como: 

SELECT ID, SUBSTRING(resultado,1) FROM Tabladondesealmacenanesosmensajes where ID>'algunidparanobuscarentodalatabla' AND SUBSTRING(resultado,1) LIKE '%C0006%'

Referencia

View stream properties in SQL | InterSystems Developer Community | SQL