Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new window

For information on migrating to InterSystems IRISOpens in a new window, see the InterSystems IRIS Migration Guide and Migrating to InterSystems IRIS, both available on the WRC Distributions pageOpens in a new window (login required).

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
FeedbackOpens in a new window