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
34Right Next Door to Hell 0.99Use Your Illusion IGuns N' RosesProtected AAC audio fileRockAlmeidaRobertoPeacockJane+1 (403) 262-3443jane@chinookcorp.com
155In The EveningJimmy Page, Robert Plant & John Paul Jones0.99In Through The Out DoorLed ZeppelinMPEG audio fileRockAlmeidaRobertoPeacockJane+1 (403) 262-3443jane@chinookcorp.com
155Fool In The RainJimmy Page, Robert Plant & John Paul Jones0.99In Through The Out DoorLed ZeppelinMPEG audio fileRockAlmeidaRobertoPeacockJane+1 (403) 262-3443jane@chinookcorp.com
166Saudade Dos AviƵes Da Panair (Conversando No Bar)Milton Nascimento, Fernando Brant0.99MinasMilton NascimentoMPEG audio fileLatinAlmeidaRobertoPeacockJane+1 (403) 262-3443jane@chinookcorp.com