jQWidgets Forums

jQuery UI Widgets › Forums › Grid › jqxGrid filtering of date values

Tagged: 

This topic contains 6 replies, has 2 voices, and was last updated by  Gecko 11 years, 5 months ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    jqxGrid filtering of date values Posts
  • September 9, 2013 at 4:24 pm jqxGrid filtering of date values #28591

    Gecko
    Participant

    I see that version 3.0.2
    – Fixed an issue in jqxGrid regarding the server filtering of date values. The parameters sent to the server are now formatted using the Column’s cells format set by the user.

    Which is perfect because I was having issue filtering dates, but I’m not seeing the fix. Could you please elaborate?

    If I have
    a datafield like
    { name: ‘startTime’, type: ‘date’ },
    a column like
    { text: ‘Started’, datafield: ‘startTime’, width: 140, align: ‘center’, cellsalign: ‘center’, cellsformat: ‘MM/dd/yy hh:mm tt’},

    It shows great 09/09/13 07:00 AM
    but doesn’t filter well.
    The new version fix I thought would allow be to filter ‘less than’ in the exact same format, but the only thing I can get to work is to enter 09-September-2013 which is less than desirable and if I include time like 09-September-2013 09:00 AM it returns no rows.

    Am I not able to filter ‘Less than’ 09/09/13 07:00 AM or am I missing something?
    If I can’t filter with this format what format do I have to use to filter with date/time?
    Thanks.

    September 9, 2013 at 6:49 pm jqxGrid filtering of date values #28598

    Peter Stoev
    Keymaster

    Hi Gecko,

    The fix is about the data format sent to the server when a Date column is filtered and that does not seem to be related to your scenario. We will test whether there is something wrong with the Format String that you use in your application.

    Best Regards,
    Peter Stoev

    jQWidgets Team
    http://www.jqwidgets.com/

    September 12, 2013 at 3:27 pm jqxGrid filtering of date values #28864

    Gecko
    Participant

    Can anyone tell me how to the correct input for a user to ‘less than’ filter on a date column that contains a date & time?
    I found that I can use 05-September-2013 but I haven’t found the syntax to include time in the filter (05-September-2013 09:00 AM fails).

    September 17, 2013 at 7:26 pm jqxGrid filtering of date values #29144

    Gecko
    Participant

    So no one on this forum uses times in their date fields?

    October 17, 2013 at 2:48 pm jqxGrid filtering of date values #30944

    Gecko
    Participant

    @Peter

    “We will test whether there is something wrong with the Format String that you use in your application.”

    Any update?

    November 14, 2013 at 10:24 pm jqxGrid filtering of date values #32670

    Gecko
    Participant

    @Peter

    It’s been two months. Is this a bug?

    If you have { text: ‘Started’, datafield: ‘startTime’, cellsformat: ‘MM/dd/yy hh:mm tt’}
    And attempt to column filter ‘less than’ in the exact same format 09/09/13 07:00 AM, it does not return any values.

    December 5, 2013 at 10:53 pm jqxGrid filtering of date values #46046

    Gecko
    Participant

    bump.

  • Author
    Posts
Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.