The Grid View below lists all invoice lines of the database. All fields are searcheable, and can be sorted.
The implementation is very easy with RelatedSearchBehavior. Check out the 'Invoiceline' model to see how it is done.
In the left corner above you may have access to debug functionnality. Click on "DB Query" to see the SQL queries, and specifically the search query near the end.
The database is open source from http://chinookdatabase.codeplex.com The schema is shown further below.
Displaying 1-4 of 2240 results.
Invoice | Track Name | Composer | Unit Price | Album Title | Artist | Media Type | Genre | Last Name | First Name | Support Last Name | Support First Name | Support Phone | Support Email |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
306 | Camarão que Dorme e Onda Leva | Acyi Marques/Arlindo Bruz/Braço, Beto Sem/Zeca Pagodinho | 0.99 | Ao Vivo [IMPORT] | Zeca Pagodinho | MPEG audio file | Latin | Wichterlová | František | Park | Margaret | +1 (403) 263-4423 | margaret@chinookcorp.com |
306 | Coração Em Desalinho | Mauro Diniz/Ratino Sigem | 0.99 | Ao Vivo [IMPORT] | Zeca Pagodinho | MPEG audio file | Latin | Wichterlová | František | Park | Margaret | +1 (403) 263-4423 | margaret@chinookcorp.com |
201 | Faixa Amarela | Beto Gogo/Jessé Pai/Luiz Carlos/Zeca Pagodinho | 0.99 | Ao Vivo [IMPORT] | Zeca Pagodinho | MPEG audio file | Latin | Stevens | Victor | Johnson | Steve | 1 (780) 836-9987 | steve@chinookcorp.com |
411 | Feirinha da Pavuna/Luz do Repente/Bagaço da Laranja | Arlindo Cruz/Franco/Marquinhos PQD/Negro, Jovelina Pérolo/Zeca Pagodinho | 0.99 | Ao Vivo [IMPORT] | Zeca Pagodinho | MPEG audio file | Latin | Hämäläinen | Terhi | Peacock | Jane | +1 (403) 262-3443 | jane@chinookcorp.com |
