Messages

1

Help for ParamQuery Pro / Re: Filter 'Equal' Condition Not Working as Expected in v10.1.0 for datetime columns

« on: February 15, 2025, 02:10:49 am »

I've tried your fix, and it works, but when the offset is applied to date-only columns, it still works as well. For example, it works with ShippedDate, which is a date-only column, even though the offset ideally should not apply here, based on your explanation. Could you please advise on why this happens?

Additionally, is this considered a permanent fix for the issue, or should we treat it as a temporary workaround? I?d prefer not to commit a temporary solution to production code.

2

Help for ParamQuery Pro / Re: Filter 'Equal' Condition Not Working as Expected in v10.1.0 for datetime columns

« on: February 13, 2025, 05:37:13 pm »

It doesn't work for me; the wrong date is still being applied for filtering. The fmtDate filter only changes the format of the date in the filter cell.

When I log the value, it's passing an incorrect date for comparison. The date value seems to be converted to UTC even though I'm in CST.

3

Help for ParamQuery Pro / Filter 'Equal' Condition Not Working as Expected in v10.1.0 for datetime columns

« on: February 13, 2025, 06:47:19 am »

Hi Support Team,

Could you please look into why I can no longer use the previous "equal" condition that ignores time in v10.1.0? For some reason, it shows no rows even though there is data in the grid that matches the applied filter.

The issue can be reproduced by modifying the "Order DateTime" column to use the "equal" condition filter in version <= v7 and setting the grid to use fmtDate: "dd-mmm-yyyy".

          {
              title: "Order DateTime", minWidth: "230", dataIndx: "OrderDate", dataType: "date",
                //exportRender: true,
                filter: {
                    crules:[{condition: "equal"}],                   
                    conditions: {
                        equal: {
                            compare: function(cd, val){
                                //debugger;
                                cd = new Date(cd);
                                val = new Date(val);
                        //console.log(val);
                                //ignore time.
                                if(cd.getDate()==val.getDate() && cd.getMonth()==val.getMonth() && cd.getYear()==val.getYear()){
                                    return true;
                                }
                            }
                        }
                    }
                },
                filterFn: function(ui){
                    ///debugger;
                    if(ui.condition != 'range'){
                        return {
                            //override the column format
                            format:'M dd, yy'
                        }
                    }
                }
          },

Please advise. Thanks!