Messages

1

Suggest new features / Re: select2

« on: October 08, 2024, 07:38:13 pm »

Dear Support,

Please give the sample code for select2.

Thanks

2

ParamQuery Pro Evaluation Support / Re: Footer or status bar option in pq grid

« on: September 13, 2023, 09:16:18 pm »

We required the same functionality in our project.

Please advise if this option is available now.

3

Help for ParamQuery Pro / Update Grid Summary and Grouping Summary via Server

« on: September 11, 2023, 09:47:03 pm »

We have grid of about 300-500 Rows that we are updating every 1 second. In this grid we are displaying a grid summary and grouping summary to show the sum of certain columns.
We are able to update only rows that are visible to the user which about 10-15 rows at max - this works smoothly.

The challenge we are facing is that to show grid summary and grouping summary we have to update all the rows of the grid. We believe updating so many rows can be avoided if we update grid summary and grouping summary via the server directly.

Please guide if such a feature is possible.

Please refer the attached screenshot for more information.

4

Help for ParamQuery Pro / Re: Check box click event issue

« on: June 15, 2023, 08:01:03 pm »

Thank you for your quick response.

If we add "dataIndx" as per the code below then the checkbox is replaced with "true/false" text. I need a checkbox & the user can be checked/unchecked.

Also, please advise how to trigger the event & save the checkbox value in the database when the user checked/unchecked the checkbox.

Code: [Select]

{
title: "Edit?",     
dataIndx: "IsOnOff",
width: 50,
dataType: "bool",
align: "center",
editor: false,
type: 'checkbox',
editable: true,
cls: "largerCheckbox16NoToggle"
}


5

Help for ParamQuery Pro / Check box click event issue

« on: June 14, 2023, 08:31:34 pm »

We have added a checkbox to the grid with the below code in colModel.

When we click on the checkbox in row #1 then checked and if we click again then it does not uncheck.

If we click on row #2 & then click on row #1 then unchecked.

Please advise how to fix this so if click again and again on the same checkbox then checked/unchecked.

Code: [Select]

{
title: "Edit?",     
width: 50,
dataType: "bool",
align: "center",
editor: true,
type: 'checkbox',
editable: true,
cls: "largerCheckbox16NoToggle"
}


6

Help for ParamQuery Pro / Re: Duplication data after applying/clearing filter

« on: March 29, 2023, 07:47:31 pm »

Thank you, as per the ticket below we have fixed our issue.
https://paramquery.com/forum/index.php?topic=4589.0

7

Help for ParamQuery Pro / Re: Filter dialog "Clear" & "Ok" button click event issue

« on: March 29, 2023, 07:39:20 pm »

Thank you. This event helps us to complete our required changes.

8

Help for ParamQuery Pro / Re: Filter dialog "Clear" & "Ok" button click event issue

« on: March 29, 2023, 12:07:01 pm »

Thank you, the event is working.

We have multiple dynamic Grid on the same screen using Goldenlayout.

I need the Paramquery Grid ID from where the filter popup opens when the user clicks the "Ok" or "Clear" button. Please advise.

9

Help for ParamQuery Pro / Re: ColModel column width issue

« on: March 29, 2023, 11:48:21 am »

I have applied "maxWidth" to the column and its working.

10

Help for ParamQuery Pro / ColModel column width issue

« on: March 28, 2023, 08:27:32 pm »

I need to set specific column ("Divider1") width to 6px. I have added below code but it is talking 13px. Please advise.

Code: [Select]

var colM =
[
{
title: "Token#",
dataIndx: "stInstrumentToken",
hidden: true,
align: "left",
tpCls: "header-css",
styleHead: {
            "font-weight": "bold",
            "color": "#fff",
            "font-family": "Tahoma",
            "background-color": "#666666",
            "font-size": "10px"
        },
},
{
title: "Series",
dataIndx: "Series",
hidden: true,
align: "left",
tpCls: "header-css",
styleHead: {
            "font-weight": "bold",
            "color": "#fff",
            "font-family": "Tahoma",
            "background-color": "#666666",
            "font-size": "10px"
        },
},
    {
title: "",
width: 6,
minWidth: 5,
dataIndx: "Divider1",
editable: false,
sortable: false,                           
cls: "pq-divider"                           
},
{
title: "LotSize",
dataIndx: "inLotSize",
hidden: true,
align: "left",
tpCls: "header-css",
styleHead: {
            "font-weight": "bold",
            "color": "#fff",
            "font-family": "Tahoma",
            "background-color": "#666666",
            "font-size": "10px"
        },
},
];


11

Help for ParamQuery Pro / Filter dialog "Clear" & "Ok" button click event issue

« on: March 28, 2023, 03:03:38 pm »

I am trying to add the javascript code below to track "Clear" & "Ok" button click event. The click event is working for "Clear" button but not for "Ok" button. Please advise.

Code: [Select]

$('body').on('click', '#tabs-filter button', function() {     
      console.log('Button clicked!');
});


12

Help for ParamQuery Pro / Re: Duplication data after applying/clearing filter

« on: March 27, 2023, 02:43:05 pm »

Our grid is updating data every second. If we use the filter event code below then the grid refreshes every second after applying a filter. Please refer to the screenshot below & advise.

Code: [Select]

filter: function (event, ui)
{                   
      this.refreshDataAndView();
}


13

Help for ParamQuery Pro / Re: Duplication data after applying/clearing filter

« on: March 24, 2023, 08:52:28 pm »

Thank you for your quick response. It is tough to setup this up in jsfiddle.

Do you have any suggestions as per the code and screenshots shared with you?

One more question, I need to call my method after the user filter on the grid or clear filter.  Please advise.

14

Help for ParamQuery Pro / Duplication data after applying/clearing filter

« on: March 24, 2023, 02:30:03 pm »

We are getting duplication data issues with the grid. The steps, we followed as below.

1) Load data with grid - looks fine (refer to the screenshot - SRC_1.png)
2) Apply the range filter to the "N.Value" column (refer to the screenshot - SRC_2.png) - showing a duplicate "0.00" value
3) Select "0.00" & apply a filter to get the duplicate rows (refer to the screenshot - SRC_3.png)

Please advise the solution to fix the duplicate data issue.

My grid code is as below:

Code: [Select]

var loGroupModel =
{
on: false,
summaryInTitleRow: 'all',
showSummary: [false], //to display summary at end of every group.
grandSummary: true,
fixCols: false,
indent: 20,
collapsed: [true, true, true],
title: [
"{0} ({1})",
"{0} - {1}"
]               
};

var obj =
{
width: "auto",
flex: { one: true },
numberCell: { width: 60, show: false },
resizable: true,
filterModel: { on: true, header: false, type: 'local', menuIcon: true, hideRows: false },   //on: true,
menuIcon: true,
selectionModel: { type: 'row', mode: 'block', column: false },
blur: function (evt, ui) {
mGridUIFocus = ui; //global var
mPrevGridUIFocus = ui; //global var
},
editable: false,
stripeRows: false,
showTitle: false,
hwrap: false,
wrap: false,
strNoRows: 'No Net Position found.',
pageModel: { rPP: 50 },
columnTemplate: {
filter: {
crules: [{ condition: 'contain' }]
}
},
colModel: fsTableHeaders,
groupModel: loGroupModel,
rowInit: function (ui)
{
if (ui.rowData.pq_gtitle)
{
//console.log("pq_gtitle: " + ui.rowData);
return {
style: { "background": "#FAD5A5" }
};
}                
},
cellSave: function (evt, ui) {
this.refreshRow({ rowIndx: ui.rowIndx });
},

change: function () {
this.filter();
},
beforeCellClick: function (evt, ui)
{
if (this.SelectRow() != null && this.SelectRow().getSelection() != null) {
if (!evt.ctrlKey && this.SelectRow().isSelected(ui) && this.SelectRow().getSelection().length <= 1) {
return false;
}
}
}
};

var loData = "";
obj.dataModel =
{
method: "GET",
location: "remote",
beforeSend: function (jqXHR, settings) {
jqXHR.setRequestHeader("Content-Type", "application/json");
},

getUrl: function () {
return {
url: "URL to Get net postion data",
data: loData
};
},

getData: function (response) {
var loOrderJS = $.parseJSON(response.d);
data = loOrderJS;
return { data: data }
},
error: function (jqXHR, textStatus, errorThrown) {
customalerterror('Error!', jqXHR.responseText, '500px');
}
};

var grid = pq.grid("#gridfilter1", obj);
grid.one('lazyProgress', function () {
this.flex();
});


grid.on("scroll", function (evt, ui) {
mGridUIScrollX = this.scrollX();
mGridUIScrollY = this.scrollY();
mPrevGridUIScrollX = this.scrollX();
mPrevGridUIScrollY = this.scrollY();
});

grid.on("formatCell", function (row, column, value, data)
{
var groupLevel = this.iGroup.getGroupLevel(row);
if (groupLevel !== undefined && this.iGroup.isSummary(row)) {
var color;
switch (groupLevel) {
case 0:
color = "#FF0000";
break;
case 1:
color = "#FF0000";
break;
case 2:
color = "#FF0000";
break;
default:
color = "#FF0000";
break;
}
return {style: "background-color: " + color};
}
});


15

Help for ParamQuery Pro / Focus on row while typing in PQgrid

« on: March 10, 2023, 07:40:14 pm »

Can we focus a row on typing text related to a column. So as the user types text, the first row that beings with the text will be focused upon.

A google drive link to a sample video has been attached in this post as an example
https://drive.google.com/file/d/1IGa4dyJRIgC-KazSSVngXQuifZL4BZUQ/view?usp=share_link

Any help is much appricated.