Messages

1

Help for ParamQuery Pro / Show fullscreen button but not hide button

« on: October 03, 2015, 01:40:30 am »

Is there a way to hide only one of the two upper-right buttons on the grids? I want the ability to fullscreen the grid, but don't really need to be able to minimize it. They seem to come as a pair in the CSS though.

2

Help for ParamQuery Pro / Re: Header not scrolling with data

« on: August 24, 2015, 10:38:39 pm »

It looks like my issue was CSS related in some way. I dropped the 3.1 CSS file down again and the problem seems to have gone away.

3

Help for ParamQuery Pro / Header not scrolling with data

« on: August 21, 2015, 08:20:19 pm »

Hi, I upgraded to the latest version of the paramquery grid.

When I use the horizontal scroll to move the grid, the headers do not move along with the data.
If I set VirtualX to true, they move fine, but that would disable swiping, wouldn't it?

4

Help for ParamQuery Pro / Checkbox column and summary row

« on: June 04, 2015, 12:38:08 am »

I specialize in strange combinations of things.

I have a grid with a checkbox column, but also a summary row like in your JSON Summary example. Is there a way to tell pqGrid not to show the checkbox in the summary row?

5

Help for ParamQuery Pro / Detail and Frozen columns

« on: June 02, 2015, 02:07:04 am »

Is there a way to freeze the +/- column but still have it line up correctly with the rest of the row while expanded?

I attempted to freeze this column, and as the image shows, the rows below it do not line up correctly when the detail is being shown.

6

Bug Report / Row grouping breaks with empty cell value

« on: May 15, 2015, 06:21:37 pm »

Hi,

I'm trying to do row grouping based on the values in a column. If the column is completely full, grouping works fine. If I try to group and one of the cells is a blank value, I get the following error:

Uncaught TypeError: Cannot read property 'push' of undefined    pqgrid.min.js:289

This is a column I would like to group on, but it may not necessarily have an entry in each cell. You can see the same behavior in http://www.paramquery.com/pro/demos/group_rows if you change the groupModel dataIndx to dataIndx: ["ShippingDate", "ContactName"],

Since the shipping date might be missing a value in some entries, it completely breaks if you try to group on it.

7

Help for ParamQuery Pro / Resize detail grids on maximize / fullscreen of parent

« on: May 14, 2015, 06:24:42 pm »

Hello,

I have a parent grid that has a detail grid on its rows. If I hit the maximize button to make the parent go fullscreen, the detail grid remains the same small size under the parent line. The detailModel's width is set to 'flex', but it doesn't seem to take up the extra space when available. Anything that can be done for this, or is there no way around it?

8

Help for ParamQuery Pro / Retreive data from a row's detail grid

« on: May 11, 2015, 08:33:25 pm »

Hello,

I'd like to know if there's a simple way to get the data from a nested detail grid pertaining to a parent grid's row. I'm trying to write my own function to export to an excel sheet, since the standard excel export seems to ignore the detail.

9

Help for ParamQuery Pro / Re: Show differnet pqGrid in same div

« on: May 06, 2015, 07:53:07 pm »

If your "destroy" code fires off before you ever actually create a grid, you will get that error.
I had a situation similar to this, and all I did was set a flag in the code to true that the grid was created. Then the function would check for that flag and only issue the destroy if it was already there. It's kind of a hacky fix, but it works.

10

Help for ParamQuery Pro / Re: Group Summary with Detail Grids?

« on: May 06, 2015, 07:49:57 pm »

Sorry, it was my mistake.

I was sending the parameters for the summary as strings {type: "sum"} instead of a single string inside of an array. {type: ["sum"]}

Works now, thanks.

11

Help for ParamQuery Pro / Group Summary with Detail Grids?

« on: May 05, 2015, 09:32:50 pm »

Is there anything that would prevent a group summary from working when there is also a detailModel defined?

I have the "summary" option set in the colModel for a column with dataType "float", and initially the grid displays with no grouping active. When a user clicks on a header cell, I change the groupModel to group by that dataIndx, but then the previously defined summary does not appear.

It seems that the summary can survive through the groupModel changing, as the "Row Grouping" demo has a button to turn it on and off, but I'm getting nothing.

I haven't tried removing the detailModel yet, but I'm wondering if that might be causing problems?

12

Help for ParamQuery Pro / Possibility of automatic totals?

« on: May 02, 2015, 12:42:32 am »

I know we can do a grid summary by using the demo provided, which appends a summary row to the bottom of the grid, and contains the calculations for the running total.

However, I'm working on a system where we would like to define the parameters of the grid based on data coming back from the host. That is, have one grid on the screen, but generate it differently based on user parameters. For that reason, it isn't quite feasible for me to hard code in the column numbers, or even the dataIndx in order to get that total, since the number of totaled columns, and even the names could change.

I see that there is a "colModel->summary" option in the API, but it seems to indicate that it is used for the purposes of the groupModel. Is there any way to simply mark a column as one that needs to be totaled, then get a total down at the bottom without going through the whole "calculateSummary" routine and updating on refresh?

13

Help for ParamQuery Pro / Change Class of Header Cell

« on: April 28, 2015, 07:48:38 pm »

I am looking for a way to apply the 'ui-state-active' style to a header cell based on some outside criteria.

Adding a class to the colModel seems to affect the table cells, and not the header cell. Any way to do this through PQ functions? Or will I have to use straight jQuery to try to find it?

14

Help for ParamQuery Pro / Re: Change Font Size on Maximize

« on: April 24, 2015, 07:24:00 pm »

That seems to work nicely, thanks!

15

Help for ParamQuery Pro / Change Font Size on Maximize

« on: April 22, 2015, 09:04:15 pm »

Is it possible to change the font size used on the grid when in full-screen mode?
We are looking to use the fullscreen view to make the current data more readable, not necessarily to put more rows on the screen.

I have tried putting jquery code in the toggle event to change the css of the pq-grid-cell, but it doesn't seem to work. Any ideas?