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 1-4 of 2240 results.
InvoiceTrack NameComposerUnit PriceAlbum TitleArtistMedia TypeGenreLast NameFirst NameSupport Last NameSupport First NameSupport PhoneSupport Email
306Camarão que Dorme e Onda LevaAcyi Marques/Arlindo Bruz/Braço, Beto Sem/Zeca Pagodinho0.99Ao Vivo [IMPORT]Zeca PagodinhoMPEG audio fileLatinWichterlováFrantišekParkMargaret+1 (403)
306Coração Em DesalinhoMauro Diniz/Ratino Sigem0.99Ao Vivo [IMPORT]Zeca PagodinhoMPEG audio fileLatinWichterlováFrantišekParkMargaret+1 (403)
201Faixa AmarelaBeto Gogo/Jessé Pai/Luiz Carlos/Zeca Pagodinho0.99Ao Vivo [IMPORT]Zeca PagodinhoMPEG audio fileLatinStevensVictorJohnsonSteve1 (780)
411Feirinha da Pavuna/Luz do Repente/Bagaço da LaranjaArlindo Cruz/Franco/Marquinhos PQD/Negro, Jovelina Pérolo/Zeca Pagodinho0.99Ao Vivo [IMPORT]Zeca PagodinhoMPEG audio fileLatinHämäläinenTerhiPeacockJane+1 (403)