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