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 section

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
}
Copy code to clipboard