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.


Messages - fuljoyment

Pages: [1]
1
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,

2
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,

3
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,

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

5
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,

6
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,

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

8
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,

9
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.

10
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.

11
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.


Pages: [1]