FlexGrid Filter by Date TimeZone

FlexGrid Filter by Date TimeZone

Posted by: 048alexsandr1992 on 26 April 2018, 8:35 pm EST

• 

  048alexsandr1992

  • Post Options:
  • Link
    Copy

  Posted 26 April 2018, 8:35 pm EST

  Hi,
  
  I have some problem with filtration by Date

  1. When I want filtrate on Equal, then no data to show

  http://joxi.ru/Grq9lR5fN3JKDr

  I looked at console and saw that in filterdefinition another value

  
  "{"defaultFilterType":1,"filters":[{"binding":"TestDate","type":"condition","condition1":{"operator":0,"value":"2018-03-31T21:00:00.000Z"},"and":true,"condition2":{"operator":null,"value":null}}]}"
  
  

  why ?

  2. I used column with data type “Date with time”

  
  bl.Add(cb => cb.Binding("TestDateTime").Width("*").Format("G").Header("TestDateTime").DataType(DataType.Date))
  
  

  But when I open filter it not show calendar and looked such as filter for string data

  
  http://joxi.ru/vAWpWBjCk9XQDr
  
  

  How I can show filter with calendar&

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 April 2018, 6:02 pm EST

  Hi Alex,
  
  We are sorry, we are not able to replicate the issue at our end. We are able to see null value for the Equals operator.

  Please refer to the attached sample:
  
  FlexGridIntro_Filter.zip

  2. The issue is because of “G” format applied to the Column. This issue seems a bug, hence we have forwarded this issue to the concerned team for further investigation with tracking id :319837.

  We will let you know as we get any update on this.

  ~Manish