[RamParticipant]

Hi Dimitar,

Recently we have got into this problem where the thousand separator is applied automatically while using the cellsformat: f1 for a float data type column. As suggested, we tried to change the data type to “string” and could see that the thousand separator is not applied. But the filter options are also changed to string operators instead of numeric operators which is obvious.

Could you please let us know that is there any other way to remove the thousand separator while using the cellsformat for numeric columns.

[RamParticipant]

Hi Peter,

Apologies for the misunderstanding. We will rather keep it simple

1. Applying ‘dd/MM/yyyy hh:mm tt’ format on ‘bindingcomplete’ event
2. Applying ‘dd/MM/yyyy’ instead of the above format for the filtervalue on ‘updatefilterpanel’ function.
3. Applying the filter and opening the filterpanel again is not retaining the above filtervalue in the filter panel text box.

In your recent sample you removed the formatting in the ‘bindingcomplete’ event. Could you please have a look at this sample http://jsfiddle.net/pwatdcpk/ and follow this scenario

1. Filter date column with both “02 Dec 2014” and “23 Dec 2014”
2. In the first case filtervalue retained and it’s not in the second case(23 Dec 2014)

This is the exact problem We are facing Peter.

Many thanks

[RamParticipant]

Hello Peter,

We have included the mentioned JS file but still we are not able to get things done. PFB for the exact steps we are following

1. Getting the date from the server.
2. Applying the “dd/MM/yyyy hh:mm tt” on “bindingcomplete” event

$("#jqxgrid").bind('bindingcomplete', function () {

      $("#jqxgrid").jqxGrid('setcolumnproperty', 'date', 'cellsformat', "dd/MM/yyyy hh:mm tt");
  });

3. Formatting the filter input value in “updatefilterpanel”

 updatefilterpanel: function (filtertypedropdown1, filtertypedropdown2, filteroperatordropdown, filterinputfield1, filterinputfield2, filterbutton, clearbutton,
            columnfilter, filtertype, filterconditions) {
          if (filtertype == "datefilter") {
                filterinputfield1.jqxDateTimeInput({ formatString:"dd/MM/yyyy" });
                 filterinputfield2.jqxDateTimeInput({ formatString:"dd/MM/yyyy" });
            }
        },

4. Apply the filter and open the filter panel again then the applied filtervalue will not be retained

Please have a look at updated example : http://jsfiddle.net/5qmpmpwd/1/

clarifications:
—————-
1. By default jqxgrid will interpret the datetime format in “MM/dd/yyyy” when it receives from the server? If not what is the default format will JqxGrid interprets if no format is specified in the datafield?

Could you please help.

Many thanks

[RamParticipant]

Hi Peter,

We have tried as you suggested but still it’s not working as we expected. We have created jsfiddle demo to help you understand our expectation.

Please have a look at this demo: http://jsfiddle.net/xjuo0ayo/

In the above demo try to apply a filter on the “Order Date” column and after applying filter, open the “Order Date” filter panel and there will be no date in the filter text box. The same is not happening with the “Product” column.

Kindly help to avoid this behavior as we are stuck with this issue for quite a some time now.

Many thanks

[RamParticipant]

Hi Peter,

Thanks for the reply. You meant to say that the above code will clear the filter text box value after filtering because of the format we are applying.

If so then what could be done to retain the filter text box value after filtering has been applied?

[RamParticipant]

Hi Dimitar,

We are also facing the same problem and the above solution is worked fine but only problem we are facing is that because of the formatting inside the “updatefilterpanel” method, after filtering the data the filter value in the filter text box is not retained i.e. we could only see empty text box if we open the filter panel again after filtering.

Is this an existing issue or any workaround to overcome this. Please help

Many thanks

[RamParticipant]

Hello Dimitar,

We have tried it but no luck still we are getting same error. Could you please let us know is there any method that will clear both filters and sort applied on the grid?

Many thanks

[RamParticipant]

Hi Dimitar,

Thanks for the reply.

It’s because we are doing both “clearfilters” and “removesort” calls sequentially and they are clashing on the same grid. Could you please suggest what could be done here?

[RamParticipant]

Hello Dimitar

Can I have any solution please?

Many thanks

[RamParticipant]

Hi Dimitar,

We have tried with version 3.6.0 as well but still we could not able to proceed.

PFB for the steps we have implemented (Assumption: Serverside processing)

1. Grid having 10 columns and we are having a checkbox list for 5 more optional columns.
2. We have added one optional column using showcolumn method and applied both sorting and filtering on the optional column
3. Then we removed the optional column using hidecolumn method and before calling hidecolumn, we have called both clearfilters and removesort in the order.
4. Only filtering gets cleared and we are getting the above error in console instead of sort removal on the grid and sometimes even the hidecolumn is not working because of the error.

Could you please provide an workaround as we are stuck with this for quite long.

Many thanks

[RamParticipant]

Hi Dimitar,

Thanks for the response. We have created a JS Fiddle sample which will resemble our functionality.

Here is the sample : http://jsfiddle.net/9udLb2z7/

But in the sample it seems to be working as it’s local data source. When we are trying to implement the same on the server side then we are getting the error I mentioned in the post.

So could you please suggest us a way how could we achieve removing both sort and filter applied on grid before show/hide column

Many thanks

[RamParticipant]

Thanks Peter. It worked

[RamParticipant]

Thanks for the response Peter. Will try it

[Author]

Posts