1
Help for ParamQuery Pro / Re: Lazy Loading - POST Method
« on: November 07, 2022, 07:17:51 am »
Than you.
ParamQuery Grid
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.
2
Help for ParamQuery Pro / Lazy Loading - POST Method
« on: November 07, 2022, 05:14:14 am »
Hi,
In the new "lazy" option for dataModel.location, it seems to be only using GET as the request method. In my remote datasource, I need to use POST because of the amount of data I'm passing to the remote function.
Can the "lazy" location option be updated to use the method defined in dataModel, e.g. POST?
In the new "lazy" option for dataModel.location, it seems to be only using GET as the request method. In my remote datasource, I need to use POST because of the amount of data I'm passing to the remote function.
Can the "lazy" location option be updated to use the method defined in dataModel, e.g. POST?
3
Help for ParamQuery Pro / Re: Render Function - not executing when defined as a string
« on: August 15, 2022, 06:06:29 pm »
Thank you so much. Works great.
4
Help for ParamQuery Pro / Render Function - not executing when defined as a string
« on: August 12, 2022, 07:22:28 pm »
Hello,
Since very 8.4, render functions defined as a string (to point to an external function) are no longer working.
You can see in this fiddle showing 8.3. A simple function is defined "renderCell" and specified in the render attribute of the first column in colModel - Rank.
https://jsfiddle.net/webauthor/c30seLq8/6/
When switching the library to 8.5, we're getting the error below:
https://jsfiddle.net/webauthor/65myvwop/
ERROR:
"jQuery.Deferred exception: t.call is not a function", "TypeError: t.call is not a function
at t.callFn (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:121172)
at pq.cRenderSum.renderCell (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:93605)
at pq.cRenderSum.generateCell (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:369570)
at pq.cRenderSum.renderRow (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:378141)
at pq.cRenderSum.renderView (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:378408)
at pq.cRenderSum.refresh (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:375809)
at pq.cRenderSum.refreshAllCells (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:376507)
at pq.cRenderSum.initPost (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:390322)
at pq.cRenderBody.init (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:383204)
at v.paramquery.cRefresh.refresh (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:113125)", undefined
Since very 8.4, render functions defined as a string (to point to an external function) are no longer working.
You can see in this fiddle showing 8.3. A simple function is defined "renderCell" and specified in the render attribute of the first column in colModel - Rank.
https://jsfiddle.net/webauthor/c30seLq8/6/
When switching the library to 8.5, we're getting the error below:
https://jsfiddle.net/webauthor/65myvwop/
ERROR:
"jQuery.Deferred exception: t.call is not a function", "TypeError: t.call is not a function
at t.callFn (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:121172)
at pq.cRenderSum.renderCell (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:93605)
at pq.cRenderSum.generateCell (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:369570)
at pq.cRenderSum.renderRow (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:378141)
at pq.cRenderSum.renderView (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:378408)
at pq.cRenderSum.refresh (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:375809)
at pq.cRenderSum.refreshAllCells (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:376507)
at pq.cRenderSum.initPost (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:390322)
at pq.cRenderBody.init (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:383204)
at v.paramquery.cRefresh.refresh (https://support.webauthor.com/lib/pqgrid/8.5/pqgrid.min.js?ver=20210813-A:9:113125)", undefined
5
Help for ParamQuery Pro / Re: exportData - Excel - rendering HTML text
« on: March 09, 2022, 05:50:46 pm »
Thank you very much. This worked perfectly.
6
Help for ParamQuery Pro / exportData - Excel - rendering HTML text
« on: March 09, 2022, 03:46:20 am »
Hi, I have an issue where a column with HTML renders just fine in the grid, but when exporting to excel, even with render:true, it only shows the HTML tags. I took one of your demo examples and created a fiddle to show the behavior:
https://jsfiddle.net/webauthor/c30seLq8/3/
In the dataModel for company, I have one entry with a <ul> list. It renders correctly in the grid, but not when exported via Excel. I've tried playing with various options like render:true/false, exportRender:true/false on the column, but none worked.
Can you please help me export this while retaining the HTML - or if this is not possible, is there a way to strip the HTML tags before export?
Thank you
https://jsfiddle.net/webauthor/c30seLq8/3/
In the dataModel for company, I have one entry with a <ul> list. It renders correctly in the grid, but not when exported via Excel. I've tried playing with various options like render:true/false, exportRender:true/false on the column, but none worked.
Can you please help me export this while retaining the HTML - or if this is not possible, is there a way to strip the HTML tags before export?
Thank you
7
Help for ParamQuery Pro / Re: Virtual Scrolling - Grouping
« on: November 19, 2021, 07:48:23 pm »
Thank you
8
Help for ParamQuery Pro / Virtual Scrolling - Grouping
« on: November 18, 2021, 07:48:32 pm »
One item that came up in testing is grouping. I know grouping is going to be problematic because it's only happening client side, but do you have any thoughts on how I can alleviate the problem where we end up with blank entries? Should groupModel exclude rows where pq_empty is true?
9
Help for ParamQuery Pro / Re: Virtual Scrolling - Throttling
« on: November 18, 2021, 07:05:15 pm »
Thank you so much 
This change is working perfectly so far. I will let you know if we run into any issues. I greatly appreciate the guidance and help here.
This change is working perfectly so far. I will let you know if we run into any issues. I greatly appreciate the guidance and help here.
10
Help for ParamQuery Pro / Virtual Scrolling - Throttling
« on: November 18, 2021, 01:00:52 am »
Hi, I'm not sure how to phrase this question well, so please bear with me.
I've been using a remote setup for my data along with paging and it works well, but I'd like to get users away from paging and using virtual/infinite scrolling instead. I have the examples in place and it works, but what I'm finding is that when users move the scrollbar up and down really fast, it kicks off multiple remote requests. I see in Chrome's console when those requests are cancelled, but they still hit our server and tie up resources.
I started looking to see if I could use the beforeSend event to throttle requests so that we're not making more than xx requests in a given time period.
Is that something you can help me figure out - so that when users are rapidly scrolling up or down, we're making 1 request at a time to the server?
Thank you
I've been using a remote setup for my data along with paging and it works well, but I'd like to get users away from paging and using virtual/infinite scrolling instead. I have the examples in place and it works, but what I'm finding is that when users move the scrollbar up and down really fast, it kicks off multiple remote requests. I see in Chrome's console when those requests are cancelled, but they still hit our server and tie up resources.
I started looking to see if I could use the beforeSend event to throttle requests so that we're not making more than xx requests in a given time period.
Is that something you can help me figure out - so that when users are rapidly scrolling up or down, we're making 1 request at a time to the server?
Thank you
11
Bug Report / Re: Issue grouping by column when you have customer rendered the cell
« on: February 02, 2021, 11:31:00 pm »
Hi, I know this is an old post, but I had a similar issue and did this to resolve it. Posting it here to see if it was okay to do or if a new feature might come to allow grouping of rendered cells. What I did below is working as of the current version today.
Code: [Select]
function xmGridLookup(ui) {
if (xmGridLUV.hasOwnProperty(ui.dataIndx) && xmGridLUV[ui.dataIndx].hasOwnProperty(ui.cellData)) {
var prefix = "";
if ( ui.rowData.pq_gtitle || ui.rowData.pq_gsummary ){
prefix = '<span class="pq-group-icon glyphicon glyphicon-triangle-right"></span> ';
}
return prefix + xmGridLUV[ui.dataIndx][ui.cellData];
}
}
12
Help for ParamQuery Pro / Re: How can I prevent cell overflow input box?
« on: November 05, 2020, 01:26:39 am »
Figured out the issue - was a conflict on my end.
13
Help for ParamQuery Pro / Re: How can I prevent cell overflow input box?
« on: November 04, 2020, 11:19:28 pm »
Hi, I'm having an issue related to this. Please see attached image.
14
Suggest new features / Re: Format Item Count in Grid
« on: August 17, 2020, 09:40:56 am »
That’s great. Thank you!
15
Suggest new features / Format Item Count in Grid
« on: August 14, 2020, 11:41:31 pm »
Hi, is there a way we can format the number for total items so that it has commas in it?
e.g. In the attached, it shows:
369733 items, but I'd like to see it as 369,733 items.
Is this possible via a configuration?
e.g. In the attached, it shows:
369733 items, but I'd like to see it as 369,733 items.
Is this possible via a configuration?