Messages

1

Help for ParamQuery Pro / Issue with filtering the grid data when we have more than 150 filter values

« on: September 09, 2021, 12:23:37 pm »

Hello Admin,

I am facing a problem with filtering the data in the pqGrid. The filter values filled remotely and we are using remote data.  I am using the following filter rule in my grid.

Code: [Select]

{
   title: "colorName", align: "center", dataIndx: "color", width: "120",
       filter: {
           crules: [{ condition: 'range'}]
               }
 },

As per my observations, if we have more than 150 filter values and do filtering by checking/unchecking them then  the data in the grid is not updating. Also, if we uncheck all then checking them one by one then the data is updating.


Note:- I am using Paramquery Version 6.2.4 with ASP.Net Core MVC..


Thanks in advance,

2

Bug Report / Re: Excel export is not working for Pivot grid /Grouped columns grid

« on: July 22, 2021, 06:23:04 pm »

Hi again,

1) Yes we are getting the same issue with local export as well . I have used fileServer to download locally to my machine.

2) Could you please provide the email here.

Thanks,

3

Bug Report / Excel export is not working for Pivot grid /Grouped columns grid

« on: July 20, 2021, 12:29:14 pm »

Hello Admin,

Problem 1: I am using the remote export for my Pivot grid.  When ever I clicked on 'Export' button the data is not exporting as expected for excel/csv type. 

Problem 2: I have implemented a grouped grid based on your demos 'https://paramquery.com/pro/demos62'.  When ever I clicked on 'Export' button the data is not exporting as expected for excel/csv type.  I got the similar issue as like pivot Grid.  Here also I am using Remote export only.

I think I have got the issue only if I used grouping in my grid.

Please help me out on this as this was the urgent requirement from my customer.


PS:I am using Paramquery Version 6.2.4 with ASP.Net Core MVC..

I am attaching the spread sheet error for your reference.

Thanks in advance,

4

Help for ParamQuery Pro / Re: Get the selected coulmns list on button click event without the column selector

« on: February 12, 2020, 10:06:49 am »

Hi,

Thank you for the quick response.  Now I am able to get the selected columns from the menuUI-Icon.

But as you suggested when I used grid.saveState() it will not stores the customized columns data instead it stores the grid information which was loaded initially.

Here after selecting specific columns (let us say 5 columns) from the menuUI - Icon, I want to store that grid information instead of its initial state which is having 30 columns data. 

Please suggest me is there any event/method to get that customized grid data. 

Our requirement is to store that customized pivoted grid information as a string in Database and re-create/update the grid with the remote data.

Thank you,

5

Help for ParamQuery Pro / Get the selected coulmns list on button click event without the column selector

« on: February 10, 2020, 04:18:19 pm »

Hello Admin,

I have created a pivot grid with 50 columns. After initial loading I have selected some specific columns with menuIcon.

Here I need to know,

• How to get the selected/customized coulmns list on button click event from selecting the columns from menuIcon? (These are the columns after selecting from menuUI - Icon)
• How to store the entire pivoted grid information(like: colModel, groupModel, dataModel...etc) after customizing the columns data and recreate/reload the existing grid with this stored grid information?

Please provide a demo or guide me how to achieve this because this is an urgent requirement for us.

PS:-I am using ParamQuery Pro v6.2.4 in my ASP.net MVC project.

Thanks in advance,

6

News / Re: Updated roadmap of ParamQuery

« on: December 13, 2019, 04:34:56 pm »

Oh..! That's really sounds good.

Because we have a requirement to export images along with the data in our project. 

Thank you,

7

Help for ParamQuery Pro / Re: How to hide the loader(Hide Loading) after file was exported when data is huge

« on: December 10, 2019, 11:45:39 am »

Sorry we don't need Local Export. But I tried with one of your demo's.

8

Help for ParamQuery Pro / Re: How to hide the loader(Hide Loading) after file was exported when data is huge

« on: December 04, 2019, 05:00:35 pm »

Hi there,
 

Again, even after using the above suggested listener code it was not working as expected.  Please let us know if you found the best fit solution (Or) if you implement any grid event for download complete . Mean while I will also try to find the best possible solution for this.

Thanks and waiting for the positive reply,

9

Help for ParamQuery Pro / Re: How to hide the loader(Hide Loading) after file was exported when data is huge

« on: December 03, 2019, 10:14:06 am »

Hi Again,

Even after using the above suggested listener code it was not working as expected.  After sometime(maximum 5 seconds) the loader is hiding before the file downloaded. I have tried to increase the interval time in the listener but no use. 

As I told you before I want to show the "Loader" image while data is getting ready to download and once file was downloaded I want to hide the "Loader".

PS:Currently I have 693238 records in my table.  I want to export all of them to different formats(csv/excel/json/html).  It would be very grateful for us if you suggest me better solution for this because it was an urgent fix for us.

Thanks in advance,

10

News / Re: Updated roadmap of ParamQuery

« on: December 03, 2019, 09:54:42 am »

Dear Admin,

Is there any update about exporting the Images(in csv/excel/.. formats).

1. While Import/ Export and editing of spreadsheets: extend support to more styles
  a) borders,
  b) comments ( improve it ),
  c) images

Thanks,

11

Help for ParamQuery Pro / How to hide the loader(Hide Loading) after file was exported when data is huge

« on: November 29, 2019, 07:24:03 pm »

Hello Admin,

When I clicked on 'Export' button there is a significant delay before the file was downloaded.  I want to show the loading message to the user so that user will understands that some action is going on.  So, I added $( ".selector" ).pqGrid( "showLoading" ) on Export button click.  I used 'setTimeout' to stop the Loader and used $( ".selector" ).pqGrid( "hideLoading" ) but it was not working as expected.

Code: [Select]

listeners: [{
                    "click": function (evt) {
                        var grid = this;
                        grid1.pqGrid("showLoading");
                        setTimeout(function () {
                            grid.exportData({
                                url: "CustOrdTable/exportData",
                                format: $("#export_format").val(),
                                render: true
                            })
                        });
                        grid1.pqGrid("hideLoading");
                    }
                }]
Note: I think here setTimeout works when we want to export the local data.  This is not working with round trip to remote server.

So, My question is

• How we can show the loading message while data is getting ready for download with round trip to remote server?

Could you please suggest me what am doing wrong and if possible show me a demo on Exporting the Remote data with 'showLoading' and 'hideLoading'.

PS:-I am using ParamQuery Pro v6.2.4 in my ASP.net MVC project.

Thanks in advance,

12

Help for ParamQuery Pro / Re: Checkbox for autocomplete

« on: December 07, 2016, 02:26:57 pm »

Hi,
I found a solution to autocomplete using jquery. Thank you for your reply and support.
the code i am using now is:
  title: "xyz", width: 100, dataIndx: "xyz",
            filter: {
                type: "textarea",
                condition: 'equal',
                listeners:  'change',
            init: function () {
                    $(this).autocomplete({
                        source: "userpage1/getresult",
                        selectItem: { on: true },
                        highlightText: { on: true },
                        minLength: 0,
                        delay: 500,
                        select: function (event, ui) {
                            var terms = split(this.value);
                            terms.pop();
                            terms.push(ui.item.value);
                            terms.push("");
                            this.value = terms.join(", ");
                            return false;
                        }
                    });
                }

function split(val) {
        return val.split(/,\s*/);
    }

The above code is working fine with Firefox browser. but in other browsers like IE and Chrome, the 'change' event is not fired. i tried using tab and clicking on another control without any positive result. Can you please help me to resove this browser difference for this change event.

Thank you.

13

Help for ParamQuery Pro / Checkbox for autocomplete

« on: November 23, 2016, 09:51:38 pm »

hi I am using Autocomplete in the textbox field for the remote header filtering. Right now the user is able to select one item from the list generated using autocomplete.  Is it possible to create check box for the all the items that are generated in autocomplete, so that the user can select multiple options and filter for them? if so how?
My present code is below

{
            title: "xyz", width: 100, dataIndx: "xyz",
            filter: {
                type: "textbox",
                condition: 'equal',
                listeners:  'change',
                init: function () {
                    $(this).autocomplete({
                        source: "userpage1/getresult",
                        selectItem: { on: true },
                        highlightText: { on: true },
                        minLength: 0,
                        delay: 500
                    }).focus(function () {     
                        $(this).autocomplete("search", " ");
                    });
                   
                }
            }
        },

I have one more problem, When a user types something in the filter textbox and hits enter, the page is redirected to default page. Can you please let me know how i can stop the page from being redirected to default application page.

Thank you in advance.

Jabez.

14

Help for ParamQuery Pro / Export all the data

« on: September 26, 2016, 06:04:19 pm »

Hi,
I am having a gird that consists of 80 columns and the total number of result rows are above 300000. So, i am using pagination and displaying only 1000 or 5000 or 10000 rows.
After applying filters and hiding some columns i want to export the data into Excel or Csv file. The export function is working fine, but the problem is it is exporting only 1000 or 5000 or 10000 rows.
Is there a way where i can export the total rows (appx. 1500000) after applying filters?

Thank you.