Messages

1

Help for ParamQuery Pro / Re: Creating a criteria panel

« on: May 30, 2023, 12:14:35 am »

OK, Thank you.

2

Help for ParamQuery Pro / Re: Creating a criteria panel

« on: May 28, 2023, 01:04:49 am »

I was wondering if there is any news on this. I have looked in the new versions and am unable to find the desired functionality. At one point you mentioned you would add it. Is that still the plan?
Thanks

3

Help for ParamQuery Pro / Re: Creating a criteria panel

« on: September 24, 2022, 12:59:44 am »

Thank you! I'm sure your version will be better than mine, but I will probably give it a go myself as well.

4

Help for ParamQuery Pro / Re: Creating a criteria panel

« on: September 20, 2022, 03:08:22 am »

Hi,

I was just wondering if there was any news on this question. 

I was looking at your demos and thought perhaps I could use a technique like is used here: https://paramquery.com/pro/demos/filter

Is that the best way to approach this?

Regards

5

Help for ParamQuery Pro / Re: Creating a criteria panel

« on: September 01, 2022, 08:14:02 am »

Hi,

The attached image is just the basic concept.

Ideally, I would end up with your filter row organized vertically, in an accordion which is divided by column group. The user would be able to alter the filter type for given columns and so on.

An alternative would be to have a drop-down where they could select a field, then add criteria for that field. They could then add another field and so on. It would still be nice to be able to select the type of criteria to use for each field (gte, lte, etc).

You have done such an excellent job creating the filtering capabilities that it is almost impossible to duplicate what you have right now.

My clients deal with large grids with hundreds of columns, and it is difficult to scroll across and find the proper columns.

I appreciate your assistance with this.

6

Help for ParamQuery Pro / Creating a criteria panel

« on: August 31, 2022, 07:34:56 am »

Is it possible to create a panel to the side or top of the page that contains all of the criteria fields? My client would like a panel layout versus having to go across all the columns to view/change criteria.

I was thinking this might be possible using CSS, or perhaps by looping through all the columns using code, but I'm not sure how to do it.

7

Help for ParamQuery Pro / SortType parameters

« on: June 25, 2022, 01:24:41 am »

What is the most efficient way to pass datatype and sort direction to the sortType function? 

These two pieces of information would be quite useful in a project I am working on.

Thanks

8

Help for ParamQuery Pro / Re: Invalid format error with XLSX export

« on: February 07, 2022, 08:31:59 am »

Hello,

I had not changed any of the original SDK files. Regardless, updating the SDK seems to have fixed it.  Thank you.

9

Help for ParamQuery Pro / Re: Invalid format error with XLSX export

« on: February 03, 2022, 09:17:35 am »

I have not made any changes to the pqgrid.js file.

I'm not sure whether you need to see the entire page or not. It is an MVC project, written in C# on the backend.


I am using the script from one of your demos for the toolbar button.

                    items: [
                        {
                            type: 'select',
                            label: 'Format: ',
                            attr: 'id="export_format"',
                            options: [{ xlsx: 'Excel', csv: 'Csv', htm: 'Html', json: 'Json' }]
                        },
                        {
                            type: 'button',
                            label: "Export",
                            icon: 'ui-icon-arrowthickstop-1-s',
                            listener: function () {
                                var format = $("#export_format").val(),
                                    blob = this.exportData({
                                        format: format,
                                        nopqdata: true, //applicable for JSON export.                       
                                        render: true
                                    });
                                if (typeof blob === "string") {
                                    blob = new Blob([blob]);
                                }
                                saveAs(blob, "pqGrid." + format);
                            }
                        },

10

Help for ParamQuery Pro / Re: Invalid format error with XLSX export

« on: January 30, 2022, 02:08:29 am »

I was on 6.1.0.

I have attached one of the spreadsheets in a zip file.

Thanks

11

Help for ParamQuery Pro / Invalid format error with XLSX export

« on: January 27, 2022, 09:28:44 am »

Ever since I updated to version 8.1.0 of ParamQuery Pro I have been unable to export Excel files.

I am using the sample code from here: https://paramquery.com/demos/export_local

I have attached an image of the error message. It basically says that either the file format or the file extension are incorrect.

12

Help for ParamQuery Pro / Displaying the grid filter

« on: September 21, 2018, 12:06:37 am »

I was just wondering if there is a simple way to display the grid filter as it is being built?  I want to include a textbox that shows users how they are filtering the data as they move from column to column.

13

ParamQuery Pro Evaluation Support / Upgrade from Deluxe to Enterprise

« on: August 26, 2018, 09:55:04 pm »

I am trying to decide on which version to purchase.  I am a one man consulting shop right now so I think that the deluxe license is all I would need, however if I need to upgrade in the future would I only have to pay the difference or would I have to pay the entire amount for the new license?

14

ParamQuery Pro Evaluation Support / Sample project for ASP.Net

« on: July 13, 2018, 10:19:44 pm »

Hello,

I have downloaded the pro trial and am attempting to make it work, however I am running into some issues.  Do you have a sample asp.net project that I could download?  Not just snippets, but an actual project.  I think that would answer a lot of questions for me.

I am on a pretty tight deadline, and in theory your grid is all I want and more, but so far I am not seeing that.

Thank you for your help