{"id":40968,"date":"2023-07-14T08:20:44","date_gmt":"2023-07-14T08:20:44","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=40968"},"modified":"2024-08-28T07:45:24","modified_gmt":"2024-08-28T07:45:24","slug":"how-to-create-listing-for-wordpress-media-library","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/","title":{"rendered":"How to Create a Listing for WordPress Media Library"},"content":{"rendered":"\n

Create Custom SQL Query<\/strong><\/h2>\n\n\n\n
\n

Let us start with creating a custom query by following WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong>.<\/p>\n\n\n\n

Add a new query by pressing the similarly named button.<\/p>\n\n\n\n

Give a Name <\/strong>to the query and select \u201cSQL\/AI Query\u201d Query Type<\/strong>.<\/p>\n\n\n\n

\"sql<\/a><\/div>\n\n\n\n

In the Custom SQL Query <\/strong>section, select the \u201cpostmeta\u201d option in the From table <\/strong>drop-down and enable the Use Join <\/strong>feature.<\/p>\n\n\n\n

Press the \u201cAdd new<\/strong>\u201d button in the Join Tables <\/strong>section.<\/p>\n\n\n\n

\"postmeta<\/a><\/div>\n\n\n\n

The Join Type<\/strong> should be set to \u201cInner Join\u201d with the Join Table<\/strong> \u201cposts.\u201d\u00a0<\/p>\n\n\n\n

The table columns \u201cID\u201d and \u201cpost_id\u201d are to be selected, respectively, in the following When current table column <\/strong>and Is equal to other table column<\/strong> fields.<\/p>\n\n\n\n

\"posts<\/a><\/div>\n\n\n\n

After that, you should add two query clauses by pressing the \u201cAdd new<\/strong>\u201d button in the Where (query clauses) <\/strong>section.<\/p>\n\n\n\n

In the first clause, you should select the \u201cpostmeta.meta_key\u201d Column <\/strong>to be \u201cEqual\u201d (Compare <\/strong>field) to the \u201c_wp_attached_file\u201d Value<\/strong>.<\/p>\n\n\n\n

Also, mind selecting \u201cChar\u201d as the Type<\/strong>.<\/p>\n\n\n\n

\"first<\/a><\/div>\n\n\n\n

In the second meta clause, you should add the \u201cattachment\u201d Value<\/strong> as a post type from which to get the posts, which are the images in our case.<\/p>\n\n\n\n

So, the Column <\/strong>should be set to \u201cposts.post_type,\u201d the Compare<\/strong> operator to \u201cEqual,\u201d and the Type <\/strong>to \u201cChar.\u201d<\/p>\n\n\n\n

\"second<\/a><\/div>\n\n\n\n

Also, mind picking the \u201cAnd\u201d option in the Where Relation <\/strong>field. Then, activate the Group Results <\/strong>toggle and set the \u201cposts.ID\u201d Group By <\/strong>option.<\/p>\n\n\n\n

This way, the media files will not be doubled if one media file is attached to several posts.<\/p>\n\n\n\n

\"where<\/a><\/div>\n\n\n\n

Once the custom query is completed, press the \u201cAdd Query<\/strong>\u201d button.\u00a0<\/p>\n\n\n\n

We will now create a Listing Template<\/strong><\/a> for this SQL query.<\/p>\n<\/div><\/div>\n\n\n\n

Build Listing Template for Custom Query<\/strong><\/h2>\n\n\n\n
\n

Head to WordPress Dashboard > JetEngine > Listings\/Components<\/em><\/strong>.<\/p>\n\n\n\n

Click the \u201cAdd New Listing Item<\/strong>\u201d button, and select \u201cQuery Builder\u201d as a Listing source<\/strong>. Then, select the custom Query <\/strong>that has just been created.<\/p>\n\n\n\n

Complete the Listing item name <\/strong>field and choose the desired Listing view<\/strong>.<\/p>\n\n\n\n

Push \u201cCreate Listing Item<\/strong>.\u201d<\/p>\n\n\n\n

\"setup<\/a><\/div>\n\n\n\n

In the editor, add a Dynamic Field<\/strong><\/a> widget to the page.<\/p>\n\n\n\n

Firstly, output the image from the Media Library itself. To do so, select \u201cPost\/Term\/User\/Object Data\u201d as the Source<\/strong> and \u201cmeta_value\u201d as the Object Field<\/strong>.<\/p>\n\n\n\n

\"dynamic<\/a><\/div>\n\n\n\n

The \u201cmeta_value\u201d column stores the media file URL as a value. So, we need to activate the Customize the field output<\/strong> toggle to transform the image\u2019s URL into the image itself. HTML tag <img> can help with this.\u00a0<\/p>\n\n\n\n

Check a recommended Field Format<\/strong>:<\/p>\n\n\n\n

<img src=\"https:\/\/your-domain.com\/wp-content\/uploads\/%s\"><\/code><\/pre>\n\n\n\n
As you can observe, the image is already displayed in the editor.<\/p>\n\n\n\n
\"image<\/a><\/div>\n\n\n\n
Let\u2019s create a button that can download the image by clicking on the button. <\/p>\n\n\n\n
Add another Dynamic Field <\/strong>widget, and select \u201cPost\/Term\/User\/Object Data\u201d as a Source<\/strong> and \u201cmeta_value\u201d as an Object Field<\/strong>.<\/p>\n\n\n\n
Then, activate the Customize field output<\/strong> toggle and add the following Field Format <\/strong>to make the image downloaded on your device:<\/p>\n\n\n\n
 <a href=\"https:\/\/your-domain.com\/wp-content\/uploads\/%s\" download>Download<\/a><\/code><\/pre>\n\n\n\n
\"button<\/a><\/div>\n\n\n\n
Make image downloadable<\/strong><\/h3>\n\n\n\n
Let\u2019s also add another option for displaying and downloading the image using just the Dynamic Field <\/strong>widget.<\/p>\n\n\n\n
Activate the Customize field output <\/strong>toggle and add the following Field format<\/strong>:<\/p>\n\n\n\n
<a href=\"https:\/\/your-domain.com\/wp-content\/uploads\/%1$s\" download><img src=\"https:\/\/your-domain.com\/wp-content\/uploads\/%s\"><\/a><\/code><\/pre>\n\n\n\n
This way, an image can be downloaded by clicking on it.<\/p>\n\n\n\n
\"downloadable<\/a><\/div>\n\n\n\n
Customize the listing and press the \u201cUpdate<\/strong>\u201d button to save the changes.<\/p>\n\n\n\n
Check the result by outputting the listing for Media Library with the Listing Grid<\/strong><\/a> widget on the needed page.\u00a0<\/p>\n\n\n\n
You should only add the Listing Template<\/strong> to the Listing Grid<\/strong> without applying the custom query since it is already based on the custom query.<\/p>\n\n\n\n
\"listing<\/a><\/div>\n\n\n\n
Check the Listing Grid<\/strong> with the images from the WordPress Media Library on the front end. <\/p>\n\n\n\n
Not only is the image displayed, but it can also be downloaded by clicking on the button or on the image itself.<\/p>\n\n\n\n
\"listing<\/a><\/div>\n<\/div><\/div>\n\n\n\n
That\u2019s it; now you know how to create a JetEngine<\/em> Listing Template <\/strong>that will display the WordPress Media Library items on the front end and make it downloadable.<\/p>\n","protected":false},"excerpt":{"rendered":"
This tutorial explains how to create a Listing template using the JetEngine plugin to show a list of WordPress Media library images that can be displayed and downloaded.<\/p>\n","protected":false},"author":9,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[388],"yoast_head":"\nHow to Create Listing for WordPress Media Library \u2014 JetEngine | Crocoblock<\/title>\n<meta name=\"description\" content=\"From this guide, find out how to build a JetEngine listing with WordPress Media Library images as a source that can be displayed and downloaded.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Create Listing for WordPress Media Library \u2014 JetEngine | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"From this guide, find out how to build a JetEngine listing with WordPress Media Library images as a source that can be displayed and downloaded.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2024-08-28T07:45:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2024\/08\/sql-ai-query-1024x640.webp\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/\",\"name\":\"How to Create Listing for WordPress Media Library \u2014 JetEngine | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2023-07-14T08:20:44+00:00\",\"dateModified\":\"2024-08-28T07:45:24+00:00\",\"description\":\"From this guide, find out how to build a JetEngine listing with WordPress Media Library images as a source that can be displayed and downloaded.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/articles\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Create a Listing for WordPress Media Library\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"name\":\"Help Center\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\",\"name\":\"Help Center\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"contentUrl\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"caption\":\"Help Center\"},\"image\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Create Listing for WordPress Media Library \u2014 JetEngine | Crocoblock","description":"From this guide, find out how to build a JetEngine listing with WordPress Media Library images as a source that can be displayed and downloaded.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/","og_locale":"en_US","og_type":"article","og_title":"How to Create Listing for WordPress Media Library \u2014 JetEngine | Crocoblock","og_description":"From this guide, find out how to build a JetEngine listing with WordPress Media Library images as a source that can be displayed and downloaded.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/","og_site_name":"Help Center","article_modified_time":"2024-08-28T07:45:24+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2024\/08\/sql-ai-query-1024x640.webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/","name":"How to Create Listing for WordPress Media Library \u2014 JetEngine | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2023-07-14T08:20:44+00:00","dateModified":"2024-08-28T07:45:24+00:00","description":"From this guide, find out how to build a JetEngine listing with WordPress Media Library images as a source that can be displayed and downloaded.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-create-listing-for-wordpress-media-library\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crocoblock.com\/knowledge-base\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/crocoblock.com\/knowledge-base\/articles\/"},{"@type":"ListItem","position":3,"name":"How to Create a Listing for WordPress Media Library"}]},{"@type":"WebSite","@id":"https:\/\/crocoblock.com\/knowledge-base\/#website","url":"https:\/\/crocoblock.com\/knowledge-base\/","name":"Help Center","description":"","publisher":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization","name":"Help Center","url":"https:\/\/crocoblock.com\/knowledge-base\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/","url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","contentUrl":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","caption":"Help Center"},"image":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article\/40968"}],"collection":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/users\/9"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=40968"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=40968"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=40968"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}