List of Asset Fields

Squiz Matrix Support
1

Hi all.


I'm trying to create an unified asset "rename" function for our admin area. I want to use the JS API to set the name, short_name, title, and associated fields with minimal end-user stress.



I'm a little frustrated to find that different asset types have different fields for this task. SO I'm wondering if there's a definitive list of all the different fields one might come across in order to set the asset name? Or an easy way to find them?



Unfortunately querying the js_api only returns name and short_name for every asset type, so there doesn't appear to be an easy way of working this out without digging through code. Does anyone have any suggestions?



Cheers,

Ashley.

2

MySource Matrix stores all information about every attribute in the database.


You can find this quite easily by using the following query:


    SELECT DISTINCT name, owning_type_code FROM sq_ast_attr WHERE owning_type_code LIKE 'page%' ORDER BY owning_type_code;
3

Thanks. I'll use it to do up a spreadsheet or something for easy reference.