[x] Add a view pgmetadata.v_valid_dataset which gives a list of lines from pgmetadata.dataset with corresponding (existing) tables. This view returns only table_name and schema_name, no need for a autogenerated id with row_number
[x] In the Python locator.py use it in the existing SQL query: add a INNER JOIN to return only data for existing datasets
[x] Add this view in the administration template project
mdouchin
commented
3 years ago
The locator shouldn't show orphan metadata
pgmetadata.v_valid_datasetwhich gives a list of lines frompgmetadata.datasetwith corresponding (existing) tables. This view returns onlytable_nameandschema_name, no need for a autogenerated id withrow_numberlocator.pyuse it in the existing SQL query: add aINNER JOINto return only data for existing datasets