How to searching text stream columns in SQL
I have a table with a Varchar(max) column that I have created via the HealthShare SQL portal, and I see that in it's underlying class that column corresponds to a
When I try to do a text search on that column (referenced as cd.Code in the example below) I get an error
select *
from DevTools_CodeAnalysis_tables.Code cd
inner join DevTools_CodeAnalysis_tables.MethodData mtd
on charindex( mtd.qualifiedRef, cd.Code) > 0
ObjectScriptObjectScript
It produces the error
Scalar function CHARINDEX (arg2) not supported for stream fields
How do I search it?
Product version: IRIS 2021.2
$ZV: IRIS for Windows (x86-64) 2021.2.1 (Build 654U) Fri Mar 18 2022 06:09:35 EDT
I've found out what I need to do with the following link, a section titled "Predicate Conditions and Streams" from the page "Storing and Using Stream Data (BLOBs and CLOBs)"
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...