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

Bug #11443: In installation details correct count of devices are not shown

Added by Arshana Atapattu about 2 years ago. Updated about 2 years ago.

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

0%

Estimated time:
CallRef:
Device 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

Updated by Arshana Atapattu about 2 years ago Actions #1

  • Description updated (diff)

Updated by Kavin Prathaban about 2 years ago Actions #3

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

Updated by Thilina Sandaruwan about 2 years ago Actions #4

  • Assignee set to Pramila Niroshan

Updated by Pramila Niroshan about 2 years ago Actions #5

  • Status changed from New to 12

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

Updated by Lasantha Dharmakeerthi about 2 years ago Actions #6

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

Updated by Pramila Niroshan about 2 years ago Actions #7

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

Updated by Lasantha Dharmakeerthi about 2 years ago Actions #8

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.

Updated by Pramila Niroshan about 2 years ago Actions #9

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

Updated by Lasantha Dharmakeerthi about 2 years ago Actions #10

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

Updated by Arshana Atapattu about 2 years ago Actions #11

  • Status changed from 12 to In Progress

Updated by Lasantha Dharmakeerthi about 2 years ago Actions #12

  • Assignee changed from Pramila Niroshan to Lasantha Dharmakeerthi

Updated by Viranga Gunarathna about 2 years ago Actions #14

  • Status changed from 12 to 9

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

Updated by Lasantha Dharmakeerthi about 2 years ago Actions #15

  • Assignee changed from Lasantha Dharmakeerthi to Kavin Prathaban

Updated by Arshana Atapattu about 2 years ago Actions #16

  • Priority changed from None to High

Updated by Arshana Atapattu about 2 years ago Actions #18

  • Status changed from 12 to 10

Fix is working

Updated by Arshana Atapattu about 2 years ago Actions #19

  • Status changed from 10 to Closed

Closing due to QA accept

Actions

Also available in: PDF Atom