Calipseo is FAO web- based platform for national Fisheries Authorities to streamline management of fisheries data and the production, analysis and reporting of fishery statistics.
1
stars
0
forks
source link
[CALR-91] individuals list - Wrong SQL join with reg_entities #91
Issue migrated from JIRA: https://sdlc.review.fao.org/jira/browse/CALR-91
Creator/Reporter: Emmanuel Blondel @eblondel
Assignee: Brian Ojok @brianandy
Priority: High
Status: Done
Date of creation: 2022-04-25T12:14:26.000+0000
In the the SQL file _individualdetails.sql the join with _regentities table is not well done, it should not be done on ID but on REG_ENTITY_ID which is the foreign key.
In the the SQL file _individualdetails.sql the join with _regentities table is not well done, it should not be done on ID but on REG_ENTITY_ID which is the foreign key.