Filter for Highest Sources for Fields

[OpenOilUG]

• We need to apply a filter to updated field data to prevent duplication in the interface. We would like to enforce a situation where project data for each country and fossil fuel is surfaced only from best available source.
• In order to determine which approach to altering queries and architecture is the most feasible, we would like to access code which calls the data so that a new team member, Daylon Howell, can take a look.

[niklaserik]

For the project data we use: https://github.com/fossilfuelregistry/portal-v2/blob/master/lib/useProjectData.tsx and https://github.com/fossilfuelregistry/portal-v2/blob/master/lib/useProjectSources.tsx For the countries we use https://github.com/fossilfuelregistry/portal-v2/blob/master/lib/useCountryData.tsx. I would recommend him to look in the lib folder.

[OpenOilUG]

@niklaserik to implement source prioritisation i added a boolean column to the projects table - i am hoping it is straightforward to select that field in the country queries (drop down box near the top of the page where list of projects from that country are listed). can you confirm query can be adjusted to use this filter... selecting projects only where has_authority = true ??