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 - gopigupta

Pages: [1] 2
1
Help for ParamQuery Pro / Show tabular data in cell hover over
« on: March 05, 2025, 08:03:51 am »
Hello,

I want to display tabular data as shown below on cell hover over. How can I achieve it?

DayDateHours
Wed05-Mar-20258.00
Fri07-Mar-20258.00


Please let me know if you need more information
Thanks





2
Help for ParamQuery Pro / Export to pdf
« on: April 26, 2024, 12:18:53 pm »
Hello,

Is there any demo available to export grid into pdf for ver. 9.0.2. Also, I am looking for inbuild functionality and would like to avoid use of any third party library(eg. pdfmake)

Thanks

3
Help for ParamQuery Pro / Data exported as text for numeric column
« on: January 18, 2024, 02:22:35 pm »
Hello,

I need one help for export.

I am exporting grid into excel file. The data for grid is coming from server side(.net code) and it is coming in text format for all columns even for numeric columns. I have kept datatype as "float" and format as "##,###.00" for numeric columns in grid but still when I export data, numeric columns are exported as text in excel file.

Is there any easy way to change data into numeric before we export it into grid.

Thanks.   

4
Help for ParamQuery Pro / Tree grid shows leaf icon even if there is no child records
« on: January 05, 2024, 01:12:50 pm »
Hello,

I am using tree grid(vs.9.0.2). When child node is added, parent row shows leaf icon to indicate it has child rows(ScreenShot1). when I rollback changes using below code, the parent row still show leaf icon even though it does not contain any child rows(ScreenShot2).

GridApi.rollback();
GridApi.refreshDataAndView();

Can you please provide solution on how to remove leaf icon if parent node does not have any child nodes 

5
Help for ParamQuery Pro / First row data hidden under header
« on: December 14, 2023, 11:28:11 am »
Hello,

I have started experiencing issue after updating to v9.1.0. Grid's header overlap with some part of first row. This issue only happens when the grid is shown on jquery dialog box(as attached screenshot1)

Clicking on 1st row cell does show data correctly(as attached screenshot2)

Please help to resolve this issue.

Thanks     

6
Help for ParamQuery Pro / Limit rows in multiline entries in pq grid
« on: December 13, 2023, 04:41:01 pm »
Hello,

I am using textarea in pqgrid to enter multi lines in a cell. I want to restrict users to add text only till 5 lines in text area. Is there any way to achieve this?

My code to have text area in cell:-


{
                title: "Field value",
                width: "300",
                dataIndx: "CFValue",
                dataType: "string",
                editable: true, nodrop: false, nodrag: false,
                editor: {
                    type: "textarea",
                    attr: "rows=5 cols=58",
                    style: "resize:both;",
                    appendTo: 'grid'
                },
                editModel: {
                    saveKey: '' //disable or set it to some other key code to free up use of Enter key for line breaks.
                },
                menuInHide: true, hidden: false,
                validations: [{ type: 'maxLen', value: 5000, msg: "Maximum length allowed is of 5000 chars long!" }],
                filter: { crules: [{ condition: 'contain' }], conditionList: ['range', 'contain'], labelIndx: 'CFValue' }, 
            },


7
Help for ParamQuery Pro / Show/Hide columns not working in vs9.0.2
« on: December 06, 2023, 09:45:37 am »
Hello,

I have updated prgrid to vs9.0.2. I am using show/hide functionality of columns using menuUI method. This functionality was working fine before update. But now it has stopped working and giving error when clicked on show/hide menu.

I tried to check code through below link but the functionality is not working in the demo site too.

https://paramquery.com/pro/demos/showhide_columns#:~:text=In%20the%20below%20example%2C%20the,grouped%20column%20parents%20in%20menu.

I am getting below error in developers tool. Please help to resolve this issue.

pqgrid.min.js:9 Uncaught TypeError: Cannot read properties of undefined (reading 'hideCols')
    at pqgrid.min.js:9:411706
    at Array.map (<anonymous>)
    at i.getMenuHtml (pqgrid.min.js:9:411663)
    at i.open (pqgrid.min.js:9:412724)
    at i.onMenuClick (pqgrid.min.js:9:413377)
    at i.onHeadCellClick (pqgrid.min.js:9:411494)
    at p (pqgrid.min.js:9:12092)
    at t._trigger (pqgrid.min.js:9:12674)
    at pq.cRenderHead.onHeaderCellClick (pqgrid.min.js:9:128060)
    at pq.cRenderHead.onHeaderClick (pqgrid.min.js:9:126213)

8
Help for ParamQuery Pro / Context menu alignment is not correct after updating to vs 9.0.2
« on: December 05, 2023, 08:40:29 am »
Hello,

I updated PQgrid from v8.2.1 to v9.0.2. After this update, the context menu is not appearing at right position. It covers the selected cell(attached ScreenShot1.png).

in previous version, the context menu would appear at proper position when cell is right clicked(attached ScreenShot2.png)

Please let me know how to solve this issue.

Thanks

 

9
Help for ParamQuery Pro / exportData not working after upgrading to vs 9.0.2
« on: December 04, 2023, 09:16:43 pm »
Hello,

I updated paramQuery from v8.2.1 to v9.0.2. With this change, my export to excel has stopped working. I am using .net for server code.  Below is my code which was working for v8.2.1 but now noting happens when ExportGridView() is called. Even it is not calling server side code. I did put debugger at server side but nothing happened.

JS code
===============
function ExportGridView() {
    gridApi.exportData({
        url: pageURL + "/exportData",
        format: 'xlsx',
        nopqdata: true,
        render: false,
        sheetName: 'Team Assignments',
        filename: "WFP_TeamAssignments " + moment().format('DD-MMM-YYYY') + '.xlsx'
    });
}


.net code
===============
[HttpPost, ValidateInput(false)]
        public string exportData(string pq_ext, string pq_data, bool pq_decode, string pq_filename)
        {
            System.Web.HttpContext.Current.Application["pq_data"] = pq_data;
            System.Web.HttpContext.Current.Application["pq_decode"] = pq_decode;
            System.Web.HttpContext.Current.Application["pq_filename"] = pq_filename;
            return pq_filename;
        }
        [HttpGet]
        public FileContentResult exportData(string pq_filename)
        {
            String contents = System.Web.HttpContext.Current.Application["pq_data"].ToString();
            byte[] bytes = ((bool)System.Web.HttpContext.Current.Application["pq_decode"]) ? Convert.FromBase64String(contents) :
                new System.Text.UTF8Encoding().GetBytes(contents);
            return File(bytes, "application/octet-stream", pq_filename);
        }

Please help me to get this issue resolved.

Thanks

10
Help for ParamQuery Pro / Tree grid does not show data in correct sort when filter is applied
« on: December 01, 2023, 04:50:16 pm »
Hello,

I am facing issue in tree grid. Filtering column does change the sort order i.e. row position. I am able to generate same issue in demo site(https://paramquery.com/pro/demos/treegrid_filter). Below are steps to reproduce the issue.

1. Go to tree grid demo site - https://paramquery.com/pro/demos/treegrid_filter
2. Check the sort order of first column(Name). "changes.txt" is appearing above "license.txt" under parent "Apache"(Attached ScreenShot1)
3. Filter 1st column by "license.txt". Only "license.txt" will appear under parent "Apache"(Attached ScreenShot2)
4. Now, filter 1st column by word "txt". You will notice that "changes.txt" is now appearing below "license.txt" (Attached ScreenShot3)

If we remove filter then again column will appear with correct sort.

Please help to resolve this issue and do let me know if you need more info.

Thanks.
 

11
Bug Report / Filtering multiple columns in Tree grid.
« on: November 21, 2022, 04:18:19 pm »
Hello,

I am using tree grid in my application. I have an issue while using filters on multiple columns. It does shows result set with OR condition even though I included mode: "AND" in filtermodel. I observed that the tree view example provided in ParamQuery demo site also behaves in similar way(https://paramquery.com/pro/demos)

please see attached image.

Do let me know if you need more information.

Thanks



   

12
Help for ParamQuery Pro / PQGrid export - left align numeric column header in excel file
« on: November 14, 2022, 03:44:04 pm »
I am using standard grid export function to export grid data into excel. The export is working correctly but the only issue I am facing is the alignment of numeric column's headers(float, int datatypes). They are aligning to right and I want them to be left aligned. I tried to use halign: "left" property which shows column header left aligned on grid but in the export file column header appears right aligned. I am using FlieSaver.js file to save blob into excel.

Please let me know any work around.


below code is used to export grid into excel file.

function ExportGridView() {
    blob = gridobj.exportData({
        format: 'xlsx',
        nopqdata: true,
        render: true,
    });
    if (typeof blob === "string") {
        blob = new Blob([blob]);
    }
    saveAs(blob, "filenametest.xlsx');   //call to FileSaver.js file
}

13
Help for ParamQuery Pro / ParamQuery issue with frozen columns and vertical scroll
« on: September 22, 2022, 04:18:31 pm »
Hello,

I am using paramquery grid(v8.4.0) to load data. This grid has 4 columns and 1st column is kept frozen using freezeCols property. Data is also loading correctly in grid(approx 500 rows).

The issue is, after loading the data, if I scroll down fast and try to select cell from first column, then grid wont allow me to select cell. It does not give any error but neither allow to select cell. It will allow to select cells from other columns(which are not frozen). This issue mostly happens when I try to scroll down fast.

I am attaching sample code written in cshtml. I am able to reproduce the issue from this sample code.

Thanks.       

14
Help for ParamQuery Pro / Grid header does not align with column
« on: August 04, 2022, 07:20:47 pm »
Hello,

I am facing an issue of misalignment of grid header with its columns when clicked on filter icon. I can generate same issue in one of the param query demo code. Steps to reproduce:-

1. open link https://paramquery.com/pro/demos/filter_header_local which has demo code for filtering.
2. add code dragColumns: { enabled: false } in grid, maybe after line no. 59.
3. Change freezeCols to 0 i.e. freezeCols: 0
4. click "Edit and Run button".
5. Now, increase width of 2nd column(i.e. Freight) then move horizontal scroll bar to little right so that 2nd column will appear half on grid. Click filter icon of third column(i.e. order ID). You will observe misalignment of header with columns.

I have attached screen shot for reference.

Please let me know solution for this issue.     

15
Help for ParamQuery Pro / dropdowns created in PQGrid toolbar show same content
« on: July 14, 2022, 08:20:45 pm »
Hello,

I am showing two dropdowns in grid toolbar. Dropdowns are appearing correctly in toolbar but both dropdowns show same contents when opened.


The code I used to show drop down buttons is as below:-

toolbar: {
            items: [
                {
                    type: 'button',
                    label: "Export",
                    cls: 'btn btn-secondary btn-sm',
                    attr: 'id="Exportdropdownoption"'
                },
                {
                    type: 'button',
                    label: "Grid settings",
                    cls: 'btn btn-secondary btn-sm',
                    attr: 'id="Gridsettingsdropdownoption"'
                },
            ]
        }

In grid's complete method I did styling for buttons so that they will appear as dropdowns:

complete: function (evt, ui) {
            $("#Exportdropdownoption").replaceWith('<button class="btn btn-outline-primary btn-sm dropdown-toggle" type="button" id="Exportdropdownoption" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Export data</button><div class="dropdown-menu" aria-labelledby="Exportdropdownoption"><a class="dropdown-item" href="javascript: void (0);"onclick="ExportData()">Export Data</a><a class="dropdown-item" href="javascript: void (0);" onclick="ExportGridView()">Export grid view</a></div>');
            $("#Gridsettingsdropdownoption").replaceWith('<button class="btn btn-outline-primary btn-sm dropdown-toggle" type="button" id="Gridsettingsdropdownoption" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">Grid settings</button><div class="dropdown-menu" aria-labelledby="Gridsettingsdropdownoption"><a class="dropdown-item" href="javascript: void (0);"onclick="ResetProjectMappingGrid()">Reset grid</a><a class="dropdown-item" href="javascript: void (0);" onclick="SaveProjectMappingGridSetting()">Save grid settings</a><a class="dropdown-item" href="javascript: void (0);" onclick="RestoreProjectMappingGridSetting()">Restore default grid settings</a></div>');
        },

But the grid shows same contents in both dropdowns as attached in this topic.

Looking for help.

Thanks,
Dilip


 


Pages: [1] 2