Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
50
DateColumn Remote filter issue
posted

Hi,

IgGrid having the Date column. Also return modle property is DataTime datatype.But when doing grid remote Filtering it is not happeing for the date column.

When i saw in the query string filter text is passing as number.

Kindly advice 

&filter(LastRun)=on(1557167400000)&page=0&pageSize=25&_=1557224260442

$('#Grid').igGrid({
dataSource: url,
DataSourceType: "json",
responseDataKey: "Records",
autoGenerateColumns: true,
autoGenerateLayouts: true,
columns: "[{"headerText":"Job ID","key":"Id","dataType":"number","width":"10%","hidden":false,"format":""},{"headerText":"Last Run","key":"LastRun","dataType":"date","width":"20%","hidden":false,"format":"MM/dd/yyyy HH:mm:ss"}]",
height: "500px"
});


public class ScheduledData
{
public int Id { get; set; }
public DateTime? LastRun { get; set; }
}

  • 17590
    Offline posted

    Hello Rajesh,

    Thank you for posting in our community.

    The date in the query string is represented in ticks so from my point of view everything seems correct. 

    What I noticed is that in your igGrid configuration Filtering feature is not enabled. In order to ensure that the issue is addressed correctly I will need some additional information regarding your scenario. Perfectly, if you can provide me a working, isolated sample, where the issue is reproducible, this is going to be very helpful. Alternatively, please provide me your entire grid configuration, steps to reproduce and any details that you consider relevant.

    Looking forward to hearing from you.