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.


Query CategoryName() As %Library.SQLQuery(CONTAINID = 1, ROWSPEC = 
 SELECT ID, CategoryName
 FROM FilmCategory
 ORDER BY CategoryName
Copy code to clipboard