Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

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
}
Copy code to clipboard