[Singh_kiatecParticipant]

Hi Hristo,

Thanks for the example. It works like a champ.

Regards
Singh

[Singh_kiatecParticipant]

Hej Hristo,

I appreciate for the quick response.
If i change my machine time to Los Angeles, CA- Unites states the date changes.

screen shot for reference:
https://ibb.co/bRy3nb3

https://ibb.co/T4VYmp8

Thanks in advance.

[Singh_kiatecParticipant]

Hi Hristo Hristov,

Thanks for the quick response.

Yes thats true. i am trying to achieve to show the same date as received from the server.

Now it works and shows the same date as received from the server . But it now makes filtertype ‘range’ disappear.
I have used the
cellsformat:’dd-MM-yyyy HH:mm:ss’,
filtertype:’range’,

https://ibb.co/4jsygYK

Thanks in advance.

[Singh_kiatecParticipant]

Hi Hristo,

I have the same issue , as we have a date i.e 2020-10-27 and it is displayed in GRID 27-10-2020 as expected . But now my team mate see it as 26-10-2020 from his machine as his system timezone is Los Angeles, CA, USA* PDT (UTC -7) .

And i could reproduce it from the above jsfiddle below is the url of the screen shot for reference. I tried all possible ways as mentioned above.

https://ibb.co/jZrk9bx

Am i missing anything?

Thanks in advance.

[Singh_kiatecParticipant]

Hi Team,

I am using angular and the load state works perfectly fine with dropdown filter and text but not with the date range . Am i missing something?

Screen shot
https://pasteboard.co/JwwSZYe.png

jqwidgets version : 10.1.5

Example of state object.
columns: {levering: {…}, organisation_uuid: {…}, bruger_uuid: {…}, navn: {…}, brugernavn: {…}, …}
filters:
filtercondition0: “GREATER_THAN_OR_EQUAL”
filtercondition1: “LESS_THAN_OR_EQUAL”
filterdatafield0: “levering”
filterdatafield1: “levering”
filteroperator0: 0
filteroperator1: 0
filterscount: 2
filtertype0: “datefilter”
filtertype1: “datefilter”
filtervalue0: “20-10-2020 00:00:00”
filtervalue1: “20-10-2020 23:59:59”
leveringoperator: “and”

Thanks in advance.

[Singh_kiatecParticipant]

Hi Hristo Hristov,

Do we have any update on this.

Thanks in advance.

Regards
Singh_kiatec

[Singh_kiatecParticipant]

Hi Hristo Hristov,

Thanks for the. quick response.

I see that we can still reproduce the bug in the shared example(http://jsfiddle.net/0k2sod54/)

Step to reproduce.

step1. Change the cellsformat to as cellsformat: “dd-MM-yyyy”. (Column format is changed that is correct and works as expected)
Step 2: now go to filter of the date column . we see the format of the date is different(date is showed in localdate time format not “dd-MM-yyyy”).

Thanks
Regards
Singh_kiatec

[Singh_kiatecParticipant]

Dear Hristo Hristov,

Thanks for the quick response.
That seems to work thanks:). but now the date in filter seems does not respect the cellsformat value.

Lets say i have the cellsformat= “dd-MM-yyyy” and nullable:true has been set . Although the date in column seems to respect the cellsformat but not in the filter. Is is because some of the dates are null?

Screen shot for reference:
https://ibb.co/jHNMDmB

Thanks in advance.
Regards
Singh_kiatec

[Singh_kiatecParticipant]

Hi Team ,

I have the slightly similar issue on displaying date .

I have the filter on grid and column is date. and cellsformat formats as expected. But when the date is null the filter shows date as 01-01-1970 or sometimes . Could you please suggest me if i am missing anything. using jqwidgets version 9.1.6.

filtertype=”checkedlist”;
cellsformat=”dd-MM-yyyy”;
type=”date”;
nullable = true;
columntype=”datetimeinput”

Thanks in advance.

[Singh_kiatecParticipant]

Hi Peter,

any update to support .xlsx Excel format to exportdata?

Thanks
Singh

[Singh_kiatecParticipant]

Hi Hristo,

Thanks it works like a champ, But i just found a minor issue after update .the height 100% does not work ,which was working fine earlier, I tried both ways [height]=”‘100%'” and this.settings = {width: ‘100%’,height:’100%’,} , Width works , but not height, am i missing anything.

Thanks

[Singh_kiatecParticipant]

Hi Hristo,

Do we have any update on this alignment bug.

Thanks,

[Author]

Posts