Welcome, Guest
Username: Password: Remember me

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

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

  • JoomGuy
  • JoomGuy's Avatar
  • 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
  1. Project: Project Man
  2. Template: Projects
  3. Layout: Projects (list)
  4. FF Version: 16.0.1
  5. OS: MacOSX 10.6.8 (Snow Leopard)
  6. Joomla Version: 2.5
  7. Environment: Sandbox & localhost
  8. Cook Version: 2.0
  9. JS: JQuery
  10. Form Style: Condensed
  11. Features: Maximum
  12. ToDo: No
  13. DB Automation: Model
  14. 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
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 985
  • 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
  • JoomGuy's Avatar
  • 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
  • JoomGuy's Avatar
  • 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...
  1. Boolean Filtering
  2. Publishing Fields
  3. Also, separate from filtering...
  4. 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
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 985
  • 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
  • JoomGuy's Avatar
  • 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
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 985
  • 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
  • JoomGuy's Avatar
  • Offline
  • Moderator
  • Joomla Enthusiast, Lover of Cooking
  • Posts: 1115
  • Thank you received: 195
  • Karma: 64
Awesome!!! I could :kiss: you (but I won't) :lol:

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
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 985
  • 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
  • JoomGuy's Avatar
  • 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
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 985
  • 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
  • JoomGuy's Avatar
  • 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! :lol:
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.
Time to create page: 0.164 seconds

Get Started