[wp-trac] [WordPress Trac] #57616: As a website editor I want to find out which media asset (image, video, etc) is used on which pages / posts

[WordPress Trac]

#57616: As a website editor I want to find out which media asset (image, video,
etc) is used on which pages / posts
-----------------------------+----------------------
 Reporter:  abitofmind       |       Owner:  (none)
     Type:  feature request  |      Status:  closed
 Priority:  normal           |   Milestone:
Component:  Media            |     Version:
 Severity:  normal           |  Resolution:  wontfix
 Keywords:                   |     Focuses:
-----------------------------+----------------------

Comment (by abitofmind):

 To me the closing feels premature:

 I attempted to get a feasibility estimation from you devs/experts whether
 sort-able columns like "Use count" or "Embedded in" are **technically
 feasible with the methods and hooks that core provides to plugins**. If
 so, then close the issue for good. But if something fundamentally for this
 is missing in Core, then there should be a discussion (with experts, not
 me) whether and how core could provide this. Hence I had asked:

 > If supposed to be efficient -- it must be updated in an event driven
 manner (when media objects are manipulated and when page markup with media
 object changes)

 > Because if doing indexing as a cronjob or oneshot then this info always
 only reflects the last manual indexing, rarely the current status.

 > Does core provide hooks to plugins for said event driven DB maintenance?

 What I observed from the plugins:

 - Media Library Assistant →  Uses normal sorting & likely reverse queries
 for the paginated results during runtime.
 - BEA Media Analysis → Mentions "indexing". This is the initial indexing.
 But how is the index updated in the future? Cronjob based? Or truly event
 driven? Could not observe the plugin further as the plugin dies fatally in
 WP 6.1.1. Could some DEV here look into its source code and tell whether
 it has any kind of event driven approach? To answer the question: Does
 Core provide enough for plugins, that sorting by the custom columns could
 work.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/57616#comment:8>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform