Messages

1

Help for ParamQuery Select / how to save toolbar values

« on: January 31, 2022, 07:25:21 pm »

I have a toolbar with multi select dropdown and i want to save the values the user has selected and want to pre select them when the user revisits the page again. something like .pqGrid("saveState") and retrieve the  data back during load.

2

Help for ParamQuery Pro / Re: How to create a Dropdown check box

« on: December 23, 2021, 07:37:02 pm »

How to get the unselected check box values from select list check box

3

Help for ParamQuery Pro / Re: How to create a Dropdown check box

« on: December 14, 2021, 09:10:13 pm »

Thank you it helped and how do we select all the check box initially.

4

Help for ParamQuery Pro / How to create a Dropdown check box

« on: December 14, 2021, 04:09:56 pm »

How to create a Dropdown check box .Please share a demo on the same

5

Help for ParamQuery Pro / Cannot read property 'wdCenter' of undefined

« on: August 20, 2021, 05:46:56 pm »

Cannot read property 'wdCenter' of undefined

6

Help for ParamQuery Pro / Unable to copy header with cell data

« on: March 23, 2021, 03:15:03 pm »

Hi,

Using version 7.3
I'm unable to copy header along with the cell data from grid to excel.

Below is the code for copyModel:

Code: [Select]

copyModel: {
                    on: true,
                    render: true,
                    header: true,
                    zIndex: 1e4
                },
                selectionModel: { column: true },



Let me know if more insight is required.

Thank you.

7

Help for ParamQuery Pro / Force only one checkbox to be selected

« on: March 13, 2021, 06:59:56 pm »

Hi,

https://paramquery.com/pro/demos/checkbox_id

In this particular demo, how can we ensure that only one checkbox is selected at a given point of time?

What I want to achieve is that whenever I am selecting a particular row using the checkbox, checkbox from other row must get unchecked.

Let me know if more information is required.

Thank you.

8

Help for ParamQuery Pro / Unable to type in the textbox in filter

« on: March 09, 2021, 02:47:44 pm »

Hi,

I am unable to type in the textbox after opening the filter for each column.
Same is the issue while using 'range' or 'contains' or any filter option that has a texbox option.

Code: [Select]

filterModel: {
                    on: true,
                    header: true,
                    menuIcon: false,
                    type: 'local'
                }

Not sure what I'm missing here.

Let me know if more input is required from my end.

--
Thank you

9

Help for ParamQuery Pro / Date Filter On Toolbar

« on: February 19, 2021, 06:55:43 pm »

Hi,

I have a requirement where I need to have a date filter on the toolbar.

The date filter will open up like a calendar from where I will be able to select FromDate and ToDate locally.

Attached a screenshot to give a picture of the requirement.

Let me know if more input will be required from my end on this.

Thank you.

10

ParamQuery Pro Evaluation Support / Add Column to Grid without having any colModel

« on: January 13, 2021, 07:27:28 pm »

Hi,

How can I add the column with delete button at the end of the grid to delete a particular row from the grid?

I tried to follow the Columns API, but was not able to understand how it can be implemented.

Below is the jsfiddle link:
https://jsfiddle.net/ucknge23/1/

Appreciate your help.

--
Uttam

11

Help for ParamQuery Pro / Re: Pasted Data Not Reflecting in Empty Grid

« on: January 07, 2021, 01:11:43 pm »

Hi,

I want the grid to be like a workspace, i.e., I'll be pasting the data after copying it from excel and then saving those data in the database.
Once those values get saved, I want the grid to be empty or blank again.

Will recIndx work in this scenario where I don't want to fetch any data and display in the grid?
All I want it for pushing records into the database.

Thanks,
-Uttam

12

Help for ParamQuery Pro / Re: Pasted Data Not Reflecting in Empty Grid

« on: January 06, 2021, 10:11:10 pm »

Hi,

Please check the jsfiddle below, managed to get one 

https://jsfiddle.net/k8gfrwd1/1/

The pasted rows are now reflecting in the empty grid.
However, the isDirty flag is not changing to true and thus I'm unable to save the values in the database with the SaveChargeCodeManager method.

How can this be done?
Is there any other way through which I can save the pasted values from the empty grid to the database?

Thanks,
-Uttam

13

Help for ParamQuery Pro / Pasted Data Not Reflecting in Empty Grid

« on: January 06, 2021, 04:18:49 pm »

Hi Paramvir,

https://paramquery.com/pro/demos62/copy_paste

I'm following the above mentioned demo to  :

copy one or more rows from excel and then pasting it in a grid with 9 columns(colModel defined)
then I want to save those pasted rows using the addList.

However, the pasted rows are not getting reflected in the grid and is giving the below error message on console:

Code: [Select]

Uncaught TypeError: f.forEach is not a function
    at t.<computed>.<computed>.a._digestData (pqgrid.min.js:10)
    at i.cExcel.paste (pqgrid.min.js:14)
    at pqgrid.min.js:14

I'm getting the pasted rows information in the beforePaste event in an array.

Unable to generate a jsfiddle as all jsfiddle example is showing $ undefined error.

Thanks,
-Uttam

14

Suggest new features / Show tooltip for dropdown options in grid

« on: September 26, 2020, 02:04:20 am »

Hi,

How can I show tooltip on dropdown options in a grid?

Below is the URL for JSFIDDLE.

https://jsfiddle.net/d25mzr8k/2/

I want to show the state as tooltip upon opening the dropdown against the port.
For example: Upon opening the dropdown, show tooltip as WB for Kolkata, show tooltip as TN for Chennai and similarly for other dropdown options.

Thanks.

15

Help for ParamQuery Pro / Get ID for dropdown while dragging through rows

« on: August 27, 2020, 08:57:55 pm »

Hi,

I am unable to get ID's (ShipViaId) for dragged rows in the ShipVia column in the updateList. Below is the URL for the jsfiddle:
Also, please refer to the code section for the addList, updateList for the data that I'm getting after dragging the rows

https://jsfiddle.net/oa0nvky5/

However, I am getting the ShipViaId for the row from where the dragging has started and not the subsequent rows.
As I am not getting the ShipViaId for other rows, I am unable to save the ID's of the dropdowns.

In my implementation, I need to fetch the ID's for 5 columns with dropdown but I am unable to do so as the drag-to-copy feature is not working as per expectations.

Code: [Select]

{
  addList: [],
  deleteList: [],
  oldList: [{
  ShipVia: undefined,
  ShipViaId: undefined
}, {
  ShipVia: undefined
}, {
  ShipVia: undefined
}],
  updateList: [{
  CustomerName: "Vins et alcools Chevalier",
  Freight: 32.38,
  OrderDate: "07/04/1996",
  OrderID: 10248,
  ProductName: "Queso Cabrales",
  Quantity: 12,
  RequiredDate: "08/01/1996",
  rowID: 1,
  ShipAddress: "59 rue de l'Abbaye",
  ShipCity: "Reims",
  ShipCountry: "France",
  ShipName: "Vins et alcools Chevalier",
  ShippedDate: "07/16/1996",
  ShipPostalCode: "51100",
  ShipRegion: null,
  ShipVia: "Speedy Express",
  ShipViaId: "SE",
  UnitPrice: 14
}, {
  CustomerName: "Vins et alcools Chevalier",
  Freight: 32.38,
  OrderDate: "07/04/1996",
  OrderID: 10248,
  ProductName: "Singaporean Hokkien Fried Mee",
  Quantity: 10,
  RequiredDate: "08/01/1996",
  rowID: 2,
  ShipAddress: "59 rue de l'Abbaye",
  ShipCity: "Reims",
  ShipCountry: "France",
  ShipName: "Vins et alcools Chevalier",
  ShippedDate: "07/16/1996",
  ShipPostalCode: "51100",
  ShipRegion: null,
  ShipVia: "Speedy Express",
  UnitPrice: 9.8
}, {
  CustomerName: "Vins et alcools Chevalier",
  Freight: 32.38,
  OrderDate: "07/04/1996",
  OrderID: 10248,
  ProductName: "Mozzarella di Giovanni",
  Quantity: 5,
  RequiredDate: "08/01/1996",
  rowID: 3,
  ShipAddress: "59 rue de l'Abbaye",
  ShipCity: "Reims",
  ShipCountry: "France",
  ShipName: "Vins et alcools Chevalier",
  ShippedDate: "07/16/1996",
  ShipPostalCode: "51100",
  ShipRegion: null,
  ShipVia: "Speedy Express",
  UnitPrice: 34.8
}]
}


Let me know if any additional information is required from my end.

Regards,
Uttam