Bug #11443
closed
  
Task #11442:  Bugs and improvements for View for android Application updates monitoring and manage feature
In installation details correct count of devices are not shown
 
        
        Added by Arshana Atapattu over 1 year ago.
        Updated over 1 year ago.
        
  
  
  
  Description
  
  Description
	In ultimate.com tenant there were installations with different types of action status.
But when try to see them in installation details, it shows device count is 350, but there are no or less devices [2].
	There should have been this many data - >
mysql> select count(*) from AP_DEVICE_SUBSCRIPTION where TENANT_ID=46 AND STATUS='COMPLETED';
--------
| count(*) |
--------
|      127 |
--------
	mysql> select count(*) from AP_DEVICE_SUBSCRIPTION where TENANT_ID=46 AND STATUS='PENDING';
--------
| count(*) |
--------
|      179 |
--------
	mysql> select count(*) from AP_DEVICE_SUBSCRIPTION where TENANT_ID=46 AND STATUS='ERROR';
--------
| count(*) |
--------
|       44 |
--------
	Full data set for above numbers.
DB data: [1]
   
 
  
  Files
  
 
  
  
    
    
    
    
       - Description updated (diff)
 
   
  
  
  
  
    
    
    
    Tested this on a local pack. seems to works fine. need to check with the uem db.
 
   
  
  
    
    
    
    
       - Assignee set to Pramila Niroshan
 
   
  
  
    
    
    
    
       - Status changed from New to 12
 
   
  
  
  
  
  
  
    
    
    
    Simply, this issue cannot be fixed by just passing the offset, limit. If this is fixed with this PR that means we have not handled the pagination count in the front end and it has been fixed via this PR. Passing default offset and limit will not make any change to the count value, because it is getting from a separate query. In this PR DAO level has not been updated.
 
   
  
  
    
    
    
    yes that's correct. total count not getting by above PR. Need to add that
 
   
  
  
    
    
    
    If that's the case, then is this fixed with the above PR?
 
   
  
  
    
    
    
    
       - Status changed from 12 to In Progress
 
   
  
  
    
    
    
    
       - Assignee changed from Pramila Niroshan to Lasantha Dharmakeerthi
 
   
  
  
    
    
    
    
       - Status changed from In Progress to 12
 
   
  
  
    
    
    
    
       - Status changed from 12 to 9
Total installed and uninstalled counts under "Device Subscriptions" are still incorrect.
 
   
  
  
    
    
    
    
       - Assignee changed from Lasantha Dharmakeerthi to Kavin Prathaban
 
   
  
  
    
    
    
    
       - Priority changed from None to High
 
   
  
  
    
    
    
    
       - Status changed from 9 to 12
 
   
  
  
    
    
    
    
       - Status changed from 12 to 10
 
   
  
  
    
    
    
    
       - Status changed from 10 to Closed
 
   
  
 
  
  
 
Also available in:  Atom
  PDF