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 The schema is shown further below.

Displaying 33-36 of 2240 results.
InvoiceTrack NameComposerUnit PriceAlbum TitleArtistMedia TypeGenreLast NameFirst NameSupport Last NameSupport First NameSupport PhoneSupport Email
298A Melhor FormaTitãs0.99AcústicoTitãsMPEG audio fileAlternative & PunkSmithJackJohnsonSteve1 (780)
264A Menina DançaCaetano Veloso e Gilberto Gil0.99Barulhinho BomMarisa MonteMPEG audio fileLatinRamosFernandaParkMargaret+1 (403)
213A Midsummer Night's Dream, Op.61 Incidental Music: No.7 Notturno 0.99Mendelssohn: A Midsummer Night's DreamPhilharmonia Orchestra & Sir Neville MarrinerProtected AAC audio fileClassicalGrayPatrickParkMargaret+1 (403)
376A Moça e a ChuvaMônica Marianno0.99Demorou...Mônica MariannoMPEG audio fileWorldSilkMarthaJohnsonSteve1 (780)