• Resolved wpusr007

    (@wpusr007)


    Hello,

    I am using Pods for a small collection manager website, and created two pods named “Books” and “MusicRecords”. Each have dozen of entries. I created two pages and added the “Pods Item List” block on these pages. The block is customized with the following CUSTOM template:

    <div>
        <a href="{@permalink}">
            <h1 style="font-size:25px;font-weight: bold">{@post_title}</h1>
        </a>
        <a href="{@permalink}">
            <p style="float: left;  border: 2px solid #555;"><img src="{@book_cover._src.medium}" height="200px"  border="1px"></p>
        </a>
        <table>
            <tr>
                <td width="130px"><strong>Publisher:</strong></td>
                <td width="250px">{@publisher}</td>
            </tr>
            <tr>
                <td width="130px"><strong>Book Author:</strong></td>
                <td width="250px">{@book_author}</td>
            </tr>
            <tr>
                <td width="130px"><strong>ISBN-13:</strong></td>
                <td width="250px">{@isbn}</td>
            </tr>
            <tr>
                <td width="130px"><strong>Publishing Date:</strong></td>
                <td width="250px">{@publishing_date}</td>
            </tr>
            <tr>
                <td width="130px"><strong>Purchase Year:</strong></td>
                <td width="250px">{@purchase_year}</td>
            </tr>
            <tr>
                <td width="130px"><strong>Genre(s):</strong></td>
                <td width="250px">{@genres}</td>
            </tr>
            <tr>
                <td width="130px"><strong>No. Pages:</strong></td>
                <td width="250px">{@no_pages}</td>
            </tr>
            <tr>
                <td width="130px"><strong>Article No.:</strong></td>
                <td width="250px"><strong>BKID-{@ID}</strong></td>
            </tr>
        </table>
        <hr style="height:2px;border-width:0;color:gray;background-color:gray">
    </div>

    I have also configured the Order by with “t.post_title ASC” and let the post number limit to 1000. I have ticked the “Enable pagination” and set it to “Before and after list”.

    Good, the page displays all items in the Pods in alphabetic ascending order. The buttons for page numbers also shows up at the bottom of the page but if I click on No. 2, I get an empty page. I believe its because I only have 17 entries so far in this Pod, and the block is set to display up to 1000 items. However, changing the value to 10 (so each page displays 10 items), only displays the first 10 items on the first page, and the second page is still empty.

    Pagination question:
    How can I make it display a pre-defined number of entries per page? Lets say 10 per page until the end of the list (for example with 36 entries, page1=10, page2=10, page3=10, page4=6) ??

    Question regarding filtering
    Eventually, I will end up with hundreds of entries in each Pod. Music records will probably have 1000+ entries… Needless to say, I need a way to search and filter. At the top of the pages, I would like to have a set of dropdown filters for some of the relationship fields. For example selecting “Psychology” in the Filter “Genre” would display psychology books (I am using relationship fields for the genre because I wanted to provide the users with a pre-defined list of genres to avoid cataloguing problems.).

    Question regarding searching
    For searching, I’d like to have a search box at the top of the page to be able to select a search field (from the “plain text” fields), then enter a search criterion.

    Are these things possible? I experimented with the plugin Search & Filter based on Jim True’s recommendation on another forum post, but I could not really do anything useful with it. The best I could achieve for the search function is activate search “at large” which is too broad to be useful…

    Sorry for the post length, and if some of you have an idea how to achieve these things I’m very curious to see how!

    Thanks!

    • This topic was modified 2 years, 11 months ago by wpusr007.
    • This topic was modified 2 years, 11 months ago by wpusr007.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Paul Clark

    (@pdclark)

    Pagination is possible in PHP, but not with magic tags as far as I know.

    For advanced filtering and pagination of this nature, see https://facetwp.com

    Thread Starter wpusr007

    (@wpusr007)

    @pdclark : Then I must not be understanding how the Pods Item-list block works. What is Pagination if its not what I’m trying to do?

    FacetWP is only paying AFAIK and IMO very expensive for a simple website only on LAN (not on the internet per-se).

    I thought about creating separate pages for each author, etc to re-create the filters I want to implement, but its gonna get real messy and become cumbersome quick… Any other idea from the experienced users?

    I’m surprised what I want to do is not feasible out of the box with Pods as if I understand well, Pods was created to provide a taxonomy system for WP posts.. I may be wrong, my mileage is very limited with WP! ??

    • This reply was modified 2 years, 11 months ago by wpusr007.
    Plugin Author Jory Hogeveen

    (@keraweb)

    Hi @wpusr007

    Please see the shortcode documentation for Pods params:
    https://docs.pods.io/displaying-pods/pods-shortcode/

    What you want is supported to some extend, you’ll have to see whether it will suit your needs.

    IMO, hardly any plugin is actually overpriced if you take into account how much work is spend for such features and compatibility.
    You mention your mileage with WP is very limited so a developer will cost you a lot more ??

    Free plugins like Pods do their best to create as much functionality as we can but some things are more suited for the premium realm because it’s is simply too much work in development and maintenance.

    Cheers, Jory

    Thread Starter wpusr007

    (@wpusr007)

    Hello Jory,

    Do you know a simple shortcode or other method to simply retrieve the number of posts in a specific Pod?

    I have created a table using tablepress and the plugin Pods Tables which grabs the pod entries in a specific pods and populate a tablepress table. Quite fantastic IMO.

    I am trying to simply do a SUM on a column of that table, but because the number of rows of that table changes depending on the post count in Pods, tablepress and the Pods Tables plugins cannot handle “dynamic” data so what I want to do is currently “impossible”…

    If I could simply have a shortcode that would output the number of posts in the pod, I could use something like:

    =SUM(F1:F([pods-data pods="book" post_count]))

    which would give

    =SUM(F1:F84)

    if there are 84 posts in the pods “book”…

    Is this possible?

    Plugin Support Paul Clark

    (@pdclark)

    @wpusr007 see wp_count_posts(): https://developer.www.ads-software.com/reference/functions/wp_count_posts/

    e.g., <?php wp_count_posts( 'book' );

    Or, as a shortcode [book-count]:

    
    <?php
    add_shortcode(
    	'book-count',
    	function(){
    		return wp_count_posts( 'book' );
    	}
    );
    Thread Starter wpusr007

    (@wpusr007)

    @pdclark : Very nice! The php code and the function “wp_count_posts” indeed works well in a shortcode.

    This shortcode allowed to retrieve the number of posts in the Pods and perform the “dynamic” sum in the tablepress table!

    Thanks!!!!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Customizing pages with Pods Item list’ is closed to new replies.