[Sibeesh VenuParticipant]

Hi Dimitar,
I does not seems to be working there too. Please try adding the object values to the console and check.
console.log(scrolling.horizontal); It always return false.

[Sibeesh VenuParticipant]

Hi Dimitar,
It is scrolling. Actually I am getting the object as scrolling = Object {vertical: false, horizontal: false}. The horizontal value is suppose to be true when we scroll horizontally and vice versa. Can you please check that? In the above example, it shows false always.

[Sibeesh VenuParticipant]

Hi Dimitar,
I tried the code you have posted. In my case in mousemove itself it is showing false for both vertical and horizontal options. Can you please any other options we have. I tried the below code in the ready event.

$("body").mousemove(function () {
                var scrolling = $("#jqxgrid").jqxGrid("scrolling");
                if (scrolling.vertical == true) {
                    $("#log").append("scrolling <br />");
                };
            });

Thanks in advance.

[Sibeesh VenuParticipant]

Sorry for that, please reply here http://www.jqwidgets.com/community/topic/order-jqx-grid-jqwidget-filter-conditions/

[Sibeesh VenuParticipant]

Suppose I have a grid as follows,

`$(“#jqxgrid”).jqxGrid(
{
source: data,
columns: [{ “text”: “Area Code”, “dataField”: “AreaCode”, “cellsalign”: “left”, “cellsformat”: “d” }, { “text”: “Revenue”, “dataField”: “Revenue”, “cellsalign”: “right”, “cellsformat”: “c2” }],
pageable: true,
filterable: true,
sortable: true,
rendered: function () {
var localizationobj = {};
filterstringcomparisonoperators = [‘equal’, ’empty’, ‘not empty’, ‘contains’, ‘does not contain’, ‘starts with’, ‘ends with’, ‘null’];
filternumericcomparisonoperators = [‘equal’, ‘not equal’, ‘less than’, ‘less than or equal’, ‘greater than’, ‘greater than or equal’, ‘null’, ‘not null’];
filterdatecomparisonoperators = [‘equal’, ‘not equal’, ‘less than’, ‘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.
$(“#jqxgrid”).jqxGrid(‘localizestrings’, localizationobj);
},
updatefilterconditions: function (type, defaultconditions) {
var stringcomparisonoperators = [‘EQUAL’, ‘EMPTY’, ‘NOT_EMPTY’, ‘CONTAINS’, ‘DOES_NOT_CONTAIN’, ‘STARTS_WITH’, ‘ENDS_WITH’, ‘NULL’];
var numericcomparisonoperators = [‘EQUAL’, ‘NOT_EQUAL’, ‘LESS_THAN’, ‘LESS_THAN_OR_EQUAL’, ‘GREATER_THAN’, ‘GREATER_THAN_OR_EQUAL’, ‘NULL’, ‘NOT_NULL’];
var datecomparisonoperators = [‘EQUAL’, ‘NOT_EQUAL’, ‘LESS_THAN’, ‘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;
}
},
updatefilterpanel: function (filtertypedropdown1, filtertypedropdown2, filteroperatordropdown, filterinputfield1, filterinputfield2, filterbutton, clearbutton,
columnfilter, filtertype, filterconditions) {
var index1 = 0;
var index2 = 0;
filtertypedropdown1.jqxDropDownList({ autoDropDownHeight: true, selectedIndex: index1 });
filtertypedropdown2.jqxDropDownList({ autoDropDownHeight: true, selectedIndex: index2 });
}
});`

My requirement was showing equal as the default condition in filter, So I used updatefilterpanel. But now I have selected filter ‘Contains’ and apply filter. When I click on the applied filter and check, the condition is showing ‘Equal’ Instead of ‘Contains’ . I wanted the Equal conditions to be showed if there is no filters applied to that column. Any suggestions? Thanks in advance.

Kindest Regards
Sibeesh Venu

[Sibeesh VenuParticipant]

Hi Peter Stoev,

Thanks for your reply. I am getting this problem when I change async to false only. If I change it to true, the refresh button is coming perfectly. Please check.

Kindest Regards
Sibeesh Venu

[Sibeesh VenuParticipant]

Hi,
Any updates? Thanks in advance

[Sibeesh VenuParticipant]

Hi Peter Stoev,
Thanks for your reply. I will check as you said.

Kindest Regards
Sibeesh Venu

[Sibeesh VenuParticipant]

Hi Peter,
Thanks for your reply. I have tried that already, but when I customize the font-size and other CSS styles, I am experiencing an another issue. When ever I click on any rows or cells, the selection goes to other rows. Any help is appreciated.

Kindest Regards
Sibeesh Venu

[Sibeesh VenuParticipant]

Thanks for your reply, when I change async to true, the loading image is showing. Like I said, the issue exists only if async is false in source object. Please check and help me.

[Sibeesh VenuParticipant]

Hi Peter,
Since I have changed async:false , it seems the normal grid refreshing icons are not showing even when I clicked on sorting , filtering , page events. Can you please provide me any solution regarding this? Thanks in advance.

Kindest Regards
Sibeesh Venu

[Sibeesh VenuParticipant]

It seems I solved the issue. I added type: 'POST', in my source object. Thank you

[Sibeesh VenuParticipant]

I am just extending the data in the formatdata function as follows.

formatData: function (data) {                
                $.extend(data, {
                    selectedColumn: selectedColumn,
                    selectedRow: selectedRow,
                    selectedMeasures: selectedMeasures,
                    serverName: serverName,
                    databaseName: databaseName,
                    cubeName: cubeName,
                    queryTemplate: QueryTemplate,
                    chartMode: ChartMode,
                    chartType: chartType,
                    filterContent: filterContent,
                    FilterSelectedValue: FilterSelectedValue,
                    rollingTimePeriod: rollingTimePeriod,
                    calculatedmeasureVal: calculatedmeasureVal
                });
                return data;
            }

When I do that I am getting error. But when I pass less data in the variable FilterSelectedValue, it is working fine. Please advice me any fix. Thanks in advance.

Kindest Regards
Sibeesh Venu

[Sibeesh VenuParticipant]

I have done it by adding

updatefilterpanel: function (filtertypedropdown1, filtertypedropdown2, filteroperatordropdown, filterinputfield1, filterinputfield2, filterbutton, clearbutton,
                 columnfilter, filtertype, filterconditions) {
                var index1 = 0;
                var index2 = 0;
                filtertypedropdown1.jqxDropDownList({ autoDropDownHeight: true, selectedIndex: index1 });
                filtertypedropdown2.jqxDropDownList({ autoDropDownHeight: true, selectedIndex: index2 });
            }

Thanks a lot for your help.

[Sibeesh VenuParticipant]

I have done it by adding

updatefilterpanel: function (filtertypedropdown1, filtertypedropdown2, filteroperatordropdown, filterinputfield1, filterinputfield2, filterbutton, clearbutton,
                 columnfilter, filtertype, filterconditions) {
                var index1 = 0;
                var index2 = 0;
                filtertypedropdown1.jqxDropDownList({ autoDropDownHeight: true, selectedIndex: index1 });
                filtertypedropdown2.jqxDropDownList({ autoDropDownHeight: true, selectedIndex: index2 });
            }

Thanks a lot for your help.

[Author]

Posts