User bio
404 bio not found
Member since Jan 26, 2016

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

Open Exchange applications:
Dmitry has no followers yet.
Dmitry has not followed anybody yet.
Global Masters badges:
Dmitry has no Global Masters badges yet.