Search based on asset_thumbnail

Squiz Matrix Support
1

Hi,


I've got a number of pages in multiple locations of my site. I used asset thumbnails to differentiate their types/categories. I need to list all pages under each category (based on thumbnails). How can I do that using search Page? Any ideas…?

2

I don't believe you can achieve this with a search page. You could, however, configure a DB datasource to bring you back a list of assets by thumbnail. The following query would show you all assets with thumbnails (majorid = the page asset id, minorid = the thumbnail asset id):

    
    SELECT majorid, minorid FROM sq_ast_lnk WHERE value='thumbnail';


You could join other matrix tables to get more details like asset name etc.
3

Thanks Anthony. I'll give it a go.