Chris Blyth comments

Results 99 comments of


                                            Chris Blyth

Automated Export Rounding

Done a spike but the reporting of what is to export and what has been exported gets very messy when time is rounded. Moving to the backlog until i have...

Email/Password authentication failed (Error updating access token. Auth Error (200))

I get this error too Recently signed up, do not have 2FA

Negative Number Of Unaudited Findings

Yes, we are on 4.12

Negative Number Of Unaudited Findings

Oh :facepalm: updated

Negative Number Of Unaudited Findings

I have no idea how to reproduce it...all I know if that I have more analysis than findings somehow.

Negative Number Of Unaudited Findings

If you tell me what the 2 counts are totaling i.e. how they get the values, I can check our data to maybe point you in a direction for how...

Negative Number Of Unaudited Findings

i had a few records like this. the problem was that they had findings total = 1 findings audited = 2 findings unaudited = -1 i fixed by reducing audited...

Negative Number Of Unaudited Findings

yeah, i found them in that table. Ran an update where unaudited was -1 to set audited = audited - 1 and unaudited = unaudted + 1 ran it a...

Negative Number Of Unaudited Findings

Actually, this didn't solve it fully ![Image](https://github.com/user-attachments/assets/e6831df5-a5a5-4a78-ab29-8e497f5b8d47)

Negative Number Of Unaudited Findings

Running: ``` SELECT SUM(Findings_total),SUM(FINDINGS_AUDITED),SUM(FINDINGS_UNAUDITED) FROM DEPENDENCYMETRICS dm INNER JOIN PROJECT p ON dm.PROJECT_ID = p.ID WHERE dm.ID IN (SELECT MAX(dm.ID) FROM DEPENDENCYMETRICS dm INNER JOIN PROJECT p ON dm.PROJECT_ID =...