loadComplete does not fire.

[njaParticipant]

Hi,
What I want is a drop down in my grid that has a display field and a value field, but I dont’ think that is possible (from what I read on forumns).

So what I am trying to do is get all my support data in a dataadapter, use it to build my drop down list and when that changes query the dataadapter for the key value.

But my dataadpter does not seem to be loading. At least the load complete is not being called.

I am hoping it is something obvious (to you) and that this is doable.

thanks,
nja

            // get the formulas
            var urlToGoToFG = '/BaseFormulas/getAllFormulas/';

            // prepare the data
            var sourceFG = {
                datatype: "json",
                datafields: [
                    { name: 'FormulaId', type: 'number' },
                    { name: 'Formula', type: 'string' },
                    { name: 'Description', type: 'string' },
                    { name: 'Name', type: 'string' },
                    { name: 'SortOrder', type: 'number' },
                    { name: 'Active', type: 'string' }
                ],
                id: 'FormulaId',
                url: urlToGoToFG
            };

            var listFG = [];
            var dataAdapterFG = new $.jqx.dataAdapter(sourceFG,    {
                loadComplete: function () {
                    var length = dataAdapterFG.records.length;
                    for (var i = 0; i > length; i++) {
                        listFG.push(records[i]['Name']);
                    }
                    alert(listFG);
                }
            }
           );

[Peter StoevKeymaster]

Hi nja,

If loadComplete does not fire, then your URL is invalid or you have a syntax or other error in your code. loadComplete is demonstrated on: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxdataadapter/jquery-data-adapter.htm.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[njaParticipant]

Thanks. URL is valid. No error notices in console. Will just have to chalk this up to solar flares.

thanks,
nja

[ysutParticipant]

Hi nja

Did you solve your question, since I am facing a similar case like you.
Please share.

Thanks in advance

[Peter StoevKeymaster]

Hi ysut,

loadComplete is called when data loading is completed. If it’s not called on your side, then this means that loadError is called i.e there is some problem with your data loading like wrong url, wrong data type set in your adapter’s configuration. The arguments of the loadError callback will tell you more about your issue.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[ysutParticipant]

Hi Peter

Thanks for the response. The problem is I don’t get any error in loadError. I am sure the URL is OK, since I tried manually, it’s work. It’s return in XML format. Here’s the code.

The scenario is I have a grid and want user can do inline editing. When he/she type the product code (column: kd_barang), then will retrieve the data via URL, and put the product name at the second column of grid (column: nm_barang).

Am I missed something? Thanks in advance.

$("#jqxgridPODetail").on('cellendedit', function (event) {
                var args = event.args;
                var columnDataField = args.datafield;
                var rowIndex = args.rowindex;
                var cellValue = args.value;
                var oldValue = args.oldvalue;

                if (columnDataField == "kd_barang") {
                    var source = {
                        datatype: "xml",
                        datafields: [
                            { name: 'kd_barang' },
                            { name: 'nm_barang' },
                            { name: 'hrg_jual' },
                            { name: 'hrg_beli' },
                            { name: 'flag_active' },
                            { name: 'flag_checkstock' }
                        ],
                        record: 'content',
                        url: 'ysoftws.asmx/GetBarangDetail?sKdBarang=' + cellValue
                    };

                    var dataAdapter = new $.jqx.dataAdapter(source, {
                         loadComplete: function () {
                             var records = dataAdapter.records;
                             var length = records.length;
                             var rows = $('#jqxgridPODetail').jqxGrid('getrows');
                             var rownumber = rows.length - 1;
                            
                             if (length = 0) {
                                 if (record.flag_active != "T") {
                                     alert("The code is Not Active. Try again!");
                                     $("#jqxgridPODetail").jqxGrid('setcellvalue', rownumber, "kd_barang", "");
                                     $("#jqxgridPODetail").jqxGrid('setcellvalue', rownumber, "nm_barang", "");
                                 }
                                 else {
                                     // put the product name and unit price
                                     $("#jqxgridPODetail").jqxGrid('setcellvalue', rownumber, "nm_barang", record.nm_barang);
                                     $("#jqxgridPODetail").jqxGrid('setcellvalue', rownumber, "qty", 1);
                                     $("#jqxgridPODetail").jqxGrid('setcellvalue', rownumber, "hrg_satuan", record.hrg_beli);
                                 }
                             }
                             else {
                                 alert("Product code not found !!!");
                                 $("#jqxgridPODetail").jqxGrid('setcellvalue', rownumber, "kd_barang", "");
                             }
                         },
                         loadError: function (jqXHR, status, error) {
                             alert(error);
                         },
                         beforeLoadComplete: function (records) {
                         }
                     });
                }

[Peter StoevKeymaster]

Hi ysut,

Yes, you miss the fact that your code just creates a dataAdapter which is not bound to anything. This means that if you want your adapter to perform data binding, then you should call its dataBind() method.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts