Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - youngvan

Pages: [1] 2
Suggest new features / using pivot mode with server side calculations
« on: December 17, 2019, 02:22:58 pm »

i like pivot a lot. The problem is:
- we working with a huge data (1TB+)
- totals like distinct/unique or some other complicated functions can be calculated only from raw data

is is possible that pivot doesn't calculate everything by himself but send query to server passing all selected params and then get and display all needed data from server (including totals)


Any updated on this issue ?

P.S. This problem is not produced on iOS devices, only android

Suggest new features / Advanced header filter search
« on: March 21, 2019, 02:48:26 pm »

Is it possible to customize header column filters to have a possibility dynamically remote load options based on entered symbols by user?

Some my 'select' filters may have about 60k-70k different options so it shouldn't be loaded on page as is. So the idea is to load only options based on entered symbols by user. For example users enters 'Xx' in filter search input(example in attached pic) then script makes ajax call on server side which responses with needed list of options.

Also the same question is about editing with autocomplete. Though I think I can do it using autocomplete functions, right?

Cheers  ;)

Bug Report / Grid stuck when using keyboard navigation
« on: June 01, 2018, 05:15:30 pm »

When using the keyboard to move between grid cells and came to the left edge (which contains row numbers), the page with grid stuck until you forcefully close it. This begins after migration to v5.1.0 from v3.3.2. 
With v3.3.2, if you click a left arrow on a keyboard when the left cell is selected, the selection just moves to the right cell of an upper row.

Help for ParamQuery Pro / Html in footer (summaryData)
« on: January 15, 2018, 07:14:20 pm »

After last updating I found out that method createTable is removed.
What should I use instead of this method?

I tried to use summaryData but it doesn't render html tags and display text  as is in table:

Thank you in advance!

Help for ParamQuery Pro / Grouping feature with custom subtotal
« on: June 27, 2016, 04:39:39 pm »
I have a table with already calculated subtotals, which are not simple min/max/sum/avg function, but very complicated formula and can be calculated only from raw data. You can see example in attachment.

I want to use grouping feature, but when rows collapsed, i need to show pre-calculated subtotals.

It would be perfect, if it's can hide all lines except subtotal line, like excel doing, when group collapsed.

Is it possible to do with your library? If not - can you add such ability in next version?

Help for ParamQuery Pro / Touch support and virtual scroll at the same time
« on: December 02, 2015, 08:10:24 pm »
I have a large amount of data in tables so I need to use "virtual scroll" modes and I want to add touch device(tablets and smartphones) support for my reports.
Is it possible to use touch mode with enabled virtualX and virtualY modes?

I'm using PQ v3.1

Help for ParamQuery Pro / Using old grid styles in version 3
« on: October 06, 2015, 08:21:55 pm »

I noticed the new version(3) of PQ has new styles(font, borders, colors, etc), but I'm a fan of old school styles from version 2. So is the any easy way to use old styles with version 3+ without reloading them in additional css file?

Thanks in advance.

Bug Report / Problem with browser zoom
« on: March 17, 2015, 09:58:32 pm »
Some of my clients prefer to work with tables in browsers with zoom mode, so if browser zoom level is increased to 110% or more the borders of the header of the table are not aligned with the borders between the columns of the data:

If I try setting virtualXheader:true -this problem disappears. It happens only with virtualXheader:false. I need to set this option false because of few-level header with grouped columns

Is it possible to fix this problem with disabled virtualXheader?
Thanks in advance.

Help for ParamQuery Pro / virtualXHeaderType and slow sorting
« on: March 03, 2015, 09:16:48 pm »

Here is my problem:
I have lot number of columns and few-level header in my table, so I need to set virtualX: true and virtualXHeaderType: false (to display rowspan and colspan correctly). Grid works fine but there's one problem with sorting- it works slow -up to 5 sec. If I set option virtualXHeaderType: true -it work very fast though header displays not properly  :(.
Is it possible to speed up sorting in grid with disabled virtualXHeaderType?

Thanks in advance!

Help for ParamQuery Pro / Loading page with big data
« on: February 24, 2015, 09:56:48 pm »

I've been testing your great plugin and found next issue with loading: if table consist of 5-7 thousands of rows and 100 columns -page loads to slow -about to 4 minutes in chrome. I tried others grids with the same data- some of them load up to 10 times faster;
Also I tested ParamQuery with different options. There was some problem with scroll as well- but I fixed it by setting virtualX: true and virtualY: true.
How can I force loading of page, maybe there some tricks or params?
Could you help me with this problem? Thanks in advance!

My init params:

var obj = {
    "wrap": false,
    "editable": false,
    "resizable": false,
    "draggable": false,
    "showTitle": false,
    "showHeader": true,
    "stripeRows": true,
    "virtualX": true,
    "collapsible": false,
    "showTitleType": false,
    "virtualXHeader": false,
    "filterModel": {
        "on": true,
        "mode": "AND",
        "header": true
    "scrollModel": {
        "pace": "fast"
    "selectionModel": {
        "type": "row",
        "mode": "block"
    "freezeCols": 4

Bug Report / virtualXHeader and Filters at the same time
« on: December 01, 2014, 08:04:07 pm »
I tried to enable filters in header columns -it works fine, but when I set virtualXHeader option to false -I can see filters only in visible columns on the screen and if I make a horizontal scroll -there're no filters in header.

Is it possible to work with filters when parameter virtualXHeader is false?

Help for ParamQuery Pro / Broken grouped columns in header
« on: July 03, 2014, 01:42:29 am »
Here a description of my problem:
I usually use virtualX mode, because tables have more then 20 columns and fast sorting is necessary.
Also tables header consist of 3-5 rows grouped by columns. When I try to scroll table to the right side it looks like grouped columns aren't placed in proper positions.

I'll try to show it on this example:
If you enable virtualX mode and try to make cells in header a little bit wider you will see it -just try to scroll table horizontally .
For more proper understanding of the problem I attached a long pic(image 1) where you can see how header changes during the horizontal scrolling.

Next problem based on first one - it's wrong sorting. See second attached pic. On this pic virtualX is enabled and table width set to 720px;

This problem  doesn't exist if virtualX is disabled.
I can't disable virtualX or virtualY modes -I work with a lot of data. How I can fix that issue?
Thanks in advance!

Image 1:
Image 2:

Help for ParamQuery Pro / Extra empty space in table with few columns
« on: July 02, 2014, 05:52:49 pm »

I have script which creates dynamical tables with 2 and up to 100 columns.
If table has only few columns after the last column it appears extra empty space. Is it possible to remove it or set autowidth for table?
I've tried to set flexWidth option, but it doesn't suitable in my case, because I need fixed width for columns.

Help for ParamQuery Pro / Integer sorting with spaces
« on: June 23, 2014, 05:40:32 pm »
What is the best way to fix column sorting problem in situation when value can be consist of formatted Integer sum with whitespaces,
for example: '1 205,200' ?


Pages: [1] 2