Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Consistency checks ...
 
Notifications
Clear all

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

2 Posts
2 Users
0 Reactions
1,045 Views
(@tblanken)
Posts: 41
Active Member
Topic starter
 
[#9311]

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


 
Posted : 13 Feb 2024 17H24
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Right.
We'll fix that.


 
Posted : 15 Feb 2024 12H51
Share:

Scroll to Top