Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

CategoryName Query

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

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