cashmusic/DIY — Issue #135: Metadata search
Author: jessevondoom
Created: 2011-11-05 17:52:30+00:00
State: open

Need to add a "searchMetadataVaues" method in CASHData. This would do a basic LIKE query of the metadata table returning a list of ids and their associated tables, limited in scope by table alias.

Footprint:
searchMetadataValues(string scope_table_alias, string search_term)

General query idea:
SELECT id from base_metadata WHERE 'scope_table_alias' = scope_table_alias AND search_term LIKE '%search_term%'

Touches:
CASHData (function)
CASHDBA (new custom query added)