Showing related assets referred to within Redactor (rich text) fields

Question

When an entry includes a reference to an asset, like an image, that information is tracked and displayed. (The included screenshot shows where that reference would be, although this particular entry does not have any related content.)

What I'm wondering is, is there a way to track asset references that occur within a Redactor field? Ideally, I could output this in the asset list view. Purpose: to clean up our asset library. We have tons of duplicates, but right now, there is no way to know if a given asset is referred to in a Redactor field.

Note: I use the Preparse plugin a lot, maybe there's a way to do something like:

{% if element.myField contains '#asset' %}...{% endif %}

and have a column that indicates if there exist one or more asset references?

Answer 1

Since you only have raw HTML in the redactor field and there is no real relationship between the asset in the craft and the img url, the only way to do this is to parse your readctor field (or maybe even this?), check the img tags, take the "src" part and check in the assets table (the last part of the path in the src).

...<img src="http://mysite.com/assetFolder/subfolder/**file_name.jpg**">

And then find it like this:

\craft\elements\Asset::find()->filename($parsedImgSrcValue);

Answer 2

If your end goal is simply to have a dynamic index/list of all entries where that field contains that string, you can use the new filtering options in the entries index list here: