Welcome, Guest

TOPIC: [FIXED] RANGE FILTERING: Datetime Fields COOK V2

[FIXED] RANGE FILTERING: Datetime Fields COOK V2 13 Oct 2012 11:33 #4456

JoomGuy
Offline
Moderator
Joomla Enthusiast, Lover of Cooking
Posts: 1115
Thank you received: 195
Karma: 64

Hi @admin,

Me again! Once again, I know that this has been discussed previously but from searching the forum, it appears that it was some time ago.

Symptoms
I have 2 datetime fields that I'd like to filter range on; Closing Date & Notify Date however they do not work - I mean, they cannot populate the range filter. Is this a bug?

The main reason I ask is, there is clearly no problem with filter range by date formatted fields as modified_date & creation_date work perfectly - I'm currently using these in range filters as a means of testing.

BTW - nice to see the implementation of the date picker when dates are added as a range filter! When did that happen? I remember requesting that a while back... Thanks K+1

CONFIG

Project: Project Man
Template: Projects
Layout: Projects (list)
FF Version: 16.0.1
OS: MacOSX 10.6.8 (Snow Leopard)
Joomla Version: 2.5
Environment: Sandbox & localhost
Cook Version: 2.0
JS: JQuery
Form Style: Condensed
Features: Maximum
ToDo: No
DB Automation: Model
Timeout: 20 secs

Anyways, look forward to hearing from you soon!

Best wishes,

Gez

Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!!

Last Edit: 16 Oct 2012 15:13 by admin.

The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 14 Oct 2012 21:57 #4509

admin
Offline
Administrator
Chef
Posts: 3711
Thank you received: 987
Karma: 140

Datepicker in range should be working.
The problem is in the builder, there is a little annoying bug.

Did you setted up a search box using these fields you try to instance in the range ?

If true :
- Remove the dates fields from the search box.
- Fill the range filter with it (should work now)
- Drop again this date in the searchbox (if needed)

This is due to the fact that a field cannot be used in 2 differents filters (limitation) except for the searchbox. But the builder interface is locking it when the field is already used, even in searchbox.
I must fix this.

Hope it help.
Any changes ?

Coding is now a piece of cake

The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 14 Oct 2012 22:17 #4511

JoomGuy Offline Moderator Joomla Enthusiast, Lover of Cooking Posts: 1115 Thank you received: 195 Karma: 64	Hi @admin, No, I don't have the fields in any other filters. BTW, not sure if it makes any difference but they are datetime fields. Thanks, Gez
	Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!! The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 10:48 #4553

JoomGuy Offline Moderator Joomla Enthusiast, Lover of Cooking Posts: 1115 Thank you received: 195 Karma: 64	Any news on this Jocelyn - or the other filtering issues? Others... Boolean Filtering Publishing Fields Also, separate from filtering... Ordering Fields Many Thanks, Gez
	Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!! Last Edit: 16 Oct 2012 10:49 by JoomGuy. The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 12:53 #4556

admin Offline Administrator Chef Posts: 3711 Thank you received: 987 Karma: 140	Fixed in local. It is coming today in the next upgrade. I am trying to fix more issues for this upgrade right now.
	Coding is now a piece of cake The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 12:54 #4557

JoomGuy Offline Moderator Joomla Enthusiast, Lover of Cooking Posts: 1115 Thank you received: 195 Karma: 64	Hi @admin, That's brill! Is that including the Boolean Filtering, Publishing Filtering and Ordering fields? many thanks, Gez
	Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!! The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 12:58 #4559

admin Offline Administrator Chef Posts: 3711 Thank you received: 987 Karma: 140	Only publishing filter is not fixed yet. I must rewrite the filters files because my framework is not very good there. So it will take a bit of time, but it is fundamental, I know. You will get a special 'State' filter for that in the toolbox.
	Coding is now a piece of cake The administrator has disabled public write access. The following user(s) said Thank You: JoomGuy

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 13:03 #4560

JoomGuy Offline Moderator Joomla Enthusiast, Lover of Cooking Posts: 1115 Thank you received: 195 Karma: 64	Awesome!!! I could you (but I won't) Any ideas on a timeframe for state? I'm only asking because I won't bother putting my publishing fields into tables in the meantime if I'm going to go and swap them all out in my layouts later... Many thanks, Gez
	Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!! The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 15:11 #4568

admin Offline Administrator Chef Posts: 3711 Thank you received: 987 Karma: 140	Fixed.
	Coding is now a piece of cake The administrator has disabled public write access. The following user(s) said Thank You: JoomGuy

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 15:25 #4578

JoomGuy Offline Moderator Joomla Enthusiast, Lover of Cooking Posts: 1115 Thank you received: 195 Karma: 64	On fire today like a ninja bug-exterminator! K+1 [EDIT - sorry, I couldn't increase again so will do later or tomorrow!!!] Thanks, Gez
	Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!! Last Edit: 16 Oct 2012 15:26 by JoomGuy. The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 15:30 #4581

admin Offline Administrator Chef Posts: 3711 Thank you received: 987 Karma: 140
	Coding is now a piece of cake The administrator has disabled public write access.

Re: RANGE FILTERING: Datetime Fields COOK V2 16 Oct 2012 17:04 #4584

JoomGuy Offline Moderator Joomla Enthusiast, Lover of Cooking Posts: 1115 Thank you received: 195 Karma: 64	I'll be really disappointed if you don't look like this should we ever meet!
	Need help with your Cook/Joomla Project? . PM me to find out what I can help with. NO time wasters please!!! The administrator has disabled public write access.