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

Pages: [1] 2
1
We are using dateRangePicker inside pqDatePicker to support date range filter.

On horizontal grid scroll, when date coulmn render pqDatePicker initialization happens but dateRangePicker doesn't show up sometimes due to below error.

"Uncaught TypeError: Cannot read property 'is' of undefined" for "se.is(":visible")" in below line of code.
return e(this).off(".datepicker").on("click.datepicker", function(e) {
                se.is(":visible") || s(a.duration)


-Below is the date column filter-
filter: { crules: [{ condition: 'between'}], type: 'textbox', init: pqDatePicker, attr: 'multiple' }

Request you to comment on this issue resolution.

2
Help for ParamQuery Pro / Re: Filter in 5.2.0 custom select-dropdown
« on: August 22, 2018, 11:49:27 pm »
Hi Admin,

The drop down is in the header filter, and the filtering is local.

The values from the response is either true/false and I have an image displayed in the UI based on true/false.

So In filter, instead of true/false I need to display yes/no and on selection as well yes/no should be displayed in the search field. But the values the filter takes is true/false to filter.
Kindly let me know, how we can achieve it.

3
Bug Report / Re: PQ Grid copy paste issues
« on: August 21, 2018, 01:16:51 am »
Hi,

Now we don't have much time to upgrade to the new version since our release is nearing. So, I am afraid upgrading the newer version may create any problem (Note: Even if a minor alignment issue at this time will cost too high for us). So I request you to provide the specific change(from V5.2) related to this fix so that we can include that in our extension file than going for the whole version upgrade.

Note : It looks few weeks for Upgrading to V5.2 from older version.

4
Help for ParamQuery Pro / Re: Filter in 5.2.0 custom select-dropdown
« on: August 20, 2018, 10:27:31 pm »
One more thing..Mapping the options from 'true' to 'Yes' and 'false' to 'No' is working. But after choosing the value, search text still showing true/false. We wants that to be Yes/No. Can you please suggest how we can do that?


options: [
   {"": ""},
   {true:'Yes'},
   {false:'No'}
]

5
Hi,


I tried your suggestions in the demo with URL https://paramquery.com/pro/demos/filter_custom# by updating as follows for 'Order Date' column. But after doing this, date filter selection itself is not working.


 { title: "Order Date", minWidth: "240", dataIndx: "OrderDate", dataType: "date",
              filter: {
                    crules: [{condition: "between" }],
                    //pass options to jQueryUI datepicker.
                    dpOptions: {
                        showWeek: true   
                    }
               
                },
          
                 format: function(val){
               
                if(val ==''){
                return val;
                }
               
               var d = new Date(val);
              
            var month=new Array(12);
            month[0]="Jan";
            month[1]="Feb";
            month[2]="Mar";
            month[3]="Apr";
            month[4]="May";
            month[5]="Jun";
            month[6]="Jul";
            month[7]="Aug";
            month[8]="Sep";
            month[9]="Oct";
            month[10]="Nov";
            month[11]="Dec";
               
            timeZoneFormatted=d.toString().match(/\(([A-Za-z\s].*)\)/)[1]
            return month[d.getMonth()] + " " + d.getDate() + ", " + d.getFullYear() +" "+d.getHours()+":"+d.getMinutes()+":"+d.getSeconds()+" "+timeZoneFormatted;
            }
         
          }

Note: Date time in JSON kept correctly in format "2018-08-14T05:59:17"


Please let me know whether any demo available to check this.


Also, please let us know when V 5.3 will be available for download.

6
Bug Report / Re: PQ Grid copy paste issues
« on: August 17, 2018, 08:55:48 pm »
Please let me know the date you are planning to release V 5.3.

7
Thanks for your reply.

But we have to support date time format in all our screens (For example: Updated Time which should contain time too). Please let us know any plan for supporting date and time for date search.

8
Hi

In the below demo, if the 'orderDate' values is null then the date picker is showing year from '1959' to '1979' and we don't have an option to choose recent year. Can you please suggest how we can solve this issue.

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


"data": [{
      "OrderID": 10409,
      "ContactName": "Yvonne Moncada",
      "EmployeeID": 3,
      "OrderDate": null,
      "RequiredDate": "02/06/1997",
      "ShippedDate": "01/14/1997",
      "ShipVia": "Speedy Express",
      "Freight": 29.83,
      "ShipName": "Océano Atlántico Ltda.",
      "ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
      "ShipCity": "Buenos Aires",
      "ShipRegion": null,
      "ShipPostalCode": "1010",
      "ShipCountry": "Argentina",
      "paid": true,
      "code": "ar"
   }, {
      "OrderID": 10531,
      "ContactName": "Yvonne Moncada",
      "EmployeeID": 7,
      "OrderDate": "AUG 14, 2018 05:59:17 AM",
      "RequiredDate": "06/05/1997",
      "ShippedDate": "05/19/1997",
      "ShipVia": "Speedy Express",
      "Freight": 8.12,
      "ShipName": "Océano Atlántico Ltda.",
      "ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
      "ShipCity": "Buenos Aires",
      "ShipRegion": null,
      "ShipPostalCode": "1010",
      "ShipCountry": "Argentina",
      "paid": true,
      "code": "ar"
   }   ]
},


9
Hi,

We have implemented  the date picker as per the demo https://paramquery.com/pro/demos/filter_header_local  (look for orderdate feild). Below is the “json” used in the demo.

 Note:  Using the below JSON, I am able to see the correct search results while searching with same From and To Date (OrderDate field search in demo).
{
   "data": [{
      "OrderID": 10409,
      "ContactName": "Yvonne Moncada",
      "EmployeeID": 3,
      "OrderDate": "01/09/1997",
      "RequiredDate": "02/06/1997",
      "ShippedDate": "01/14/1997",
      "ShipVia": "Speedy Express",
      "Freight": 29.83,
      "ShipName": "Océano Atlántico Ltda.",
      "ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
      "ShipCity": "Buenos Aires",
      "ShipRegion": null,
      "ShipPostalCode": "1010",
      "ShipCountry": "Argentina",
      "paid": true,
      "code": "ar"
   }, {
      "OrderID": 10531,
      "ContactName": "Yvonne Moncada",
      "EmployeeID": 7,
      "OrderDate": "05/08/1997",
      "RequiredDate": "06/05/1997",
      "ShippedDate": "05/19/1997",
      "ShipVia": "Speedy Express",
      "Freight": 8.12,
      "ShipName": "Océano Atlántico Ltda.",
      "ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
      "ShipCity": "Buenos Aires",
      "ShipRegion": null,
      "ShipPostalCode": "1010",
      "ShipCountry": "Argentina",
      "paid": true,
      "code": "ar"
   }   ]
}



But in our case, it's date time field with format like AUG 14, 2018 05:59:17 AM. Now if I choose same value for 'From' and 'To' dates (eg : Aug 14, 2018), then it's showing 'No rows to display'.

In general, we are facing following issues:

1) Same date search is not working
2) Search result doesn't include same To date records .


Can you please suggest solution for this?

10
Hi,

We have implemented  the date picker as per the demo https://paramquery.com/pro/demos/filter_header_local  (look for orderdate feild). Below is the “json” used in the demo.

 Note:  Using the below JSON, I am able to see the correct search results while searching with same From and To Date (OrderDate field search in demo).
{
   "data": [{
      "OrderID": 10409,
      "ContactName": "Yvonne Moncada",
      "EmployeeID": 3,
      "OrderDate": "01/09/1997",
      "RequiredDate": "02/06/1997",
      "ShippedDate": "01/14/1997",
      "ShipVia": "Speedy Express",
      "Freight": 29.83,
      "ShipName": "Océano Atlántico Ltda.",
      "ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
      "ShipCity": "Buenos Aires",
      "ShipRegion": null,
      "ShipPostalCode": "1010",
      "ShipCountry": "Argentina",
      "paid": true,
      "code": "ar"
   }, {
      "OrderID": 10531,
      "ContactName": "Yvonne Moncada",
      "EmployeeID": 7,
      "OrderDate": "05/08/1997",
      "RequiredDate": "06/05/1997",
      "ShippedDate": "05/19/1997",
      "ShipVia": "Speedy Express",
      "Freight": 8.12,
      "ShipName": "Océano Atlántico Ltda.",
      "ShipAddress": "Ing. Gustavo Moncada 8585 Piso 20-A",
      "ShipCity": "Buenos Aires",
      "ShipRegion": null,
      "ShipPostalCode": "1010",
      "ShipCountry": "Argentina",
      "paid": true,
      "code": "ar"
   }   ]
}



But in our case, it's date time field with format like AUG 14, 2018 05:59:17 AM. Now if I choose same value for 'From' and 'To' dates (eg : Aug 14, 2018), then it's showing 'No rows to display'.

In general, we are facing following issues:

1) Same date search is not working
2) Search result doesn't include same To date records .


Can you please suggest solution for this?









11
Bug Report / Re: PQ Grid copy paste issues
« on: August 15, 2018, 04:54:04 am »
Hi,

Please let me know once the below bug fix is available. Also, should I get the delta changes only for this fix?. Otherwise, I afraid we may need to do more changes to incorporate latest version in our application.

12
Hi,

While using PQ Query (V5.2), grid shifts up after selecting a cell and scroll down using laptop touch pad. This issue is happening while setting height with same value (eg: 700). Can you please I need to do anything specifically while setting the height?

In the below demo, if I set height : 700 I can reproduce the same behavior.
https://paramquery.com/pro/demos/editing_custom

13


We are able to integrate and the drop down is populating in single click. But while when we try to click on already selected option, nothing is happening even though the selection is preserved.This may cause confusion to the user since the drop down popup is not disappearing.

Please suggest me how I can fix the above problem.

Note : I can reproduce the same behavior in the demo link shared.


14
Bug Report / Re: PQ Grid copy paste issues
« on: August 07, 2018, 06:44:48 am »
Thanks.

It will be helpful if you can provide a date for which the fix is available. Also, is there any workaround for this?

15
This seems to be because some default height is configured. While commenting the configuration, this issue resolved.

Pages: [1] 2