Recent Posts

1

Help for ParamQuery Pro / Re: JQuery error with e.addEventListener

« Last post by JoeTexan1962 on February 24, 2021, 10:05:40 pm »

Thank you. I didn't notice that I was looking at the demo for the free version. That fixed the problem.

2

Help for ParamQuery Pro / Re: loadState using State Parameter

« Last post by mikep on February 24, 2021, 06:40:59 pm »

Yes, it actually does. Thank you!

3

Help for ParamQuery Pro / Re: Issue filter

« Last post by paramvir on February 24, 2021, 06:01:09 pm »

In Angular, you would have to add this import.

Code: [Select]

import $ from 'jquery';


4

Help for ParamQuery Pro / Re: JQuery error with e.addEventListener

« Last post by paramvir on February 24, 2021, 02:28:19 pm »

you are facing issues because your source code seems to be taken from the demos of free version https://paramquery.com/demos

Source code for free version examples is not fully compatible with Pro version.

Please follow the examples of Pro version here: https://paramquery.com/pro/demos

5

Help for ParamQuery Pro / Re: Issue filter

« Last post by atmaneuler on February 24, 2021, 12:48:57 pm »

When I add your command to my command line, my grid page doesn't load at the same time with an error message.

Code:
    {
        title: 'CS1',
        // width: 65,
        dataType: 'date',
        dataIndx: 'cs1',
        format: 'mm.dd',
        align: 'center',
        valign: 'center',
        hvalign: 'center',
        style: this.styleCell(),
        styleHead: this.styleHead(),
        sortable: false,
        filter: { crules: [{ condition: 'between' }] },
        render: function(ui) {
          return $.datepicker.formatDate('mm.dd', new Date(ui.cellData))
        }
      },

6

Help for ParamQuery Pro / Re: JQuery error with e.addEventListener

« Last post by JoeTexan1962 on February 23, 2021, 07:19:14 pm »

JSFiddle: https://jsfiddle.net/JoeTexan1962/4eLto68c/11/

I'm sure there's something simple I'm doing wrong, but I can't put my finger on it.

7

Help for ParamQuery Pro / Re: Issue filter

« Last post by paramvir on February 23, 2021, 06:10:57 am »

Here is the solution for your requirement:

Please use column.render instead of column.format to display dates in 'mm.dd' format.

Code: [Select]

render: function(ui){
return $.datepicker.formatDate("mm.dd", new Date(ui.cellData))
},

Please let me know if it doesn't solve your requirement.

8

Help for ParamQuery Pro / Re: Pre-Defined filter 7 days old from today

« Last post by paramvir on February 22, 2021, 10:07:11 pm »

Please add this filter property to the column:

Code: [Select]

filter: {               
                crules: [{
                    condition: 'less',
                    value: $.datepicker.formatDate("mm/dd/yy", new Date(Date.now() - 7 * 24 * 60 * 60 * 1000))
                }]               
        }


9

Help for ParamQuery Pro / Re: Pre-Defined filter 7 days old from today

« Last post by neoinbiz on February 22, 2021, 07:16:06 pm »

This does give the date of 7 days older but did not pre-define the filter for the Created column.
I changed the date to be the 7 day of date of 2/15/2021
Am I missing something?

Code: [Select]


{ title: "Created", width: "8%", dataIndx: "Created",
render: function (ui) {
    if (ui.rowData.Created) {
        var usaDate = new Date(Date.now() -7 * 24 * 60 * 60 * 1000);
        return usaDate.getMonth() + 1 + "/" + usaDate.getDate() + "/" + usaDate.getFullYear();
    }
}
},


10

Help for ParamQuery Pro / Re: Pre-Defined filter 7 days old from today

« Last post by paramvir on February 22, 2021, 02:53:44 pm »

Please check this example on pre defined filters:

https://paramquery.com/pro/demos/filter_initial

And to get a date older than 7 days, use "less" filter condition with

Code: [Select]

new Date(Date.now() - 7 * 24 * 60 * 60 * 1000)