Flexicontent List filter module - date filter

bytekultur
Topic Author
Offline
Premium Member

6 years 8 months ago - 6 years 8 months ago #72083 by bytekultur

Flexicontent List filter module - date filter was created by bytekultur

Hello, I ran into a problem with my date filter. I set this to filter by year.
I have a combination of date and category filter, and after filtering by category, the date filter has an updated item count, it looks like '2018 (6)', for example. If I filter by that year now, there are no items shown.

Did I misconfigure it?
After some debugging, I discovered the date filter to use this where clause in the database query:

Code:

WHERE 1 AND ( DATE_FORMAT(c.publish_up, "%Y") =  DATE_FORMAT('2018', "%Y") )

The argument after the = would work if it was just the value of the year (i.e. '2018'), while the current operation would be NULL, so I am not sure how to get this to work.

Thank you and kind regards,
Terry

Last edit: 6 years 8 months ago by ggppdk.

Please Log in or Create an account to join the conversation.

bytekultur
Topic Author
Offline
Premium Member

6 years 8 months ago #72084 by bytekultur

Replied by bytekultur on topic Flexicontent List filter module - date filter

Very sorry, I just saw there was an update for FlexiContent - I used version 3.2.1.10 and now have 3.2.1.12, that seems to have solved it.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

6 years 8 months ago #72085 by ggppdk

Replied by ggppdk on topic Flexicontent List filter module - date filter

Hello

are you using FLEXIcontent v3.2.1.12+ ?

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

The following user(s) said Thank You: bytekultur

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

6 years 8 months ago #72086 by ggppdk

Replied by ggppdk on topic Flexicontent List filter module - date filter

Hello

i see you posted same time as i was asking the question
this issue was fixed in v3.2.1.12

See change log here:
github.com/FLEXIcontent/flexicontent-cck/releases/tag/v3.2.1.12

Please Log in or Create an account to join the conversation.

bytekultur
Topic Author
Offline
Premium Member

6 years 8 months ago #72087 by bytekultur

Replied by bytekultur on topic Flexicontent List filter module - date filter

I was just a second before your answer, yes. I wasn't and the update has solved it.
My other issue (with the same filter module) still persists though flexicontent.org/forum/21-troubleshootin...t-filter-module.html , but maybe it's not a bug, just me being lost in configuration...

Please Log in or Create an account to join the conversation.