Messages

16

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.

17

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.

 

18

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

19

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

20

Help for ParamQuery Pro / Re: Inline edit with dropwdown values

« on: July 09, 2020, 08:35:06 am »

Please add this editor object in your column and it will work for you


editor: {
               type: "select",
               options:['Yes','No']
  }

Your updated snippet code-

{ title: "CSSP Accepted", editable:true, width: "8%", align: "center", dataIndx: "CSSPaccepted", dataType: "string",editor: { type: "select", options:['Yes','No'] }, filter: { crules: ruleR } },

21

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

« on: July 08, 2020, 03:00:48 pm »

Hello team,

We want to Change the grouping as per the values in drop-down.

We need same functionality in group title as its is working in CO# column.

Suppose if we are selecting CO#2 in place of CO#1 as shown in previous image then items in CO#2 Group title become two as showing in below image.
 
Please if possible update the below plunkr URl with solution.

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

22

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

23

Help for ParamQuery Pro / How can we add an row with Company Name, editable in Pivot grid?

« on: June 09, 2020, 04:26:34 pm »

Hello Team,

On right click of Cost Code in Group cell( highlighted/Image1) an popup,a dropdown of company is opening with companies not available in current cost code.

 After selecting a Company and clicking on Ok (Image2). The pop-up is closing and adding a row as required (Image3).

 But It is not adding the values of Company,Cost Code,Portfolio and other columns in new row and added row is not editable. That is a problem.

Kindly help me to add the editable row with company name and other numerical values as zero in selected group(right clicked).

The below code is running preferably in as local file on browser. Use the below Plukr and run it locally to reproduce error.

Problem URL:

https://stackblitz.com/edit/js-z6jpgx?file=index.html

24

Help for ParamQuery Pro / Re: How can we add single selectable checkbox in a grid in Pivot mode?

« on: June 08, 2020, 03:54:34 pm »

Hello Team.

Thanks a lot.

25

Help for ParamQuery Pro / Re: How can we add single selectable checkbox in a grid in Pivot mode?

« on: June 08, 2020, 12:58:57 pm »

Hello Team,

Thanks,

I have one problem, I applied the your suggested css code in a grid with bootstrap theme in below URL.

It is not working. Can you please check it?

Problem URL:
https://stackblitz.com/edit/js-9vbyfq?file=index.js

26

Help for ParamQuery Pro / Re: How can we add single selectable checkbox in a grid in Pivot mode?

« on: June 06, 2020, 11:32:12 am »

Hello Team,

Thanks for quick reply,

Yes I need the same. But when we checked a node, sets background-color to light red or purple of Company Name(chhild node). Checking another row causes previous row to be set unchecked(set default background).

27

Help for ParamQuery Pro / How can we add single selectable checkbox in a grid in Pivot mode?

« on: June 05, 2020, 04:18:16 pm »

Our requirement is to add an checkbox in front of last child of group tree as shown in image2 below.

Checkbox should be single selectable at time and on checked its cell background-color should get change in any other color.

Please give some example of it.

Problem url:

https://stackblitz.com/edit/js-y31u1u?file=index.html

28

Help for ParamQuery Pro / Re: Tree grid as filter for Grid

« on: March 12, 2020, 09:59:44 am »

Hi Support,

I have added the missing attachment.

Actualy, We need a filter like in below URL with similar feature, Is it possible to implement it with paramquery pqselect library ?

If yes Please share a snippet asap.


URL:https://jsfiddle.net/yasu47b/fakg72yk/

29

Help for ParamQuery Pro / Re: Tree grid as filter for Grid

« on: March 11, 2020, 10:52:44 pm »

Hi Support,

Requirement:
We have three column/dataindx in grid ex. Country, State, City in grouping and other.

we need to create a mutiselect filter in which data of Country, State and City as tree structure (or grouping) with collapsible feature (similar as below URL).

When we select a Country or State or City, we need to filter/exclude the data by the City column/dataIndx of grid for selected cities.

How can we create such multi-select tree filter similar(in data) to grid given in below URL using pq Select library of paramquery?

Please provide snippet for it.

tree grid URL: https://paramquery.com/pro/demos/treegrid5

30

Help for ParamQuery Pro / Re: How can we update the summary row on check and unchecked of rows or group row?

« on: February 27, 2020, 05:57:42 pm »

Hello Team,

Amazing,

Thank you for your quick response.

And check the below case and please update on same

Case URL: https://paramquery.com/forum/index.php?topic=3461.0