VOI
Member
Hi,
I would like to pre-filter a list to those datasets where one date element (date1) is greater than the other date element (date2).
So I applied the following pre-filter to the list:
Element: date1
Condition: GREATER THAN
Value: {table___date2}
Type: Eval
Access: Public
However, when looking list GetData section using fabrikdebug I get the following SQL Statement:
I.e. instead of the the element 'table.date2' I get the current date.
Is there anything I am doing wrong or some other way to achieve this kind of filtering?
Cheers
Chris
I would like to pre-filter a list to those datasets where one date element (date1) is greater than the other date element (date2).
So I applied the following pre-filter to the list:
Element: date1
Condition: GREATER THAN
Value: {table___date2}
Type: Eval
Access: Public
However, when looking list GetData section using fabrikdebug I get the following SQL Statement:
Code:
WHERE (table.date1 > '2013-06-07 00:00:00')
I.e. instead of the the element 'table.date2' I get the current date.
Is there anything I am doing wrong or some other way to achieve this kind of filtering?
Cheers
Chris