Ditto Filter Question

[Guest]

Welcome, Guest. Please login or register.
Did you miss your activation email?

1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[bmcneill]

Can someone help me out here.  i am sure i am overlooking something very obvious, but i am trying to do a filter on a TV date field in the ditto call and cannot get it to work right.  i want all docs that have an artcle_date (tvarticle_date to ditto) that are greater than now() to appear in this particular section - but continue to get no results.  here is the call:

[!Ditto? &display=`all` &tpl=`article_dittoTpl` &dateSource=`tvarticle_date` &dateFormat=`%A %B %d, %Y %r` &filter=`tvarticle_date, UNIX_TIMESTAMP(), 4` &sortBy=`tvarticle_date` &sortDir=`desc` &debug=`1`!]

I have tried the non-UNIX timestamp (CURRENT_TIMESTAMP()) as well and still get no results.

thanks in advance for any help on this.

[rthrash]

Is unix_timestamp() or current_timestamp() a PHP function? I can't find a reference to those, and if they are I believe the syntax is @CODE:unix_timestamp(); ... but I'm probably wrong there... Mark?

There is time() available: http://www.php.net/manual/en/function.time.php

[bmcneill]

they are mysql syntax.  i was thinking it wanted that for the sql statement.  however, i did also try php syntax and could not get date() or time() to work either.

[heliotrope]

Hi,

php functions cannot be used as snippet params.
Create a new snippet with this code for instance

return time();

and then use it within your ditto call.

To embed a snippet inside another one you must use this syntax

[!Ditto? &filter=`tvarticle_date,[[myTimeSnippet]],3` => which means in ditto language Remove all documents from results where tvarticle_date is less than now.

:-)

[bmcneill]

ah yeah.  thanks for the BGO.  it works perfectly now. 

thanks all.

[Mark]

Ditto supports the @EVAL binding to evaluate php expressions in filter clauses. Thus, @EVAL time(); is the correct syntax to get the current unix timestamp ala http://modxcms.com/eval-binding.html. Here is a working example which will retrieve all documents in the last year.

Code:

[!Ditto?parents=`2`&debug=`1`&display=`all`&filter=`createdon,@EVAL return strtotime('-1 year');,6`!]

Also, here is a related thread:
http://modxcms.com/forums/index.php/topic,16012.0.html

[rthrash]

Great pointers Mark. Thanks

[bmcneill]

on a somewhat related note, if i wanted to add a default date to this TV (so a date is submitted even if the user does not actually select a date), can I use @EVAL return time() as the expression in the Default value of the TV?  I am using this right now and it is not writing a value to the database.  It may be that '@EVAL return time()' produces a UNIXTIME and I think the TV dates are saved to mysql in non-UNIX time format.  do i need to be formatting the 'time()' value to a non-UNIX date format for the default value?

[Mark]

The default value will be executed when the TV is loaded, not when saved. Thus, the default value would be the current time the tv is loaded.

[sal]

I was wondering on this point actually. I hoped the @EVAL thing would work to set the default date TV value to the current date but realised this probably wouldn't since the field is handled by Tigra so isn't an actual form field. Anyone know a quick way round this?

[FuryDE]

Ditto supports the @EVAL binding to evaluate php expressions in filter clauses. Thus, @EVAL time(); is the correct syntax to get the current unix timestamp ala http://modxcms.com/eval-binding.html. Here is a working example which will retrieve all documents in the last year.

Code:

[!Ditto?parents=`2`&debug=`1`&display=`all`&filter=`createdon,@EVAL return strtotime('-1 year');,6`!]

Hi, I wonder if this is correct ... The &filter EXCLUDES documents from the results. So, if you filter documents created on a date greater or equal (6) to "now minus one year", you EXCLUDE all the docs from last year, not include.

Also, I wonder why you first say @EVAL time(); is correct, but in your example you write @EVAL return strtotime(); (the difference is the "return").

I ask, because I am having massive problems with date filtering.

I also have a TV with unixtimestamp. Sorting works fine, but filtering doesn't work at all. i have &filter=`VAStart,@EVAL return time();,3` to filter out all events from the past. I get all docs. And, if i use 6 instead of 3, I also get all the docs.

Debugging shows me that the filter is recognized corretly and that the values of the VAStart TV are correct too. I don't know what the problem is.

BTW: I used Ditto 2.0.2, but I have just upgraded to 2.1. But I still run into the same problems.

Thanks
Martin