Current Calendar Year prefilter query

[SoilentRed]

I'm trying to get a list of submissions that where only made in the year 2017 (this year). I've tried the IS GREAT THAN, IS GREAT THAN OR EQUALS, and Earlier this year conditions, but nothing is producing the results I would expect. I've also tried entering the date in the following formats: YYYY-MM-DD HH:MM:SS and YYYYMMDD. I also tried just writing out the prefilter query, but nothing seems to take. Would you please tell me what I'm doing wrong? Your help is always appreciated.

 

[troester]

Try
GREATER THAN OR EQUALS 2017-01-01

 

[cheesegrits]

I added 'this year' as a baked in pre-filter:

https://github.com/Fabrik/fabrik/commit/b16980aa00254125e56a29683b8181d71c31194f

Also fixed "earlier this year" (and "later this year") so it checks for YEAR() as well as DAYOFYEAR() ... prior to this, it would return any day number earlier in any year. So 2016-01-01 would be "earlier this year" for 2017-01-30.

-- hugh

 

[SoilentRed]

Mr Grits! First of all, thanks for putting work into this. I finally got around to making the changes. For whatever reason, it doesn't seem to want to accept the condition. Fabrik is still returning all the results from previous years.. Attached is what I've entered. Am I doing something wrong?

 

[cheesegrits]

Append &fabrikdebug=1 to your list URL, copy and paste the WHERE part from the getData debug output.

-- hugh

 

[SoilentRed]

This didn't give me any report. it just reloaded the list.

Now it gives a 404.

 

[SoilentRed]

To be clear, I did enable debugging. I have JCM Optimize on the site. Does this effect things?

 

[SoilentRed]

Got it to work. had to add a "?"

Here's the WHERE

HERE ( deal_blob.creator_groups = '2,15' OR deal_blob.creator_id = '71646416456' AND YEAR(deal_blob.date_time) = YEAR(NOW()) )

 

[troester]

Try with Grouped=yes in your AND condition
to get WHERE ( (deal_blob.creator_groups = '2,15' OR deal_blob.creator_id = '71646416456' ) AND YEAR(deal_blob.date_time) = YEAR(NOW()) )

 

[SoilentRed]

It still returns all results
Here's the debug:

WHERE ( deal_blob.creator_groups = '2,15' OR ( deal_blob.creator_id = '418469878941' AND YEAR(deal_blob.date_time) = YEAR(NOW()) ) )

 

[troester]

ok, then set the Grouped=yes on your 2nd condition

(I don't know where the "grouped" parenthesises are added, it must "group" the OR conditions)

 

[SoilentRed]

That did it. Thanks for your patience with this. You guys rock!

 

[cheesegrits]

Setting grouped should just group it with the previous filter. So if you set it on the second of (say) four prefilters, it should group the first two. Set it on the third, it'll group second and third. Set it on second and third, it'll group the first three.

Sent from my HTC 10 using Tapatalk