Messages

16

Help for ParamQuery Pro / Column header filtering behavior

« on: June 15, 2016, 03:02:07 am »

Hi, at http://, if you click "Variant" tab on the top left corner, and scroll the table to the bottom, and then type "r" in the column header filtration box under the column "HUGO symbol", then the table is filtered correctly, but I'd like to move the focus on the table to the top row of it. How can I do this?

I tried colModel's listeners, but it didn't seem to have any effect. For example, I tried the following.

var cm = grid.pqGrid('option', 'colModel');
cm[9].filter = {type: 'textbox', condition: 'contain', listeners:[ {'keyup': function(evt, ui) {alert('here');} ]};
grid.pqGrid('option', 'colModel', cm);

Then, typing a letter in the HUGO symbol column header filter box does not open the alert dialog.



Edit: url removed.

17

ParamQuery Pro Evaluation Support / Re: "Maximum call stak size exceeded" error with filtering

« on: September 08, 2015, 08:28:55 pm »

I'm using local filtering. With more testing, I found that the error happens when the part of the table I am seeing is, for example, line 10000, and after filtering if the total number of rows of the table becomes, for example, 1000. So, when the row number that I am seeing becomes greater than the total number of rows or something like that caused the error, in all of my testing. If I can make a testing page, I'll share it here.

18

ParamQuery Pro Evaluation Support / "Maximum call stak size exceeded" error with filtering

« on: September 02, 2015, 03:08:44 am »

Hi, I have been testing ParamQuery Pro version 3 with a data which has 250,000 rows. It seems to load the data over the net, but when filters were applied, the Chrome browser gave the following error:

>Uncaught RangeError: Maximum call stack size exceeded
    l.filterLocalData @pqgrid.min.js:421
    m._onDataAvailable @pqgrid.min.js:310
    (anonymous function) @jquery-ui.min.js:6
    m.filter: @pqgrid.min.js:307
    (anonymous function) @jquery-ui.min.js:6
    (anonymous function) @jquery-ui.min.js:6
    v.extend.each @jquery.min.js:2
    v.fn.v.each @jquery.min.js:2
    e.widget.bridge.e.fn (anonymous function) @jquery-ui.min.js:6
    updateFilter @my_page.js:179
    (anonymous function) @my_page:1803

I would appreciate any advice on how to solve this problem.

19

ParamQuery Pro Evaluation Support / Re: How to do single-column sort?

« on: August 18, 2015, 08:39:58 pm »

Thanks. That solved the problem. For posterity, I used something like the code below.

gridObj.headerCellClick = function (evt, ui) {
   var sortModel = $grid.pqGrid('option', 'sortModel');
   if (evt.shiftKey) {
      sortModel.single = false;
   } else {
      sortModel.single = true;
   }
   $grid.pqGrid('option', 'sortModel', sortModel);
};

20

ParamQuery Pro Evaluation Support / How to do single-column sort?

« on: August 15, 2015, 01:29:39 am »

Hi, as I switched from ParamQuery Pro 2.4 to ParamQuery Pro 3, the default sorting mode seems to have changed from single-column (with multiple column sorting possible by shift-click) to multiple-column sorting. Is there a way to implement the behavior of clicking a header -> single column sorting and shift-clicking a header -> multiple column sorting?

21

ParamQuery Pro Evaluation Support / Re: How to get the unfiltered data (Pro 3)?

« on: August 14, 2015, 03:09:07 am »

Actually, dataUF was not what I was looking for. If my whole data has four rows 1, 2, 3, and 4, and after filtration only 2 and 3 are left, dataUF has 1 and 4. However, what I am looking for is an object that contains all of 1, 2, 3, and 4, in their original order. Is it possible to retrieve this object from a grid?

22

ParamQuery Pro Evaluation Support / Re: How to get the unfiltered data (Pro 3)?

« on: August 14, 2015, 02:51:02 am »

Nevermind. I found that dataModel.dataUF has unfiltered data.

23

ParamQuery Pro Evaluation Support / How to get the unfiltered data (Pro 3)?

« on: August 14, 2015, 02:47:07 am »

Hi, when I used ParamQuery 2.4 Pro, I could get unfiltered data with pqGrid('option', 'dataModel').data. However, with ParamQuery Pro 3, I get filtered data with the same command. How can I access the unfiltered data when the table shows filtered data?

24

ParamQuery Pro Evaluation Support / Re: Sorting with blank cells

« on: August 14, 2015, 02:43:25 am »

Thanks. I could solve the problem with using ParamQuery Pro 3's sortModel.sorter and custom sorting (sortType).

25

ParamQuery Pro Evaluation Support / Re: Sorting with blank cells

« on: August 13, 2015, 01:25:10 am »

Thanks. I tried custom sorting, and I could push null cells to the bottom at ascending sorting. However, when I click the column header again for descending sorting, the null cells came to the top, followed by the highest value cells. I guess that descending sorting just reverses the result of ascending sorting - is there a way to custom sorting for both ascending and descending sorting? I am afraid that the option 2) you suggested might take too much time.

26

ParamQuery Pro Evaluation Support / Sorting with blank cells

« on: August 12, 2015, 07:06:35 pm »

Hi, in my ParamQuery table, one column has numbers and blanks. When I sort this column, blank cells appear at the top, and then number cells sorted accordingly. Is there a way to make the number cells to show at the top and the blank cells at the bottom after sorting (both ascending and descending)?