Project

General

Profile

Actions

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 3 months ago. Updated 2 months ago.

Status:
Closed
Priority:
High
Start date:
01/07/2024
Due date:
% Done:

0%

Estimated time:
Device Type:
Component:
Type:

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

Data.txt (66.5 KB) Data.txt [1] Arshana Atapattu, 01/07/2024 12:44 PM
vokoscreen-2024-07-01_18-06-33.mkv (708 KB) vokoscreen-2024-07-01_18-06-33.mkv [2] Arshana Atapattu, 01/07/2024 12:45 PM
Actions #1

Updated by Arshana Atapattu 3 months ago

  • Description updated (diff)
Actions #3

Updated by Kavin Prathaban 3 months ago

Tested this on a local pack. seems to works fine. need to check with the uem db.

Actions #4

Updated by Thilina Sandaruwan 3 months ago

  • Assignee set to Pramila Niroshan
Actions #5

Updated by Pramila Niroshan 2 months ago

  • Status changed from New to QA

This pr contains the fix,issue was not adding pagination query params
https://repository.entgra.net/proprietary/proprietary-commons/pulls/196/files

Actions #6

Updated by Lasantha Dharmakeerthi 2 months ago

@Pramila Niroshan, please explain how this issue is fixed with the mentioned PR.

Actions #7

Updated by Pramila Niroshan 2 months ago

previosly didnt pass offset and limit, so defaul (5) records returned. with above pr that issue is fixed in this file
https://repository.entgra.net/proprietary/proprietary-commons/pulls/196/files#diff-e490197fda84654e9653f693c158c46434ef4708

Actions #8

Updated by Lasantha Dharmakeerthi 2 months ago

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.

Actions #9

Updated by Pramila Niroshan 2 months ago

yes that's correct. total count not getting by above PR. Need to add that

Actions #10

Updated by Lasantha Dharmakeerthi 2 months ago

If that's the case, then is this fixed with the above PR?

Actions #11

Updated by Arshana Atapattu 2 months ago

  • Status changed from QA to Implementation
Actions #12

Updated by Lasantha Dharmakeerthi 2 months ago

  • Assignee changed from Pramila Niroshan to Lasantha Dharmakeerthi
Actions #14

Updated by Viranga Gunarathna 2 months ago

  • Status changed from QA to QA Reject

Total installed and uninstalled counts under "Device Subscriptions" are still incorrect.

Actions #15

Updated by Lasantha Dharmakeerthi 2 months ago

  • Assignee changed from Lasantha Dharmakeerthi to Kavin Prathaban
Actions #16

Updated by Arshana Atapattu 2 months ago

  • Priority changed from None to High
Actions #17

Updated by Kavin Prathaban 2 months ago

  • Status changed from QA Reject to QA
Actions #18

Updated by Arshana Atapattu 2 months ago

  • Status changed from QA to QA Accept

Fix is working

Actions #19

Updated by Arshana Atapattu 2 months ago

  • Status changed from QA Accept to Closed

Closing due to QA accept

Actions

Also available in: Atom PDF