[Sibeesh VenuParticipant]

And I have already asked this in past.
http://www.jqwidgets.com/community/topic/order-jqx-grid-jqwidget-filter-conditions/

[Sibeesh VenuParticipant]

Please be noted that I have already applied that.

rendered: function () {
                var localizationobj = {};
                filterstringcomparisonoperators = ['empty', 'not empty', 'equal', 'contains', 'does not contain', 'starts with', 'ends with', 'null'];
                filternumericcomparisonoperators = ['not equal', 'less than', 'equal', 'less than or equal', 'greater than', 'greater than or equal', 'null', 'not null'];
                filterdatecomparisonoperators = ['not equal', 'less than', 'equal', 'less than or equal', 'greater than', 'greater than or equal', 'null', 'not null'];
                filterbooleancomparisonoperators = ['equal', 'not equal'];

                localizationobj.filterstringcomparisonoperators = filterstringcomparisonoperators;
                localizationobj.filternumericcomparisonoperators = filternumericcomparisonoperators;
                localizationobj.filterdatecomparisonoperators = filterdatecomparisonoperators;
                localizationobj.filterbooleancomparisonoperators = filterbooleancomparisonoperators;

                // apply localization.
                $(openFrom + "#jqxgrid").jqxGrid('localizestrings', localizationobj);
            },
            updatefilterconditions: function (type, defaultconditions) {
                var stringcomparisonoperators = ['EMPTY', 'NOT_EMPTY', 'EQUAL', 'CONTAINS', 'DOES_NOT_CONTAIN', 'STARTS_WITH', 'ENDS_WITH', 'NULL'];
                var numericcomparisonoperators = ['NOT_EQUAL', 'LESS_THAN', 'EQUAL', 'LESS_THAN_OR_EQUAL', 'GREATER_THAN', 'GREATER_THAN_OR_EQUAL', 'NULL', 'NOT_NULL'];
                var datecomparisonoperators = ['NOT_EQUAL', 'LESS_THAN', 'EQUAL', 'LESS_THAN_OR_EQUAL', 'GREATER_THAN', 'GREATER_THAN_OR_EQUAL', 'NULL', 'NOT_NULL'];
                var booleancomparisonoperators = ['EQUAL', 'NOT_EQUAL'];
                switch (type) {
                    case 'stringfilter':
                        return stringcomparisonoperators;
                    case 'numericfilter':
                        return numericcomparisonoperators;
                    case 'datefilter':
                        return datecomparisonoperators;
                    case 'booleanfilter':
                        return booleancomparisonoperators;
                }
            }

I have tried even changing the condition order, but still it is not working. Please check and help me.

[Sibeesh VenuParticipant]

In that demo you are applying a default filter, I do not need to apply any filter, I just need that ‘Equal’ condition should come first in the drop down for all type of filter( String, numeric).

[Sibeesh VenuParticipant]

I changed my source object as follows, changed async to false, now it seems everything works fine.

var source =
                      {
                          datafields: DataFields,
                          datatype: "json",
                          async:false,
                          url: '../Widget/GetDataForGrid/',
                          sort: function () {
                              $("#jqxgrid").jqxGrid('updatebounddata', 'sort');
                          },
                          filter: function () {
                              $("#jqxgrid").jqxGrid('updatebounddata', 'filter');
                          },
                          beforeprocessing: function (data) {
                          }
                      };

Thank you

[Sibeesh VenuParticipant]

But the filter is already applied, and is there anyway to know whether the filter process is done or not, any events like that? So I can call sort function in that event. Please reply me. Thanks in advance.

[Sibeesh VenuParticipant]

Update:

Below is my ready event.

ready: function () {
                applyColumnFilter();
                applyColumnSort();
            }

I found out the problem, actually when I call the sorting function alone in the ready event it works, but when I call the same after filter function it throws error. So that the filter is getting applied but sorting is not working.

[Sibeesh VenuParticipant]

In normal grid it works fine, I am getting this issue only when I changed my grid to server side one. Any help is appreciated. Actually, the ready event fires after every grid related stuffs are over right?

[Sibeesh VenuParticipant]

Hi,
Thanks for your reply and sorry for the late reply. I tried your link, and I modified with the properties I gave in my grid. Not it throws errors. Can you please check this. I strongly believe that mouse selection issue is because of property mismatching. The link to new jsfiddle is http://jsfiddle.net/sibeeshvenu/eagh2q8g/3/

Kindest Regards
Sibeesh Venu

[Sibeesh VenuParticipant]

Hi,
I am setting DataColumns as follows.

var DataColumns=sessionStorage.getItem('DataColumns');

I just need the columngroup information after the grid is loaded, so that I can save that as a json and retrieve in edit mode. Is there any way? Please help me.

[Sibeesh VenuParticipant]

Hi Dimitar,

Thank you for your reply. Here by I am pasting my codes.

 var cols = $("#advancedgrid").jqxGrid("columns");
    sessionStorage.setItem('DataColumns', JSON.stringify(cols));

And in the grid setting I gave

width: '99.8%',
        source: dataAdapter,
        columns: DataColumns,

getcolumn method returns a JSON object.

Kindest Regards
Sibeesh Venu
http://sibeeshpassion.com/

[Sibeesh VenuParticipant]

Hi Dimitar,
Thanks a lot for your reply.
If we use `$(“#advancedgrid”).jqxGrid(“columns”) we will get an array which contains data fields of all the columns right? I need to get a method something like that.
It seems we need to pass each column datafields to the ‘ $(‘#jqxgrid’).jqxGrid(‘getcolumnproperty’) . Since I am using dynamic data and values. It is bit tough to pass all the values one by one. So is there any method available which returns all the info about the data fields ? If yes please share me. Thanks in advance

Kindest Regards
Sibeesh Venu
http://sibeeshpassion.com/

[Sibeesh VenuParticipant]

Dear Dimitar,

Thanks a lot for the reply. But I Have already called an Ajax call in the rendergridrows function. And I am taking only 10 rows per call (max 100). So performance will be good enough. Since I am using ADOMD as my source, none of your demo’s are suitable for my requirement, that is why I have chosen this method.Please help me through this. Please share any demo’s related to this requirement if you have such a one. Thanks in advance.\

Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
Do you have any Implementation of the same with all the features of the JQXGrid? I mean filtering,sorting,searching,Pinned,etc…What My doubt is If i implemented these features, will the grid performance go down? And for every sorting,searching,filtering it will go to the server right?Please give me a link with all the functionality. Waiting for your reply. Thanks in advance.
Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

Hi Dimitar,
Thank you for your post. I need one more clarification. I am working on ADOMD CellSet (Microsoft analysis service ,MDX Queries) . Any implementation available for the same in ADOMD instead of SQL ? Looking forward to hear from you.
Kindest Regards
Sibeesh

[Sibeesh VenuParticipant]

I found out the PHP version for the requirement here
Is there any dot net implementation available ?

Kindest Regards
Sibeesh

[Author]

Posts