Topics

1

Help for ParamQuery Grid (free version) / Paste Column in the Grid Add new Rows

« on: October 08, 2024, 07:05:29 pm »

Hello Paramvir

I am using paramquery with column paste functionality.

Suppose, the target grid contains 5 Rows only. Whenever I tried to paste more than 5 vertical cells, additional rows were inserted in the grid.
I don't want such behavior. I want the grid to only accept the first 5 cell values and not generate new rows

2

Help for ParamQuery Grid (free version) / Filter the Records on Server side with Server side pagination.

« on: August 19, 2024, 05:01:47 pm »

Hi Paramvir,

We are using PQ Grid (v9.0.1)  with Server Side Pagination and Server Side Filter Options.

Suppose, I Move to the Second page and try to filter the data, Internally I get the Current Page index i.e. 1

In this case, When the filtration is applied, the Page index should reset to 0.

3

Help for ParamQuery Grid (free version) / After Data Filtering, Pagination and Record Count do not change

« on: July 23, 2024, 11:59:17 am »

Hi Team,

we are using ParamQuery Pro v9.0.1, we are facing the following issue.

After Filtering data (toolbar local Search), the Pagination and Record count do not change.

we have kept filterModel.hideRows = true
if we keep filterModel.hideRows = false then it works properly.

please guide us.

4

Help for ParamQuery Select / Maintain the selection sequence in multi select dropdown

« on: June 21, 2024, 11:54:10 am »

Hi Paramveer,

We have a requirement to maintain the user selection sequence.

For example, if the dropdown has Sun, Mon, Tue, Wed, Thu, Fri, and Sat options and the user opts for the values on Wed, Sat, and Sun,

As per the dropdown behavior, whenever I fetch the values I receive values as Sun, Wed, Sat. The same happens while setting values back to the dropdown.

Is it possible to maintain the sequence?

5

Help for ParamQuery Select / Search functionality not working in mobile

« on: April 03, 2024, 01:16:52 pm »

I have used pqselect plugin in my project. I found that the search is not supported on mobile. When I try to search, every time I touch the search text box, the mobile keyboard appears, and the select box disappears as soon as the keyboard appears.

Kindly help me in this matter

6

Help for ParamQuery Pro / PqGrid FillHandle Makes Page Unresponsive

« on: January 18, 2024, 12:29:16 pm »

Dear Team,

We are using PqGrid Version 9.0.1,
we have enabled filehandle: all option. When we double click to apply data to all records then the page becomes unresponsive and takes a longer time to apply data for all records.


Note*
No. of records displayed in the grid is 21000,
we have enabled virtual rendering (virtualX: true, virtualY: true)
Find the attached screenshot for your reference.

Kindly suggest how to handle above scenario.

7

Help for ParamQuery Pro / How to use DateTime Picker in PqGrid Cell

« on: January 18, 2024, 12:02:59 pm »

Dear Team,

We are using PqGrid version 9.0.1
We are not able to find an appropriate example for the bootstrap DateTime Picker Column (Date and time).
Kindly Help.

8

Help for ParamQuery Pro / Columns overlaps in case of the Animation mode is on

« on: August 25, 2023, 07:23:06 pm »

Hi Paramveer,

I am using the pqGrid Pro (V 9.0.1).

Whenever I opt for the animation mode on, the columns of PQ grids overlap each other while horizontal scroll.

For your ref, I am attaching a screenshot.

Please guide us to resolve the issue.

9

Help for ParamQuery Pro / Multi Level Group By Result In a Single Row

« on: August 10, 2023, 05:39:18 pm »

Dear Team,

We want to achieve Multi-Level Groupby in a Single Row.

E.g. We have Created a Report using Five Columns
Grade, Branch, Department, Gender and Employee Code
We have kept Groupby for Grade, Branch, Department, Gender, and Count for Employee Code.

Please refer Attachment for the Expected result.
Kindly guide us to achieve the above result in Normal GroupBy and Pivot Group By.

10

Help for ParamQuery Pro / Not able to Achieve Pivot Count Report Using PQGrid

« on: August 04, 2023, 03:35:29 pm »

Dear Team,
Using PQGrid We want to implement a Pivot count report. but we are not able to achieve the desired result.
Kindly guide us. we have used the count function of PQGrid.

We have attached screenshots for your reference.
PQGrid Result
Excel Pivot Result (Same data used)
Excel Sheet

The expected result is as per Excel Sheet Pivot Feature.

11

Help for ParamQuery Pro / Lables are not available in the Pivot Panel

« on: July 12, 2023, 03:55:38 pm »

Hi Paramveer,

I am using ParamQuery (v8.7.0) in my project.

Whenever I bind the pqGrid with a Pivot option, the labels of the Pivot panel are not visible.
For your reference, I'm attaching the screenshot.

12

Help for ParamQuery Pro / Header and SubHeder Not Showing in Excel File After Export to Excel

« on: June 21, 2023, 06:04:14 pm »

Hi Team,
How to achieve Header And SubHeader in an export file (excel).

I have attached a screen shot for reference.

13

Help for ParamQuery Pro / Can we pivot text value instead of sum or count in pivot

« on: May 23, 2023, 07:41:17 pm »

Can we pivot text value instead of sum or count in pivot

Please find attach file expected result.png

Source data and expected result are mention in that.

14

Help for ParamQuery Pro / Row Wise and Column Wise total of Hour and Minutes

« on: April 24, 2023, 05:58:19 pm »

Hi Team,
How to achieve Row Wise and Column Wise Total of Hours and Minutes.
i.e if Minutes is greater than 59 then it should count as 1 hour and should be added in the hour part.

I have attached a ScreenShot for reference.

15

Help for ParamQuery Pro / How to Filter the rendered column?

« on: April 14, 2023, 03:26:35 pm »

Hi Paramvir,

I am showing the From and To Date with a - separator. To achieve this I apply a render function on that column.
After the render, the columns show data as per the expectation.

But, whenever I try to apply a local filter on that columns the filter does not work. The same is happen with the sort also.

Kindly check the attached file with the code and screenshots.