Flexicontent List filter module - date filter

More
6 years 1 month ago - 6 years 1 month ago #72083 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 1 month ago by ggppdk.

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

More
6 years 1 month ago #72084 by bytekultur
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.

More
6 years 1 month ago #72085 by ggppdk
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.

More
6 years 1 month ago #72086 by ggppdk
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


-- 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...

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

More
6 years 1 month ago #72087 by bytekultur
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.

Moderators: vistamediajoomlacornerggppdk
Time to create page: 0.857 seconds
Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline