Filtering results in Revolution

141 Posts

antsplace Reply #11, 14 years, 9 months ago

The Archive style I am trying to use is giving an actual date, like "January 2010" for example, but whenever I try this it doesn't work, simply showing every page published.

My Websites: http://antsplace.co.uk | http://sfbook.com

141 Posts

antsplace Reply #12, 14 years, 9 months ago

This is the code I am using after creating the suggested "time" snippet:

[[!getResources?parents=`3` &depth=`3` &hideContainers=`1` &limit=`all` &tpl=`free` &showHidden=`1` &processTVs=`1` &includeTVs=`1` &includeContent=`1` &sortBy=`pagetitle` &sortdir=`ASC` &where=`{ "publishedon:>" : [[!time? &input=`January 2010`]] } ]]

No Matter what I change it just outputs all resources and seems to completely ignore the "&where" statement.

I am running Modx 2.2.0-pl2 and the latest getResources version (1.42). This is running on a Linux server with PHP 5.3.8 and MySql 5.08.

Any help would be really appreciated, it's really doing my head in!

My Websites: http://antsplace.co.uk | http://sfbook.com

MODX Staff
10,725 Posts

opengeek Reply #13, 14 years, 9 months ago

What does just

[[!time? &input=`January 2010`]]

output on your page?

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

141 Posts

antsplace Reply #14, 14 years, 9 months ago

It seems to completely ignore it and just outputs everything, regardless of what date I use.

My Websites: http://antsplace.co.uk | http://sfbook.com

64 Posts

culd | steffan Reply #15, 14 years, 9 months ago

Opengeek means the output of the snippet without the getResources to see what time it returns.

If you want to show only the items from January 2010 you need to change your where statement to something like:

 &where=`{ "publishedon:>=" : [[time? &input=`1 January 2010`]],"AND:publishedon:<=" : [[time? &input=`31 January 2010`]]  }`

141 Posts

antsplace Reply #16, 14 years, 9 months ago

Sorry for the confusion OpenGeek and thank you very much Culd, that works perfectly now.

Again thank you very much!

My Websites: http://antsplace.co.uk | http://sfbook.com

☆ A M B ☆
350 Posts

boomerang Reply #17, 14 years, 7 months ago

This seems promising - what if you want to use &input= todays date? I want to ensure that resources that are being sorted by an unpublish date and subsequently being called by &showUnpublished property are not called because they are past todays date.

The &where property seems to be the answer but I can't seem to get todays date to call.

I have this snippet being used as part of MIGX in a getImageList call:

&where={"date:>" : "[[!strftime? &format=`%d-%m-%Y`]]"}

Snippet code:

<?php
return strftime($format);

I tried to use this snippet like this:

 [[getResources? &tpl=`monthlyCalendar` &sortby=`unpub_date`  &where=`{"unpub_date": "[[!strftime? &format=`%d-%m-%Y`]]"}` &showUnpublished=`1`  &sortdir=`asc` &includeContent=`1` &includeTVs=`1` &processTVs=`1` &showHidden=`1` &limit=`12` ]]

but no joy - any other suggests?

Helen Warner
Number one pixel!
Proud to be linked with MODX at Crimson Pixel

64 Posts

culd | steffan Reply #18, 14 years, 7 months ago

If you add

&debug=`1`

to your snippet call and check your error log what it says.

You also need to add

:>=

or := to your where statement

And finally, I think you're using the wrong format, you shoud change your strftime snippet to :

strtotime($input)

and use it like this:

 [[!time? &input=`now`]]