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

Table explorer expects to find 'local name' in Resources table #4264

Open
BrendaHijmans opened this issue Sep 26, 2024 · 3 comments
Open

Table explorer expects to find 'local name' in Resources table #4264

BrendaHijmans opened this issue Sep 26, 2024 · 3 comments
Assignees
Labels
bug Something isn't working priority Features/bugs that we should not let wait

Comments

@BrendaHijmans
Copy link
Contributor

BrendaHijmans commented Sep 26, 2024

What version of EMX2 are you using (see footer)
11.14.1

Describe the bug
The table explorer expects to find a column 'local name' in the Resources table. This is not present in the 4.x or 5.x 'Networks staging model', so the Resources table cannot be viewed in a network staging area.
This happens in model 4.x and 5.x in the networks staging areas. I guess because Resources.localName is not in the NetworksStaging profile, but it is in the catalogue schema. And the NetworksStaging has a ref_array to Resources in the catalogue schema.

image

To Reproduce
Steps to reproduce the behavior:

  1. See error at https://data-catalogue-acc.molgeniscloud.org/testNetwork/tables/#/Resources

OR:

  1. Go to https://emx2.dev.molgenis.org/apps/central/#/
  2. Create new database with template DATA_CATALOGUE_NETWORK_STAGING
  3. Go to the newly made staging area and try to open the Resources table
  4. See error

Expected behavior
I want to be able to view the Resources table in the network staging area.

@BrendaHijmans BrendaHijmans added the bug Something isn't working label Sep 26, 2024
@connoratrug
Copy link
Contributor

maybe a mismatch between schema and data ( did you use the service or the data base to get the data in ) , the column 'localName' seems to be missing from schema 'testNetwork but is part of 'catalogue', the testNetwork.resources column refers to the catalogue.resources column , is this by design ? . could also be a mistake in the query generation not really sure what needs to happen when it encounters column form a other schema

@BrendaHijmans
Copy link
Contributor Author

BrendaHijmans commented Sep 27, 2024

Resources.resources refers to the catalogue Resources table. This is by design, we need to be able to express from a staging area of a network which resources are involved.
Data was imported via api call and zip upload. localName is not in networks staging model on purpose.

@BrendaHijmans BrendaHijmans added the priority Features/bugs that we should not let wait label Oct 12, 2024
@mswertz
Copy link
Member

mswertz commented Oct 13, 2024

@mswertz mswertz self-assigned this Oct 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working priority Features/bugs that we should not let wait
Projects
None yet
Development

No branches or pull requests

3 participants