getResources: How to list resources based on publishing date

Hi,

I'm trying to use getResources to list only those resources which are updated (editedon) after specific date.

I figured that i can use &where property.

[[!getResources? &parents=`0` &limit=`all` &where=`{*}` &tpl=`myRowTpl`]]
*resource editedon after specific date

Can anyone help with this?

Thnx.

You need to construct the JSON string for it kinda like



Im not sure about the latter half and its format, so im not sure if it will take a straight up numeric entry like ive done above

also it would be &limit=`0` for all results.

Hope that helps

Refs:
http://rtfm.modx.com/extras/revo/getresources (Where statement)
http://rtfm.modx.com/xpdo/2.x/class-reference/xpdoquery/xpdoquery.where

The editedon field is a UNIX timestamp, so you would need to convert your control date to a timestamp. Where does it come from? If it's a TV or a placeholder, you could use the strtotime Output Modifier:

It's specific date, so i used it's timestamp as control date. Although i didn't get the "greater than" working

&where=`{"editedon:>":1384241634}` < This isn't working
&where=`{"editedon:!=":1384241634}` < This is working

I know this isn't very cultivated solution. Maybe i just don't "get" the timestamp?

What about &where=`{"editedon:>=":1384241634}`?

Did you get it working? What was the solution?

Well. Yes and no...I used SQL and changed all resources to same editedon date and then:

I don't know why '>=' isn't working??
Thnx for help everyone!

You may find the Extra below useful. Docs include code examples of how to use it with getResources to filter by date/timestamp.

getDate Extra: http://modx.com/extras/package/getdate

Docs & Usage Examples: http://rtfm.modx.com/extras/revo/getdate#getDate-getResourcesExamples

Thanks David. Have to check these out.

I'm trying to use GetResources to display a random selection of only two of the four most recent posts. So any two of the most recent four posts. Using &limit=`2` works well to display purely the two most recent posts. Introducing RAND is fine to display all post randomly. So wanting to limit the RAND to only the most recent 4 posts. Tried using &where but failed. Any help appreciated.