Showing specific items

  • Resolved rwtclist

    (@rwtclist)


    3 years, 4 months ago

    Hi, i hope this isn’t a question that is already been answered. I was not able to find a topic that is related to my question. (or my searching skills are terrible)

    I’m trying to build a website with a lot of data for books. Al these books, have their own name. All these books are shown on a page called Books.

    Now they are shown in order of initial letter, so from a to z. I want to break this down. For example, I only want to show books, starting with the letter A. How can I do this? I think I should use the ‘order by’ and ‘where’ option in pods, so combining them, but I’m not getting to the correct info to do this.

    I don’t mind creating 26 Pods list item objects, if that is the way to simply show books in a ‘box’ that all start with the letter A, B, C and so on. I hope somebody can help me!

    Greetings from Roy

    • This topic was modified 3 years, 4 months ago by rwtclist.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter rwtclist

    (@rwtclist)

    3 years, 4 months ago

    Little update;

    If i use at Order by: “title ASC” and at Where: “t.post_title LIKE ‘%A%'” it shows everything in asc with the letter A in it, so i think i’m getting in the right direction.

    I tried to use $first_char ‘%A%’ in ‘Where’ but that doesn’t display something (i have also no idea if what i tried is possible, this is not my cup of tea)

    Plugin Author Jory Hogeveen

    (@keraweb)

    3 years, 4 months ago

    Hi @rwtclist

    You’re very close already! Please modify your like query to "A%" (only a percentage sign after the letter). This way it will not accept any characters before the A. Full example:

    Where: t.post_title LIKE 'A%'

    Cheers, Jory

    Thread Starter rwtclist

    (@rwtclist)

    3 years, 4 months ago

    Hi @keraweb sorry for my late, late, late reply. Your answer is the fix, thank you verry much!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Showing specific items’ is closed to new replies.