ParamQuery grid support forum

General Category => Bug Report => Topic started by: alonewolf149 on November 13, 2019, 06:56:31 pm

Title: Using param query table to validation cell data without edit the cell.
Post by: alonewolf149 on November 13, 2019, 06:56:31 pm

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

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: alonewolf149 on November 14, 2019, 09:18:39 am

Is it possible to do ?

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

Thanks

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: paramvir on November 14, 2019, 02:49:01 pm

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.

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: paramvir on December 04, 2019, 11:37:01 am

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
                });               
            }


Title: Re: Using param query table to validation cell data without edit the cell.
Post by: alonewolf149 on December 09, 2019, 07:22:52 pm

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

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: alonewolf149 on December 12, 2019, 05:11:38 pm

any update?

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: paramvir on December 12, 2019, 10:41:04 pm

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.

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: alonewolf149 on December 17, 2019, 10:47:57 am

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

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: alonewolf149 on December 18, 2019, 05:35:53 pm

any solution ?

Title: Re: Using param query table to validation cell data without edit the cell.
Post by: paramvir on December 18, 2019, 08:38:25 pm

The above solution is for remote data.

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