• Resolved rafamerida

    (@rafamerida)


    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]

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.