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
