Caché Web Applications Tutorial
The Modified TopFilms Query
[Back] 
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
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
}