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 17-20 of 2240 results.
InvoiceTrack NameComposerUnit PriceAlbum TitleArtistMedia TypeGenreLast NameFirst NameSupport Last NameSupport First NameSupport PhoneSupport Email
411Um Homem Chamado Alfredo 0.99Vinicius De MoraesVinícius De MoraesMPEG audio fileLatinHämäläinenTerhiPeacockJane+1 (403) 262-3443jane@chinookcorp.com
95Big MachineDave Kushner, Duff, Matt Sorum, Scott Weiland & Slash0.99ContrabandVelvet RevolverMPEG audio fileRockSchneiderHannahJohnsonSteve1 (780) 836-9987steve@chinookcorp.com
96Dirty Little ThingDave Kushner, Duff, Keith Nelson, Matt Sorum, Scott Weiland & Slash0.99ContrabandVelvet RevolverMPEG audio fileRockKovácsLadislavPeacockJane+1 (403) 262-3443jane@chinookcorp.com
306Do It For The KidsDave Kushner, Duff, Matt Sorum, Scott Weiland & Slash0.99ContrabandVelvet RevolverMPEG audio fileRockWichterlováFrantišekParkMargaret+1 (403) 263-4423margaret@chinookcorp.com