Hi all,
Anyone know what database table holds the paint layout info for an asset? Thanks.
Paint Layout Database Table
Sean_O_39_hAodha
(Sean O'hAodha)
#2
Got it!
In case anyone is wondering...you can see what assets have what paint layout from the sq_ast_lookup_value table.
Something like SELECT * FROM sq_ast_lookup_value WHERE name LIKE 'paint_layout%' AND value = '87677';
To get ALL assets that use a paint layout I took a peek at what Squiz use below.
SELECT DISTINCT l.assetid
FROM sq_ast_lookup l
JOIN sq_ast_lookup_value lv ON (lv.url = l.url OR (lv.url = l.url || '/'))
JOIN sq_ast_lnk al ON l.assetid = al.minorid
JOIN sq_ast_lnk_tree lt ON lt.linkid = al.linkid
WHERE lv.name LIKE 'paint_layout::%'
AND lv.value = '87677'
UNION ALL SELECT DISTINCT l.assetid
FROM sq_ast_lookup l
JOIN sq_ast_lookup_value lv ON (l.url LIKE lv.url || '/%')
JOIN sq_ast_lnk al ON l.assetid = al.minorid
JOIN sq_ast_lnk_tree lt ON lt.linkid = al.linkid
WHERE lv.name LIKE 'paint_layout::%'
AND lv.value = '87677';