Messages

1

Help for ParamQuery Pro / Re: Select Cell to Copy Content when Selection Mode is 'Row'

« on: February 28, 2018, 10:12:21 am »

Thank you, turned out i'm using option native: true to turn on browser selection native,
I hope with no side effect.

2

Help for ParamQuery Pro / showTop expand display is broken when used in children grid

« on: February 28, 2018, 09:14:01 am »

Hello,

I'm trying to implement 'maximize' display function in children grid,
but it seems not working well/broken with displaying to screen (different resolution can also yield different result),
sometimes even show blank white screen depend on window size and screen resolution.

parent grid is working fine. Do you have any workaround this?
Thank you for your help. 

3

Help for ParamQuery Pro / Select Cell to Copy Content when Selection Mode is 'Row'

« on: February 19, 2018, 09:01:27 am »

Hello Paramvir,

I already implemented grid selection mode to 'row' to make it work with Edit/Add button functionality,
however I cannot select individual cell in order to copy its content somewhere else (copied the whole row instead),
do you have any workaround on this?

Thank you.

4

Help for ParamQuery Pro / Display all record in rPPOptions of pageModelType

« on: February 08, 2018, 01:16:29 pm »

Hello,

Is there any way to display results per page option others than [10, 20, 50, 100]?
I mean I need to have 'all' option in it to display the data regardless the number in pageModelType API.

Thank you.

5

Help for ParamQuery Pro / Exception invalid column name

« on: February 06, 2018, 08:53:16 am »

Hello,

When I try to filter a column, I got Exception invalid column name from this code :

Code: [Select]

           
            $dataIndx = $filter->dataIndx;           
            if (ColumnHelper::isValidColumn($dataIndx) == false)
            {
                throw new Exception("Invalid column name");
            }
            $text = $filter->value;
            $condition = $filter->condition;

my column name for dataIndx is using underscore (log_category), could this be the reason?
Error is shown only when filtering. Do you have any workaround? I'm already implementing the name throughout the code.

Thank you.

6

Help for ParamQuery Pro / Create and Destroy grid instance on Tabs

« on: February 02, 2018, 02:22:36 pm »

Hello Paramvir,

sorry if it sounds trivial, but how to create and destroy grid instance based on active tab?

Code: [Select]

 
<div class="tabs">
    <ul class="tab-links">
    <li class="active"><a href="#tab1">Tab 1</a></li>
    <li><a href="#tab2">Tab 2</a></li>
    </ul>

    <div class="tab-content">
    <div id="tab1" class="tab active">
      <div id="tab1_grid"></div>
    </div>
      <div id="tab2" class="tab">
      <div id="tab2_grid"></div>
      </div>
    </div>
  </div>

I don't want to assign new variable other than grid

Code: [Select]

var grid = pq.grid("#tab1_grid", Obj);
While tab2_grid is from different table.

Thank you.

7

Help for ParamQuery Pro / Re: Error: no such method 'instance' for pqGrid widget

« on: February 02, 2018, 02:07:19 pm »

it was 5.0.1, yes finally I made some adjustment with 1.8.3 / 1.11.4.

8

Help for ParamQuery Pro / Error: no such method 'instance' for pqGrid widget

« on: January 31, 2018, 11:07:32 am »

Hello,

Just updated to 5.10 version, but some functionality not working with jQuery version as exampled in https://paramquery.com/tutorial (version 1.83 with ui 1.9.2)

I got this error :
Uncaught Error: no such method 'instance' for pqGrid widget instance

but it is fine with 1.8.3 / 1.11.4 version , the problem is I need jQuery ui version 1.9.2 to make some functions work (like jQuery autocomplete), do you have any workaround or do you have minimum jQuery and ui version with 5.10 version?

Thanks

9

Help for ParamQuery Pro / Got pq_rowselect error when select row in next paging

« on: January 30, 2018, 01:23:16 pm »

Hello Paramvir,

My grid has

Code: [Select]

Uncaught TypeError: Cannot read property 'pq_rowselect' of undefined error when I try to select row on other than page 1, but it's normal when I expand the record (so the row is included in page 1).

Error invoked from this line in the code:
       

Code: [Select]

var arr = grid.SelectRow().getSelection();
What could be possibly causing it and how to fix?
Thank you for your help,

Best Regards

10

Help for ParamQuery Pro / Re: save blob data on column

« on: January 22, 2018, 05:50:32 pm »

Thank you, it works for POST,

but another thing, could you give example/idea of saving data/image to table with pqgrid?
I'm thinking about the column would store path information upon upload and can be clicked to be downloaded.

11

Help for ParamQuery Pro / Re: Custom Render all Columns in Table

« on: January 22, 2018, 08:49:45 am »

This is my function for columnTemplate :

Code: [Select]

    var renderTick = function (ui) {
        var dataRow = ui.rowData;
        // var indxRow = ui.rowIndx;
        console.log(ui);
        Object.keys(dataRow).forEach(function (key) {
            if (dataRow[key] == '1') {
                return dataRow[key] = '✓';
            } else if (dataRow[key] == '0') {
                return dataRow[key] = '✗';
            }
        });
    }
ui is called multiple times upon children tab expansion (it has several column),
not like what I thought it would be single ui call, not a problem at the moment and I don't know how to refactor it yet.

12

Help for ParamQuery Pro / Re: Custom Render all Columns in Table

« on: January 19, 2018, 02:10:08 pm »

Thank you,

it works great, although the function is called multiple times with column number.

13

Help for ParamQuery Pro / save blob data on column

« on: January 19, 2018, 02:07:55 pm »

Hello,

I need to save data in mysql blob format and overall column def already set with GET method,
I don't know if I could save data with GET, so I need to send it using POST.

Could you give me any idea on how to send a column using POST and the other is using GET?
Thank you

14

Help for ParamQuery Pro / Custom Render all Columns in Table

« on: January 19, 2018, 09:19:01 am »

Hello,

I have data only receiving 1 and 0, and I want to display it as ✓ and ✗ instead.

I can try with

Code: [Select]

var tickRender = function (ui) {
dataRow = ui.rowData.Circuit
  // validation function
}

colModel:  { title: "Circuit", width: 120, dataIndx: "Circuit", render: tickRender }
but if I have several columns it would be tedious to write every function per column,
could you help me know the proper way doing it?

Thanks

15

Help for ParamQuery Pro / Server error everytime gets pq_curpage=0

« on: January 13, 2018, 09:33:04 pm »

Hello Paramvir,

When I'm doing filter/sorting query to the request URL, unintentionally sometimes pq_curpage value becomes 0 and returning server error. But when I manually override the URL and change pq_curpage to 1, server behaves normally.

This happens when query result returns zero then click on "reset filter" button.

How can I prevent this? is this a bug?

Thanks