Skip to main content
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