Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

The Modified TopFilms Query

Here is the TopFilms query with the “dummy” parameter Param1 added.

—TopFilms—
TopFilms
Query TopFilms(Param1 As %Library.String) As %SQLQuery(CONTAINID = 2)
{
SELECT TOP 3 Description,%ID,Length,Rating,Title,Category->CategoryName 
FROM Film
 WHERE (PlayingNow = 1)
 ORDER BY TicketsSold DESC
}
Feedback