Support » Plugin: Pods - Custom Content Types and Fields » How to order custom taxonomy items by their count in widget?

  • Resolved pupinho

    (@pupinho)


    Trying to order custom taxonomy items in “List Item Widget” by their count. What should I put in “Order by” field?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Author Jory Hogeveen

    (@keraweb)

    Hello @pupinho

    Could you elaborate on what kind of widget you are using etc.?
    I’d need more information to understand what you are trying to do exactly.

    Regards, Jory

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    It looks like you’re using the “Pods – List Items” widget, correct? If so, the fields for the widget mirror our options for the Shortcode and specifically the find() functionality that powers it.

    For reference, there’s a chart below on the find() doc page which lists how to target various fields / meta fields with our simple syntax (which mirrors MySQL because it’s powered by MySQL).

    To target the specific field you’re after (the built-in Taxonomy count value), you can use tt.count (the tt part references the wp_term_taxonomy table in the WordPress database, and the count is the column in that table which stores the cached last calculated count of posts associated to that term). To order it descending, you can use tt.count DESC and that will take care of that. Comma-separate multiple fields if you want to order by more.

    Plugin Author Jim True

    (@jimtrue)

    The count of posts by terms in a custom taxonomy is a WP dynamic function; I don’t believe it’s written to that particular table.

    If you’re Looking for the categories archive style widget, the easiest way to get those results is to use Custom Post Type Widgets, https://wordpress.org/plugins/custom-post-type-widgets/, which is designed to create Widgets for default posts, categories and tags, but for custom post types and taxonomies.

    You should be able to get the result you intend from that, unless I’ve misinterpreted what you’re looking for.

    Plugin Author Jim True

    (@jimtrue)

    Or Scott’s method 😉

    Thanks all of you!
    tt.count is the very thing.
    I’ve tried t.count, {@count} and many other combinations without success.
    It will be great if you put in find() description that tt. is connected with taxonomy.

    Plugin Author Scott Kingsley Clark

    (@sc0ttkclark)

    The bottom chart has a complete breakdown of how to target any field in the database depending on the content type you’re dealing with. It’s pretty comprehensive, but because Pods covers so many content types it can be tricky to make easily understood. Thanks for hanging in there 🙂

    Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @pupinho
    Glad that Scott could help you!
    Please consider updating your review, a single star feels unfair (even though I understand that you had trouble going through our documentation, it’s very extensive and we are busy improving it).
    Free plugins like this one rely on it’s community and with that said also it’s reviews to expand it’s community.
    Thanks in advance!
    Jory

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