Using param query table to validation cell data without edit the cell.

[alonewolf149]

Hi,

Im working on import data using CSV file. and

With power feature of this table , so im decide to use this table to handle data and make validation before insert to DB.

So after import CSV i convert CSV data into JSON and generate Table with all data

but problem is when Cell can not validate the initial data

ex: http://prntscr.com/pweh5n

Above case if i not click on Cat AA (edit) table will not show validate error on cell.

So my question is

Can table validation all cell after Table created without edit the cell ?

Thank so much

[alonewolf149]

Is it possible to do ?

or if you not understand what i mean , pls let me know

Thanks

[paramvir]

I understand your requirements of validating initial data and that makes sense.

Currently isValid method is not working the way it's designed to, so moving it to bug log for further analysis and fix.

[paramvir]

Please use this to validate initial data in grid.

Code: [Select]

            load: function(){
                var grid = this, data = grid.option('dataModel').data;
                grid.widget().pqTooltip(); //attach a tooltip.
                grid.isValid({
                    data: data,
                    allowInvalid : true
                });               
            }


[alonewolf149]

Hi,
Sorry i just saw the ticket replied.

However, do i need to update version ? because after i applied, it did not work.
nothing showing validate

Can u suggest?
Thanks

[alonewolf149]

any update?

[paramvir]

Please check this jsfiddle.

https://jsfiddle.net/20x86ceb/

ProductName is kept empty in the first row in initial data and grid.isValid() method marks invalid cell with red triangle in its corner and shows a tooltip "Required" when cell is focused.

[alonewolf149]

Hi ,

we found issue, validation is work when data came from local

but in case remote it does not work

=====================

First, we have upload options where user uploading csv after we convert csv to json then load in pqgrid table

http://prntscr.com/qbun71

any solution ?

Thanks

[alonewolf149]

any solution ?

[paramvir]

The above solution is for remote data.

For local data you can call same grid.isValid method after grid is initialized.