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.


Query TopFilms(Param1 As %Library.String) As %SQLQuery(CONTAINID = 2)
SELECT TOP 3 Description,%ID,Length,Rating,Title,Category->CategoryName 
 WHERE (PlayingNow = 1)
 ORDER BY TicketsSold DESC
Copy code to clipboard