Class parameter in class query
Is it possible to use a class parameter in class query?
Example:
Class SomeClass
{
Parameter SOMENAME = "Name1";
Query SomeQuery() As %SQLQuery
{
SELECT ID || ..#SOMENAME || Name FROM Table
}
}Discussion (3)0
Comments
This can be done with SQL procedure:
Query SomeQuery() As %SQLQuery
{
SELECT ID || SomeClass.GetParam('SomeClass', 'SOMENAME') FROM Table
}
ClassMethod GetParam(class, param) As %String [ CodeMode = expression, SqlProc ]
{
$parameter(class, param)
}Fantastic help. Thank for sharing this. I didn't know you could use ##Expression in basic class queries. Studio does complain about it though but works just fine at run time!
Class dc.SomeClass
{
Parameter SOMENAME = "Name1";
Query SomeQuery(SOMENAME = {..#SOMENAME}) As %SQLQuery
{
SELECT ID || :SOMENAME || Name FROM Table1
}
Query SomeQuery1() As %SQLQuery
{
#define SOMENAME ##Expression("'"$parameter("dc.SomeClass","SOMENAME")"'")
SELECT ID || $$$SOMENAME || Name FROM Table1
}
Query SomeQuery2() As %SQLQuery
{
#define SOMENAME ##Expression("'"##class(dc.SomeClass).#SOMENAME"'")
SELECT ID || $$$SOMENAME || Name FROM Table1
}
ClassMethod Test()
{
;d ##class(dc.SomeClass).Test()
s rs=##class(%ResultSet).%New("dc.SomeClass:SomeQuery")
s sc=rs.Execute()
i $$$ISERR(sc) {
d $System.Status.DisplayError(sc)
} else {
d rs.%Display()
}
}
}