Using element placeholder list pre-Filter is returning constand value

Status
Not open for further replies.

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:

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
 
I tried
value: table.date2
type: no quotes

That's working. Thanks for the hint.

Chris
 
Status
Not open for further replies.
We are in need of some funding.
More details.

Thank you.

Members online

No members online now.
Back
Top