[Apeksha SinghParticipant]

Hi

I have used render in my code and i have also apply refresh but no impact in my code.
Please guide me regarding this problem & give reply as soon as possible.

Thanks & Regards
Apeksha

[Apeksha SinghParticipant]

Hi,
I have used max Range property in my project but when we enter value greater then 8 digit then inputbox automatically consider max value.
I need value in float format 10,2(ex-1212121212.00).Please guide me why this is happening and how to remove it.
Thanks & Regards
Apeksha

[Apeksha SinghParticipant]

Hi Peter Stoev,

Thanks for your response.
Can you please tell me how i can customize this generated excel .I want to format this excel according to me.
Please guide me regarding this as soon as possible.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

Thanks for your response.
Can you please tell me how i can customize this generated excel .I want to format this excel according to me.
Please guide me regarding this as soon as possible.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Peter Stoev,

Can we change the saving path of the xls generated by grid exportdata to a particular folder.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Peter Stoev,

I want to have a validation ,i.e. user cannot enter negative value in a grid cells.
Please guide me regarding this how I can do it.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Peter Stoev,

Thanks for your reply, it resolved my issue.

Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

Yes you were right , I implemented the exact code and it resolved my issue.
Thanks a lot.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

I read the forum topic JSON and newline char, but I am confused as cellsrenderer is used for HTML tags and “&” is not an html tags.
So how I can use cellsrenderer for the above issue.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

If you can tell me the fix I will be really thankful to you as I cant update my jQWidgets version right now.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

One more issue is there on filtering any string that contains “&” it filter and change the string “& amp ;”

For example :-
If the string was – “PROFIT & LOSS ACCOUNT”
It filters and show – “PROFIT & amp ; LOSS ACCOUNT”

Please guide me regarding this as soon as possible.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

One more issue is there on filtering any string that contains “&” it filter and change the string “&”

For example :-
If the string was – “PROFIT & LOSS ACCOUNT”
It filters and show – “PROFIT & LOSS ACCOUNT”

Please guide me regarding this as soon as possible.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

Yes this was the issue I didn’t noticed it 😛 .Thanks a lot for your reply.

But still I am facing one issue, let me explain you in steps it might clear what I want to say :-

1- If I select a particular column for filtering say in context of my code I selected “To”.
2- Then in the list I have 4 names say – “Apeksha”,”Dimitar”,”Peter”,”Damen”.
3- Now when I enter “D” in the input field , the filter response properly everything is working fine it filter and show me two names “Dimitar” and “Damen”.
4- Now if I enter “Z” as you can see there is no word in the column that contain “Z” letter.
5- So the grid remove all the data and show “No data to Display”.
6- Now I deleted the “z” letter from input it return me the previous grid data.

But there is a design displacement of text in the first cell of first column , first row only. The text is moved to left.
I am not able to understand why is it happening.

Please guide me regarding this as soon as possible.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Dimitar,

I have changed the ‘keyup’ to ‘change’ but still the date filter is not getting removed when the value of the input has changed or removed.
I am not able to get my original grid data back.

I am adding my piece of code please have a look :-

rendertoolbar: function (toolbar) {
                        //jshint unused:vars
                        var me = this;
                        var container = $("<div style='margin: 5px;'></div>");
                        toolbar.append(container);
                        var input = $("<input class='jqx-input jqx-widget-content jqx-rc-all' id='searchField' type='text' placeholder='Search' style='height: 23px; float: right; width: 150px;' />");
                        var combobox = $("<div id='selectSearchField'></div>");
                        container.append(input);
                        container.append(combobox);
                        var source = ["Number", "To", "Date", "Due Date", "Status"];
                        combobox.jqxComboBox({
                            source: source,
                            selectedIndex: -1,
                            promptText: "Select Column",
                            width: "20%",
                            height: "20",
                            theme: "ui-start"
                        })
                        combobox.on("change", function () {
                            input.val("");
                            $('#all_invoicetable').jqxGrid('clearfilters');
                        });
                        $(combobox).on("select", function (event) {
                            //$("#all_invoicetable").jqxGrid({ showfiltercolumnbackground: false});
                            var args = event.args;
                            if (args) {
                                var item = args.item;
                                // get item"s label and value.
                                var label = item.label;
                                //alert("ssds"+label);
                                if (label === "Number") {
                                    searchDatafield = "number";
                                } else if (label === "Date") {
                                    searchDatafield = "date";
                                } else if (label === "Due Date") {
                                    searchDatafield = "due_date";
                                } else if (label === "To") {
                                    searchDatafield = "contact_name";
                                } else {
                                    searchDatafield = "workflow_status_status";
                                }
                            }
                        });
                        //var searchDatafield = "number";
                        input.on("change", function (event) {
                            var searchText = input.val();
                            var filtertype = 'stringfilter';
                            if (searchDatafield == 'due_date' || searchDatafield == 'date') {
                                filtertype = 'datefilter';
                            };
                            if (searchText == " ") {
                                //alert("in");
                                $("#all_invoicetable").jqxGrid("clearfilters");
                            } else {
                                $("#all_invoicetable").jqxGrid("removefilter", searchDatafield);
                                var filtergroup = new $.jqx.filter();
                                var filterOrOperator = 1;
                                var filtervalue = searchText;
                                var filtercondition = "contains";
                                if (searchDatafield == 'due_date' || searchDatafield == 'date') {
                                    filtervalue = new Date(searchText);
                                    //filtervalue.setMinutes(0, 0, 0);
                                    //filtervalue.setHours(0);
                                    filtercondition = "EQUAL";
                                };
                                var filter = filtergroup.createfilter(filtertype, filtervalue, filtercondition);
                                filtergroup.addfilter(filterOrOperator, filter);
                                //console.log("filters------", filter);
                                $("#all_invoicetable").jqxGrid("addfilter", searchDatafield, filtergroup);
                                $("#all_invoicetable").jqxGrid("applyfilters");
                            };
                        });
                    },

Please guide me as soon as possible.

Thanks & Regards,
Apeksha

[Apeksha SinghParticipant]

Hi Peter Stoev,

Thanks for your response it helps.

Regards,
Apeksha

[Author]

Posts