We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

getResources - How to display all pages starting with a certain letter?

    • 30025
    • 32 Posts
    timharris777 Reply #1, 16 years, 1 month ago
    Is it possible to display only resources that start with a certain letter with getResources? If not, is there another way to do this?
      • 4172
      • 5,888 Posts
      Bruno17 Reply #2, 16 years, 1 month ago
      try
      &where=`{{"pagetitle:LIKE":"a%"}}`
        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!
        • 30025
        • 32 Posts
        timharris777 Reply #3, 16 years, 1 month ago
        Quote from: Bruno17 at Sep 11, 2010, 02:32 AM

        try
        &where=`{{"pagetitle:LIKE":"a%"}}`


        Great!!! That worked!!

        Another question: How would I use a TV in place of pagetitle? I tried to sort by TV with:

        &where=`{{"artistName:=":"Travis"}}`


        But I get the following error:

        [2010-09-14 23:53:18] (ERROR @ /index.php) Error 42S22 executing statement: Array ( [0] => 42S22 [1] => 1054 [2] => Unknown column 'modResource.artistName' in 'where clause' )