getResources: Use tvFilters with dates

2 Posts

veuerfogel Reply #1, 9 years, 11 months ago

Hi @all =)
I would like to filter some content I get with getResource.
In the used Template is a template variable that contains a time, called "fixedtime".
Now, I like to show only the content, that has its "fixedtime" in the future. You see my trial below.

I WOul be really thankful for some help!
Sorry for my bad english.

Philipp

$page = $modx->runSnippet('getResources', array(
        'parents'        => $parent,
        'limit'          => $limit,
        'offset'         => $offset,
        'includeTVs'     => '1',
        'tvPrefix'       => '',
        'includeContent' => '1',
        'tpl'            => $tpl,
        'sortbyTV'        => 'fixedtime',
        'sortdirTV'        => 'ASC',
        'tvFilters'     => 'fixedtime <=date();'
    ));

- 119 Posts
achterbahn Reply #2, 9 years, 10 months ago
Hi veuerfogel,

probabely you have first to convert the two dates in the same format.
1. what format does
```
fixedtime
```
have? (e.g. "Y-m-d HH:MM")
2.
```
date()
```
should in the same format (e.g.
```
date('Y-m-d')
```
so:
```
$date = date('Y-m-d');
...
'tvFilters'     => 'fixedtime<=$date'
```