getResources - Filter by date | MODX Community Forums

238 Posts

Hello, How can I get getResources to show (filter) dates for the next 7 days, including current date? [ed. note: Vitalized last edited this post 14 years, 10 months ago.]

Web Development, Web Hosting & Search Engine Marketing by:

Vitalized | UK
w. www.vitalized.co.uk

Website Design | Search Engine Marketing (SEM) | UK MODx web hosting, secure, fast & 100% MODx compatible

Vitalized | Australia
w. www.vitalized-australia.com.au

Website Design | Search Engine Marketing (SEM) | Australian MODx web hosting, secure, fast & 100% MODx compatible

☆ A M B ☆
279 Posts

bertoost Reply #2, 14 years, 10 months ago

You would show only resources which are created/published or updated within 7 days ago?

MODX Ambassador (NL) & Professional MODX developer
Follow me on Twitter | Visit my page on Facebook | View my code on Github | View my script posts
MODX e-commerce solution SimpleCart

☆ A M B ☆
279 Posts

bertoost Reply #3, 14 years, 10 months ago

[[getResources? &where=`{"publishedon:<=":"[[!getTime? &from=`-7 days`]]"}`]]

and the snippet getTime will be something like this;

return strtotime($scriptProperties['from'], strtotime(date('Y-m-d'));

MODX Ambassador (NL) & Professional MODX developer
Follow me on Twitter | Visit my page on Facebook | View my code on Github | View my script posts
MODX e-commerce solution SimpleCart

238 Posts

Si Reply #4, 14 years, 10 months ago

Many thanks for your reply!... Unfortunately I can't get it to work.

I've clear the cache, checked the log file which had this in it:

[2011-12-02 14:00:22] (ERROR @ /index.php) SELECT `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override` FROM `cms_site_content` AS `modResource` WHERE ( ( modResource.parent IN (14,638,1649) AND `modResource`.`deleted` = 0 AND `modResource`.`published` = 1 AND `modResource`.`hidemenu` = 0 ) AND `modResource`.`publishedon` <= '[[!getTime? &from=`-7 days`]]' ) ORDER BY publishedon DESC LIMIT 5

This is the Snippet call I'm using... I know I don't need all the options, I was just trying to get it to work:

[[getResources? &parents=`14` &includeContent=`1` &includeTVs=`1` &processTVs=`1` &tpl=`FeaturedHpSmallBCTpl` &limit=`5` &where=`{"publishedon:<=":"[[!getTime? &from=`-7 days`]]"}` &debug=`true`]]

The actual date TV will be a custom TV I've setup (set to 'date' of course). I assume that if I can get it to work on the 'publishedon' field it will also work on a custom date TV. The snippet call will be used as a 'What's on this Week' widget so can I change the: `-7 days`]] to `+7 days`]] ?

I've also made sure there are resources in the &parents folder that are within the last 7 days.

Web Development, Web Hosting & Search Engine Marketing by:

Vitalized | UK
w. www.vitalized.co.uk

Website Design | Search Engine Marketing (SEM) | UK MODx web hosting, secure, fast & 100% MODx compatible

Vitalized | Australia
w. www.vitalized-australia.com.au

Website Design | Search Engine Marketing (SEM) | Australian MODx web hosting, secure, fast & 100% MODx compatible

☆ A M B ☆
279 Posts

bertoost Reply #5, 14 years, 10 months ago

I see the value of the getTime snippet isn't set in the query. What is the return value returned when putting the getTime call outside the getResources tag?

MODX Ambassador (NL) & Professional MODX developer
Follow me on Twitter | Visit my page on Facebook | View my code on Github | View my script posts
MODX e-commerce solution SimpleCart

238 Posts

Si Reply #6, 14 years, 10 months ago

I tried the snippet on it's own cached & uncached and there is no output.

Web Development, Web Hosting & Search Engine Marketing by:

Vitalized | UK
w. www.vitalized.co.uk

Website Design | Search Engine Marketing (SEM) | UK MODx web hosting, secure, fast & 100% MODx compatible

Vitalized | Australia
w. www.vitalized-australia.com.au

Website Design | Search Engine Marketing (SEM) | Australian MODx web hosting, secure, fast & 100% MODx compatible

238 Posts

Si Reply #7, 14 years, 10 months ago

To be clear: The page doesn't load with a cached or uncache

[[getTime]] or [[!getTime]]

Web Development, Web Hosting & Search Engine Marketing by:

Vitalized | UK
w. www.vitalized.co.uk

Website Design | Search Engine Marketing (SEM) | UK MODx web hosting, secure, fast & 100% MODx compatible

Vitalized | Australia
w. www.vitalized-australia.com.au

Website Design | Search Engine Marketing (SEM) | Australian MODx web hosting, secure, fast & 100% MODx compatible

☆ A M B ☆
279 Posts

bertoost Reply #8, 14 years, 10 months ago

the &from=`-7 days` is missing.. that one is required because strtotime() needs it

MODX Ambassador (NL) & Professional MODX developer
Follow me on Twitter | Visit my page on Facebook | View my code on Github | View my script posts
MODX e-commerce solution SimpleCart

238 Posts

Si Reply #9, 14 years, 10 months ago

I tried:

[[!getTime &from=`-7 days`]]
[[getTime &from=`-7 days`]]
[[!getTime &from=`+7 days`]]
[[getTime &from=`+7 days`]]

The page loads but there is no output. I checked the error log but there was no info.

If I use a ? the page doesn't load

[[getTime? &from=`-7 days`]]

This is the snippet:

<?php
return strtotime($scriptProperties['from'], strtotime(date('Y-m-d'));

Many thanks for your help so far...

Web Development, Web Hosting & Search Engine Marketing by:

Vitalized | UK
w. www.vitalized.co.uk

Website Design | Search Engine Marketing (SEM) | UK MODx web hosting, secure, fast & 100% MODx compatible

Vitalized | Australia
w. www.vitalized-australia.com.au

Website Design | Search Engine Marketing (SEM) | Australian MODx web hosting, secure, fast & 100% MODx compatible

☆ A M B ☆
279 Posts

bertoost Reply #10, 14 years, 10 months ago

I'm now in the possibility to test it out for you.. there was missing an ) at the end

return strtotime($scriptProperties['from'], strtotime(date('Y-m-d')));

MODX Ambassador (NL) & Professional MODX developer
Follow me on Twitter | Visit my page on Facebook | View my code on Github | View my script posts
MODX e-commerce solution SimpleCart