What attribute holds the RAW HTML of a Standard Page?

(Nic Hubbard) #1

Matrix Version:

I am needing to use the search_replace_attributes_content.php script to replace some HTML. We use a lot of standard pages on our site, so I am trying to figure out how to update the content of a Raw HTML Content Type Format.

Is there an attribute that is used that holds the HTML in that asset type?

(John gill) #2

Not familiar with that script, but all the Content Type assets have an attribute called html.

squiz_matrix55=# select name, type_code, type from sq_ast_attr where name = 'html' and owning_type_code = 'content_type';;
 name |         type_code         | type
 html | content_type              | text
 html | content_type_wysiwyg      | text
 html | content_type_markdown     | text
 html | content_type_nest_content | text
 html | content_type_snippet      | text
 html | content_type_raw_html     | text
(6 rows)

Different attributes, so different attribute IDs (not sure if that’s relevant for that script), but always called html.

(Nic Hubbard) #3

Thank you! It is an older script that was removed in 5.0 but is very helpful for my purposes. Modified a few things and it did the trick. If anyone needs to find and replace HTML, here is what I used: