Topics

1

Suggest new features / Show Summary rows on top

« on: July 22, 2021, 03:10:46 pm »

Hello Team,

Our requirement is to show summary of rows on the top instead of showing in at the bottom of the grid.

Showing in bottom working fine but we require to show on the top.

Please check attached screenshot for understanding.

2

Bug Report / Rows skew in grid

« on: July 21, 2021, 02:49:14 pm »

Hello Team,

In Param query grid after using some operations rows are skew and not showing correctly.

Please check attached screenshot for better understanding.

3

Help for ParamQuery Grid (free version) / How to show dropdown list response fully within screen window not to overlap

« on: June 28, 2021, 12:22:50 pm »

Hi Team

Thanks,

While open dropdown list then its values are overlap to Screen window so we needs to shows dropdown values within screen window in Grid.

Please provide examples and code snippet.

Please find the attached screenshot:-

4

ParamQuery Pro Evaluation Support / How can we show values of an calculated Column in Pivot Mode?

« on: April 16, 2021, 05:07:23 pm »

Hello Team,

We have % Spent column (calculated as % Spent = Cost (H) / Budget (F) in rendering function) in paramquery grid.

% Spent is dependent on Budget & Cost Column.

Now when we are trying to see it in the Pivot mode then it is showing 0 in each cell of % Spent column instead of calculating its value its value.

 Can You please help me to give a solution for it?

5

ParamQuery Pro Evaluation Support / How can we calculate a grand summary row as custom calculated in Pivot mode?

« on: April 16, 2021, 03:38:32 pm »

Hello Team,

We a have paramquery grid with some numerical records with Budget Class (column) = "Budget" and some with Budget Class = "Portfolio" .
We are calculating the summary row as Total Budget remaining = Sum of Portfolio records - Sum of Budget records in Normal Mode of Grid.

Now when we are tying to calculate Total Budget remaining in Pivot mode of Grid then it is not calculating and showing blank in grand summary row.

Can we able to custom calculate it in Pivot mode too ? Please help us to resolve the issue.

6

Help for ParamQuery Pro / How to set font color and background color while adding new row into grid

« on: January 04, 2021, 09:29:42 am »

Hello Team,

Thanks,

I need to be change font color as red and background color as yellow while adding new row in grid.

Please suggest to me or provide snippet of code.

Please find the below screenshot:-

7

Help for ParamQuery Pro / How to stop drag and drop row in one group to anther group rows

« on: December 29, 2020, 01:02:49 pm »

Hello Team,

Thanks,

As we require how to stop drag and drop group rows one group to another group rows.

We need only same group we can drag and drop rows.

Please provide some example code or snippet of code.

Please find the below attached screenshots-

8

Help for ParamQuery Pro / How can we sort the projects of in row grouping by priority in grid?

« on: December 17, 2020, 04:15:06 pm »

Hello Team,

We want to sort Projects by their Priority in descending order in row grouping, dynamically.

We need to sort it in on page load and on some different instances (dynamically).

One Case it is working but another one case it is working (sorting record as required).

Please check below plunkr and give a solution (sorting Projects by their Priority in descending order in row grouping keeping portfolio-record on top).

Note: >records of .constructive (.Budget/portfolio) should always need in top (sometimes - sorting record as Priority descending, it is coming down.)

Plunkr/problem URL:
https://plnkr.co/edit/it59gv4jqobQayVh?preview

9

Help for ParamQuery Pro / How can we calculate the value in Calculated column in each summary row?

« on: December 16, 2020, 05:16:44 pm »

Hello Team,

We want calculate and show result of division by below formula in new column "Calculated" in paramquery grid.
Formula-
Calculated = Original Budget/Projected Budget

We added a code snipped in below URL- Please check it and update it with a solution.

Plunkr/problem url:
https://plnkr.co/edit/kliEiaTSSrSAk55a

10

Help for ParamQuery Pro / Render CSS According to Child Items

« on: October 27, 2020, 03:11:24 pm »

Hello Team,

We have 3 level grouping and if Level 2 group summary have negative values than we require to show Level 1 font in Red color.

For Example we added a image for reference.

In image Sunil is in level 2 and having negative values and in this case Level 1 font summary require to show in negative according to respective columns.

11

Help for ParamQuery Pro / How can we import data of Excel to grid with existing(or as new) record?

« on: September 30, 2020, 09:55:30 pm »

Hi Team,

Can you please provide an example that how can we import data of Excel to grid without changing its column title (because normal import column is changing A, B, C like Excel)?

I want to import/add the data of below excel under the data of grid (do not replace the old data ) shown in below images.

12

Help for ParamQuery Pro / How to environment set up for param-query-grid using react js with share point

« on: September 10, 2020, 08:25:03 pm »

Hi Team,

As required, I asking one valid question related to environment set up of param query grid using reactjs .

I already set up environment of param query using reactjs with local server then it is working fine. As required similarly how can set up

environment of param query grid using reactjs with share point web part to show param query app in share point page.

 

13

Help for ParamQuery Pro / Sort Inside Group

« on: September 07, 2020, 04:29:22 pm »

Hello Team,

Please check attached image and give me solution to sort grouping.

Let me know if you need more information.

Result should be: aaa,AA,Cooper

14

Help for ParamQuery Pro / How Can we make a grid fully responsive for different devices?

« on: August 04, 2020, 03:32:26 pm »

Hello Team,

Can you please help us that how can we make a grid fully responsive?

Below we are giving a URL of an example grid-

Problem URL:
https://stackblitz.com/edit/js-86kvgp?file=index.html

15

Help for ParamQuery Pro / How can we add a drop down in Group Summary cell with value of grouped column?

« on: July 07, 2020, 04:57:06 pm »

Hello Team,

We want to add a drop down (choice) in cell of group column as we are adding in a cell of normal param query grid.

Our requirement is to add a drop down as CO# column in the cell of group column as shown in image.

Can you please help us to add it?

We created an problem plunkr here.

Problem plnkr URL:
https://stackblitz.com/edit/js-vhnf4a?file=index.html