pre-filter on current week(number)

[susannanam]

hello all,

there is some great pre-filters like today, this month... how could i prefilter my list on the current week please? i have it as a number in an int field.

thanks
susanne

 

[troester]

WHERE
you-week-element
EQUALS
week(now())
Type: noquotes

 

[susannanam]

thanks troester for your feedback. i just tried and in mysql it works perfectly but as list pre-filter it shows no result at all. i have tried also other types (text, etc) but no luck so far

 

[troester]

Did you try with appending &fabrikdebug=1 to your list URL to see if it's creating the expected query?

 

[susannanam]

i added it at the end but nothing changes. i think i will then have to do a view and base the list on that to make it work.. thanks a lot troester

 

[troester]

You must enable Fabrik debug in Fabrik options to see something.
Do you have a link to your list?

 

[susannanam]

thanks troester, i got it now right with this one: WEEKOFYEAR(NOW())