Caché Web Applications Tutorial
CategoryName Query
[Back] 
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Search:    

Here's the code for the CategoryName query. The query should be part of the FilmCategory class.

—CategoryName—
Query CategoryName() As %Library.SQLQuery(CONTAINID = 1, ROWSPEC = 
"ID,CategoryName:%Library.String")
{
 SELECT ID, CategoryName
 FROM FilmCategory
 ORDER BY CategoryName
}