When the comparison string ('ABC%' and 'ABC') is fixed.
AH ok
Well, the result is not always the same: I just found out that you should be careful when working with :variables, for example in %SQLQuery:
select 1 where 'well...' %startswith :myvar
Returns 1 row for myvar being null.
Whereas
select 1 where 'well...' like :myvar||'%';
Does return no row for myvar being null.
Using IRIS for Windows (x86-64) 2021.1 (Build 215) Wed Jun 9 2021 09:56:33 EDT
Certifications & Credly badges:
Malte has no Certifications & Credly badges yet.
Global Masters badges:
Followers:
Malte has no followers yet.
Following:
Malte has not followed anybody yet.
Good idea. This might work:
ClassMethod HandleJSON() { S Results= { "ClassA":{"ClassName":"ClassA","ACount":367191880,"BCount":367191880,"CurrentDiff":0,"PreviousDiff":0,"ReportDate":"2024-03-02 00:00:00"}, "ClassB":{"ClassName":"ClassB","ACount":5352149227,"BCount":5352149227,"CurrentDiff":0,"PreviousDiff":0,"ReportDate":"2024-03-02 00:00:00"} } w ..GetCsv(Results.%ToJSON()) } ClassMethod GetCsv(json As %String) As %String [ Language = python ] { import pandas df = pandas.read_json(json, orient="index") return df.to_csv(index=False) }