Messages

1

Help for ParamQuery Pro / Pager Refresh Icon

« on: January 20, 2018, 12:30:27 am »

Hello,

I am wanting to remove the separators and refresh icons from the pager. Is there an option to do this or an easy way that I can implement? I have included an image that highlights what I am wanting to remove.

Thanks!

2

Help for ParamQuery Pro / Re: Validation Message - Warning

« on: October 30, 2017, 07:07:22 pm »

We do not have a load function, is there another place we should put this?

3

Help for ParamQuery Pro / Validation Message - Warning

« on: October 27, 2017, 11:34:19 pm »

Hello,

I am working to add a custom validation rule for a column. When I have it set to warning: false; it will show the error message like it should. however, when I change it to a warning validation, i only get the blue icon in the top right corner and no message. In the documentation it states that the message will appear for warnings and non warnings.

Below is the code I am using.

   validations: [
                 
                        {
                            type: function(ui) {

                                var values = $('#invoice-detail-grid').pqGrid('option', 'dataModel.data');
                                for (var i = 0; i < values.length; i++) {
                                    if (( values[ui.column.dataIndx] ===ui.value) &&
                                        (values['AnotherColumn'] === ui.rowData.AnotherColumn) &&
                                        (values['Testing'] === ui.rowData.Testing) &&
                                        (values['ID'] !== ui.rowData.ID)) {

                                        ui.msg = 'Some Error Message';
                                        return false;

                                    }
                                }
                                return true;
                            },
                            warn: true

                        }
                    ]

Thanks!

4

Help for ParamQuery Pro / 4.0.1 upgrade from 3.3.5

« on: October 19, 2017, 08:43:07 pm »

Hello,

We are working on getting our application upgraded from 3.3.5 to 4.0.1.

We have ran into an issue that we are trying to resolve. When clicking on the row Numbers. We get the following error.

Uncaught TypeError: Cannot read property 'offsetHeight' of undefined
    at getCoord (http://X/Scripts/pqgrid.min.js:14:14187)
    at e.addBlock (http://X/Scripts/pqgrid.min.js:14:13069)
    at r.Selection.replace (http://X/Scripts/pqgrid.min.js:14:23789)
    at r.Selection.replace (http://X/Scripts/pqgrid.min.js:14:16804)
    at r.Selection.resizeOrReplace (http://X/Scripts/pqgrid.min.js:14:23659)
    at e.n._onCellMouseDown (http://X/Scripts/pqgrid.min.js:15:6294)
    at t.(anonymous function).(anonymous function).<anonymous> (http://X/Scripts/pqgrid.min.js:15:5243)
    at o (http://X/Scripts/pqgrid.min.js:9:1089)
    at t.(anonymous function).(anonymous function).i._trigger (http://X/Scripts/pqgrid.min.js:9:1542)
    at t.(anonymous function).(anonymous function).l._onMouseDownCell (http://X/Scripts/pqgrid.min.js:10:19737)

 What could the possible issues be? The grid overall is working, however we cannot select rows or paste data due to not being able to select rows.

5

Help for ParamQuery Pro / Re: Pagination column number in 2nd Page

« on: September 08, 2017, 09:32:48 pm »

your code doesn't show how are you adding new rows to the grid.

Please add this code, which I've written as per your description in this https://paramquery.com/pro/demos/paging and click on 'Edit and Run' button.

Code: [Select]

toolbar: {
items: [
{
type: 'button',
label: 'Add new rows',
listener: function(){
//debugger;
var offset = this.getRIOffset();
rowList = [1,2,3,4,5].map(function(i, indx){
return {newRow: {CustomerName: i}, rowIndx: indx+offset };
});
var newRPP = this.option('pageModel.rPP')*1 + rowList.length;
var newRPPOptions = this.option('pageModel.rPPOptions')
newRPPOptions.push(newRPP)
newRPPOptions.sort(function(a,b){
return a - b}
);
this.option('pageModel.rPP', newRPP);
this.option('pageModel.rPPOptions', newRPPOptions);
this.addRow(
{rowList:rowList}
)
}
}
]
}


support, I am trying to do the similar thing as the requester.

However, when I add the getRIOffset(), I get errors that it is not a function. is this something new?

6

Help for ParamQuery Pro / Re: Pasting Data From Excel

« on: September 06, 2017, 01:40:58 am »

Thank you! that solved this issue.

However, I have two other questions for you with pasting from Excel.

1. Is it possible to make all pasted rows go to the end of the grid rather than the current behavior?

2. I have two columns that are hidden which are at the end of the column model, if I pasted data from Excel sometimes these hidden columns get values set to them even though they should not. What is causing this?

Thanks!

7

Help for ParamQuery Pro / Pasting Data From Excel

« on: August 31, 2017, 06:01:12 pm »

We have a grid that we want to allow users to paste from an excel document. The pasting works great with one minor setback. if the user does not have a row selected and they paste, the pasted data will overlay the first X rows (X being how ever many rows they have copied). If they have a row selected and paste, it will overwrite the row they have selected and the rows below.

I would like to make it so the pasted data gets pasted into new rows, Is that possible?

Thanks!