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 37-40 of 2240 results.
InvoiceTrack NameComposerUnit PriceAlbum TitleArtistMedia TypeGenreLast NameFirst NameSupport Last NameSupport First NameSupport PhoneSupport Email
222Levada do Amor (Ailoviu)Luiz Wanderley/Paulo Levi0.99Axé Bahia 2001Various ArtistsMPEG audio filePopChaseKathyJohnsonSteve1 (780)
229MangueiraBizuca/Clóvis Pê/Gilson Bernini/Marelo D'Aguia0.99Sambas De Enredo 2001Various ArtistsMPEG audio fileLatinSrivastavaPujaPeacockJane+1 (403)
117Morro Da Casa Verde 2001 0.99Carnaval 2001Various ArtistsMPEG audio fileSoundtrackDuboisMarcJohnsonSteve1 (780)
117My LoveJauperi/Zeu Góes0.99Axé Bahia 2001Various ArtistsMPEG audio filePopDuboisMarcJohnsonSteve1 (780)