View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Consistency checks - Scan for issue - Check work on Tickets (v11.1.3) - ProjeQtOr
 
 

Consistency checks - Scan for issue - Check work on Tickets (v11.1.3)

More
13 Feb 2024 15:24 #1 by tblanken
Hi,
just discovered a small issue in named consistency check.

file: model/Consistency.php, line 773

SELECT ... ,(select idActivity from ticket t where t.id=w.refId) ... FROM ... where ... and (select idActivity from ticket t where t.id=w.refId) is not NULL;

Query indicates every booked work, independant from refType, as a ticket. So you get results, if there is some ticket with id of a reference, having referenced any activity.
Attached find an exmple of a query-result (slightly modified for better reading) - first three lines showing . 

Best regards,
Torben
Attachments:

Please Log in or Create an account to join the conversation.

More
15 Feb 2024 10:51 #2 by babynus
Right.
We'll fix that.

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: tblanken

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.046 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.