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

where = empty field get a wrong result

    • 37909
    • 153 Posts
    neoziox Reply #1, 9 years, 8 months ago
    Hi!

    In my getPage call, I have:
    &where=`{"datestart:>=":"[[!today]]"},{"OR:dateend:>=":"[[!today]]"}`


    But, if `dateend`is empty, I have all results.

    Of course, this code work perfectly:
    &where=`{"datestart:>=":"[[!today]]"}`


    Help!
      • 48696
      • 41 Posts
      savalo Reply #2, 9 years, 8 months ago
      Sorry, but in https://docs.modx.com/extras/revo/getpage I didn't find some where property
        • 17301
        • 932 Posts
        LK Reply #3, 9 years, 8 months ago
        You set the element to getResources and you can use the where property with getPage that way.
          ■ email: [email protected] | ■ website: https://alienbuild.uk

          The greatest compliment you can give back to us, is to spend a few seconds leaving a rating at our trustpilot: https://uk.trustpilot.com/review/alienbuild.uk about the service we provided. We always drop mention of services offered by businesses we've worked with in the past to those of interest.
          • 17301
          • 932 Posts
          LK Reply #4, 9 years, 8 months ago
          I'm sure someone else can offer a better solution but can you set a default value on dateend to stop it displaying all results in the mean time?
            ■ email: [email protected] | ■ website: https://alienbuild.uk

            The greatest compliment you can give back to us, is to spend a few seconds leaving a rating at our trustpilot: https://uk.trustpilot.com/review/alienbuild.uk about the service we provided. We always drop mention of services offered by businesses we've worked with in the past to those of interest.
            • 37909
            • 153 Posts
            neoziox Reply #5, 9 years, 8 months ago
            I thought of setting a default value but I have not found how to do with MIGX :/
              • 30585
              • 833 Posts
              treigh Reply #6, 9 years, 8 months ago
              How do you set today's date? Can you show the code of the snippet?
                A MODx Fanatic
                • 37909
                • 153 Posts
                neoziox Reply #7, 9 years, 8 months ago
                Quote from: treigh at Feb 06, 2017, 11:35 AM
                How do you set today's date? Can you show the code of the snippet?
                Which snippet?
                  • 30585
                  • 833 Posts
                  treigh Reply #8, 9 years, 8 months ago
                  [[!today]]
                    A MODx Fanatic
                    • 37909
                    • 153 Posts
                    neoziox Reply #9, 9 years, 8 months ago
                    Simple
                    <?php
return date('Y-m-d H:i:s');
                      • 30585
                      • 833 Posts
                      treigh Reply #10, 9 years, 8 months ago
                      With the where clause, getResources queries modResource standard object fields. I suspect that your datestart and dateend are TVs, not resource fields. What you need is the tvFilters property or a more complex query using a custom snippet.

                      With &tvFilters you could do this (untested):
                      &tvFilters=`datestart>=[[!today]]%,dateend>=[[!today]]%`


                      Also, I'd advise converting your dates to unix timestamps when comparing against another date. That way you're dealing with numbers instead of strings.
                        A MODx Fanatic