Display list of sql, xml, exe, bat files in Media Library to Users

Thanks for your question. MLA includes the [mla_gallery] shortcode, which can generate a gallery display of any Media Library items for any of the MIME Types allowed for Media Library items. The post_mime_type parameter specifies which MIME Types the gallery will contain; it defaults to “image” types.

It’s not clear from your post whether you want a display on the front end of your site or whether you are referring to an admin mode screen such as the Media/Assistant page. You wrote “with search and filters, where-used… You can construct front end pages with search and filter functions. MLA has some “where used” admin-mode functions that should work regardless of the item’s MIME Type.

Any additional details you can provide will help me give you more specific guidance. I will leave this topic unresolved until I hear back from you. Thanks for your interest in the plugin.

Thanks for the response, David. It’s the subscriber’s view that is foremost. I’m not sure that Mime Type is appropriate or sufficient. I’d like for them to be able to filter on the extension.

Thanks for the additional details.

The MIME Type and file extension are closely related, and WordPress stores the MIME Type in a database field. If you go to the WordPress Media/Library admin screen you can pull down the “All media items” control to filter the results by MIME Type. The WP_Query class also supports searching by MIME Type. WordPress has no built-in features for searching or filtering by file extension.

That said, you can use MLA to build out a solution based on the file extension. You can use a custom field mapping rule to create a custom field that contains the file extension using the “extension” field-level data source. Then you can create application pages with a search form to select a file type and an [mla_gallery] shortcode with a meta_query or simple custom field search parameters to display a filtered gallery.

Either approach can be made to work. Let me know if you need more specific guidance.

It has been over a month since my last post in this topic. I assume you have found a solution for your application.

I am marking this topic resolved, but please update it if you have any problems or further questions regarding my earlier suggestions. Thanks for your interest in the plugin.

Yes, thank you, David. Someone with more WP smarts than I has joined my site as co-Admin and wrote a plugin that queries the database and lists the hyperlinked sql files, links to the page or post to which each is attached along with the caption. I expect it could be readily modified to include the other file types.

Thanks for your update with the good news about the solution you found.

If you have any other problems or further questions regarding MLA, start a new topic and I will give you what help I can. Thanks again for your interest in the plugin.