Query Method -Stream Property

Question

Question

sansa stark · Sep 20, 2016

Hi all,

In CSP page we get data from Class via Query method.

<TD valign=top>#(DEOBJ.Get("Comments").Read())#</TD>

The problem is we couldn't get the stream property value.

(Property Comments As %Stream.GlobalBinary)

Thanks,

sansa.

Discussion (2)0

Log in or sign up to continue

Eduard Lebedyuk · Sep 20, 2016

In the underlying SQL write

 SELECT SUBSTRING(Comments, 1, 100) As Comments, ... FROM TABLE

to get first 100 characters from the stream. More info.

0 0

score 0 · Answer 1 · 2016-09-20T08:30:17-04:00

sansa stark · Sep 20, 2016

Thank you

0 0