Pods Embed Error: ORDER BY contains SQL that is not allowed.
-
We are creating a CPT called “meetup” that has a custom field called “fecha”. In the block editor, we have tried using the “Pods Item List” block, but it always orders the list by the post title.
We have made many attempts writing queries in the “ORDERBY” field, even with very simple queries, and we always get an SQL error: “Pods Embed Error: ORDER BY contains SQL that is not allowed.”
Here are some of the queries we have used for testing, even though it’s not what we want, we have simply tried to order them by the post creation date with different syntax tryouts:
t.post_date DESC
t.date DESC
wp_posts.post_date DESC
post_date DESC
t.fecha DESC
wp_posts.fecha DESC
fecha DESC ...We have even tried ordering simply by descending ID, but it also gives the same error:
t.ID DESC
ID DESC
id DESC
etc.We have also tried inserting a shortcode, but we get the same error:
[pods name="meetup" template="Listing grid meetup" limit="20" orderby="fecha DESC" pagination="true"]
[pods name="meetup" template="Listing grid meetup" limit="20" orderby="t.ID DESC" pagination="true"]
[pods name="meetup" template="Listing grid meetup" limit="20" orderby="t.post_date DESC" pagination="true"]Could you please give us a hint with the query? Thank you.
The page I need help with: [log in to see the link]
- You must be logged in to reply to this topic.