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.
InvoiceTrack NameComposerUnit PriceAlbum TitleArtistMedia TypeGenreLast NameFirst NameSupport Last NameSupport First NameSupport PhoneSupport Email
103Muita BobeiraLuciana Souza0.99Duos IILuciana Souza/Romero LubamboAAC audio fileLatinRalstonFrankPeacockJane+1 (403) 262-3443jane@chinookcorp.com
208Din Din Wo (Little Child)Habib Koité0.99Muso KoHabib Koité and BamadaAAC audio fileWorldHansenBjørnParkMargaret+1 (403) 263-4423margaret@chinookcorp.com
313Love ComesDarius "Take One" Minwalla/Jon Auer/Ken Stringfellow/Matt Harris0.99Every Kind of LightThe PosiesAAC audio fileRockMercierIsabellePeacockJane+1 (403) 262-3443jane@chinookcorp.com
2Put The Finger On YouAngus Young, Malcolm Young, Brian Johnson0.99For Those About To Rock We Salute YouAC/DCMPEG audio fileRockHansenBjørnParkMargaret+1 (403) 263-4423margaret@chinookcorp.com