Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[CALR-60] Extent vessel owners list to target companies #60

Closed
eblondel opened this issue Feb 19, 2024 · 0 comments
Closed

[CALR-60] Extent vessel owners list to target companies #60

eblondel opened this issue Feb 19, 2024 · 0 comments
Assignees
Labels
enhancement New feature or request priority:medium

Comments

@eblondel
Copy link
Member

Issue migrated from JIRA: https://sdlc.review.fao.org/jira/browse/CALR-60
Creator/Reporter: Emmanuel Blondel @eblondel
Assignee: Brian Ojok @brianandy
Priority: Medium
Status: Done
Date of creation: 2022-03-17T12:34:35.000+0000

With the vessel multi-owner support, we can now have also a company owning a vessel, not only an individual. The SQL query we perform for now is limited to operate a JOIN over reg_entity_individuals. It should be extended (as sql UNION probably) to companies. In principle no R coding here, only an update of the SQL query for vessel owners.

Test case: vessel 'ARAVIS' from Suriname that is owned by a company; See reference queries:

SELECT * FROM surcalipseo.reg_vessel_owners WHERE REG_VESSEL_ID = 2252;

SELECT * FROM surcalipseo.reg_entity_companies WHERE REG_ENTITY_ID = 287;

@eblondel eblondel added enhancement New feature or request priority:medium labels Feb 19, 2024
@eblondel eblondel self-assigned this Feb 19, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request priority:medium
Projects
None yet
Development

No branches or pull requests

1 participant