Skip to main content
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