Recent Posts

1

Suggest new features / gettting of detail grids from parent

« Last post by saritha on Today at 04:07:47 pm »

how to get detail grid data from parent grid object

2

Help for ParamQuery Pro / Re: use format, deFormat with filtering

« Last post by paramquery on April 24, 2019, 08:52:16 pm »

Filter fields for between condition can be kept empty instead of "0%" by updating format callback for empty values.

Code: [Select]

format: function (val) {
       return (val==null || val==="")? "": (pq.formatNumber(val * 100, "# ###") + "%");
},


3

Help for ParamQuery Pro / Re: use format, deFormat with filtering

« Last post by queensgambit9 on April 24, 2019, 02:39:30 pm »

Thanks.

Using:

Code: [Select]

{ title: 'test', width: 130, dataIndx: 'test', dataType: 'float', hidden: false, filter: { crules: [{condition: 'between' }] },
  format: function(val) { return pq.formatNumber(val * 100, '# ###') + '%'; },
  deFormat: function (val) { return (pq.deFormatNumber(val.split('%')[0], '# ###') / 100); }
},
On loading the grid I get '0%' inserted in both filter fields.
I have no empty fields in column, and no errors reported.

Filter works fine when using it...but when sorting the column % sign is once again inserted.
See that its the same behaviour in your example...is that by design?

4

Help for ParamQuery Pro / Re: Pivot mode Issue- Grouping

« Last post by paramquery on April 24, 2019, 09:34:13 am »

Please remove sortable: false from column definition and click on header cell to sort it.

5

Help for ParamQuery Pro / Re: use format, deFormat with filtering

« Last post by paramquery on April 24, 2019, 09:20:48 am »

Code: [Select]

//use deFormat as counterpart of format callback
deFormat: function (val) {                   
        return (pq.deFormatNumber(val.split("%")[0], "# ###") / 100);
}


Ex: Freight column in https://paramquery.com/pro/demos/filter_header_local

Please make appropriate changes if you have null/undefined values in the column

6

Help for ParamQuery Pro / Re: Pivot mode Issue- Grouping

« Last post by EPM Solutions on April 23, 2019, 06:08:46 pm »

Hello Team,

Thanks for your quick and valuable reply. We tried your suggestion in our code and it is working fine.

But now Grouping is not coming in Sorted order.

Please check below image for reference.

7

Help for ParamQuery Pro / Re: Format

« Last post by queensgambit9 on April 23, 2019, 02:49:44 pm »

Having issue with deFormat, how do I apply deFormat on the formatted value to make filtering work?

8

Help for ParamQuery Pro / Re: Pivot mode Issue- Grouping

« Last post by paramquery on April 23, 2019, 10:12:51 am »

Dropdown listener is incorrect in your code.

Please correct it as below.

Code: [Select]

{
            type: 'select',           
            listener:function(evt){             
              this.Group().option({
                dataIndx:$(evt.target).val()? [$(evt.target).val()]: []
              })
            },
            options: [{
                '':'',
                'division': 'Division',
                'Budget_x0020_Year': 'Budget Year'
            }]
}

https://stackblitz.com/edit/paramquery-pivot?file=index.js

9

ParamQuery Pro Evaluation Support / Re: Leading '0' values are not exported properly.

« Last post by gtwangi on April 22, 2019, 04:14:37 pm »

There is another issue about exporting data.
Negative number is exported as number on v5.5 properly. but after I upgraded pqgrid version to 5.6.1, negative number is exported as text.



How I could export this as number?

10

Help for ParamQuery Pro / Pivot mode Issue- Grouping

« Last post by EPM Solutions on April 22, 2019, 03:30:04 pm »

Hello Team,

                We have requiretment to change grouping option dynamically using dropdown.

It is working fine in Non-Pivot mode but seems it is not working for Pivot Mode.

Also, after Pivot mode on and off it stops working for Non-Pivot Mode as well.

We create a plunker for better understanding. Please check and give your feedback asap.

https://next.plnkr.co/edit/SppPfMTgEyj1Mvg9?preview

Thanks.