Why doesn't this %Library.ResultSet ClassName/QueryName doesn't work?
Hi Guys,
So I've been following this guide in using a %Library.ResultSet with a ClassName / QueryName as described in the first example.
https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic....
The code I've got so far doesn't work and is as follows:
set rs=##class(%ResultSet).%New()
set rs.ClassName="GMECC.DocmanConnect.Tables.vwNewGPs"
set rs.QueryName="GetRows"
set sc=rs.Execute("a") If $$$ISERR(sc) Do DisplayError^%apiOBJ(sc) Quit
while rs.%Next() { do rs.%Print() }
And the referenced class is
Class GMECC.DocmanConnect.Tables.vwNewGPs [ ClassType = view, CompileAfter = (GMECC.DocmanConnect.Tables.Endpoints, GMECC.DocmanConnect.Tables.PARIS.AUDUAGUMECCPRAC), DdlAllowed, Not ProcedureBlock, SqlTableName = vwNewGPs, ViewQuery = {
// Bunch of SQLCode
} ]
{
Query GetRows() As %SQLQuery
{
select *
from GMECC_DocmanConnect_Tables.vwNewGPs
}
}
When code when run, produces the follow error:
What am I doing wrong, can anyone offer any insight?
Product version: IRIS 2021.2
$ZV: IRIS for Windows (x86-64) 2021.2.1 (Build 654U) Fri Mar 18 2022 06:09:35 EDT