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
}