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-74] Vessel QA - vessels ports - switch to a single table for countings #74
Issue migrated from JIRA: https://sdlc.review.fao.org/jira/browse/CALR-74
Creator/Reporter: Emmanuel Blondel @eblondel
Assignee: Brian Ojok @brianandy
Priority: Medium
Status: Done
Date of creation: 2022-04-05T07:12:06.000+0000
Similar to what requested in CALR-73, could you please switch to a single table where we have the Reg / home port as column; instead of 2 tables. Something like that
||Action||Home port||Registration port||
|! To check|xxx|xxx|
|✔ Valid|xxx|xxx|
Column names to be i18n-enabled.
You can stick with separate SQL per counting as now, and proceed with a join in R to ease the implementation.
Similar to what requested in CALR-73, could you please switch to a single table where we have the Reg / home port as column; instead of 2 tables. Something like that
||Action||Home port||Registration port|| |! To check|xxx|xxx| |✔ Valid|xxx|xxx|
Column names to be i18n-enabled.
You can stick with separate SQL per counting as now, and proceed with a join in R to ease the implementation.