Caché Web Applications Tutorial
The Modified TopFilms Query
[Home] [Back] 
InterSystems: The power behind what matters   
Class Reference   
Search:    

Here is the TopFilms query with the “dummy” parameter Param1 added.

—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
}