dwaghulade commented on issue #6768: URL: https://github.com/apache/incubator-devlake/issues/6768#issuecomment-1892828876
Hi Klesh, Please refer to below details. which dashboard is that? : Jira (any jira related dashboard with two or more boards selected from boards filter; it should not be selected) ***@***.*** Are there duplicated issues in the database? Can you share the values of the id column if there were duplicated issues. Yes and No. Duplicated issues in database if we consider just issue id. But these two are mapped with different boards. Please refer to below screenshot for query executed with two boards (Issue Throughtput -> Number of Issues metrics for an example however issue will persist for all metrics with two or more boards selected in filet). Check at Universal-29314 issue; it is returning twice as it is matching for 'jira:JiraBoard:2:31004' and 'jira:JiraBoard:2:31005' each boards. It seems join query needs to be updated at all metrics to exclude duplicate issues. ***@***.*** Regards, Dhiraj Waghulade| Project Manager, LTIMindtree-EA | Desk +1 512 687 9758 | Cell +1 512-665-9513 | email: ***@***.******@***.***> From: Klesh Wong ***@***.***> Sent: Monday, January 8, 2024 9:07 PM To: apache/incubator-devlake ***@***.***> Cc: Dhiraj Waghulade ***@***.***>; Author ***@***.***> Subject: Re: [apache/incubator-devlake] [Bug][JIRA Issues] Dashboard is double counting issues if those are part of multiple projects (Issue #6768) Hi, which dashboard is that? Are there duplicated issues in the database? Can you share the values of the id column if there were duplicated issues. - Reply to this email directly, view it on GitHub<https://github.com/apache/incubator-devlake/issues/6768#issuecomment-1882291030>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BDLG5Q6W6FHODSGBGB6RQRLYNSX43AVCNFSM6AAAAABBSHDZCOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOBSGI4TCMBTGA>. You are receiving this because you authored the thread.Message ID: ***@***.******@***.***>> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
