Getting Error when setting order by for pods item list block

Hi @rico34

Please check the Pod access settings, it seems that you didn’t allow these manual SQL options for this post type.

Cheers, Jory

Hi Jory,

thanks a lot for your quick reponse! Very much appreciated.

I changed the setting under ‘Pods Admin’>’Settings’>’Allow SQL clauses to be used in Dynamic Features’ to ‘Restricted – Enable Simple SQL…’.

Now it works. But since I don’t want to give all content creators this SQL abilities, I will turn this off again. So to get my Pods template to show the content with an orderby sort I have to create and somehow use it with a custom php template I guess. Is my assumption correct?

Thank you,
rico

Yes a custom PHP template or a new shortcode using pods->find() and pods->template().

For example, for shortcode [ordered_template_of_things]:

<?php
/**
 * https://developer.www.ads-software.com/reference/functions/add_shortcode/
 * https://docs.pods.io/code/pods/find/
 * https://docs.pods.io/searching-filtering-sorting/sorting/sorting-date-fields-using-cast/
 * https://docs.pods.io/searching-filtering-sorting/complicated-where-sort-and-filters/using-date-based-searches/
 */
add_shortcode(
	'ordered_template_of_things',
	function( $atts = [], $content = '', $tagname ) {
		$maybe_output = pods(
			'post_or_page_or_cars_or_kittens',
			[
				'limit' => 20,
				'orderby' => 't.post_title ASC',
			]
		)->template( 'Name of the Template' );

		if ( ! empty( $maybe_output ) ) {
			return $maybe_output;
		}

		return sprintf(
			'<p>There are no cars or kittens. Today is %s.</p>'
			esc_html( date('l') )
		);
	}
);

Where the Pod name is post_or_page_or_cars_or_kittens, it is ordered by post_title, the template name is Name of the Template, and if no content is found, it will display There are no cars or kittens. Today is Tuesday.

The orderby query for post_date would be CAST( t.post_date AS DATETIME ) DESC

Reading the docs for add_shortcode will reveal that anything passed as an attribute="value" in the new shortcode will be available to the function as $atts[ 'attribute' ].