CSV download from table explorer may fail when filtered on a reference column and cause issues with cookie session

[YpeZ]

Have you checked if this issue already exists?

• yes

Molgenis EMX2 version

v11.41.5, database version 23

Description

When filtering the rows of a table in the table explorer based on values of a column referencing another table and subsequently trying to download the filtered rows in CSV format the CSV API may break.
In some cases I experienced that this causes an issue with cookie session IDs resulting in an HTTP 400 error rendering the website unresponsive in the current session.

Reproduction steps

1. Go to https://emx2.dev.molgenis.org/catalogue/tables/#/Resources
2. Click on filters and select internal identifiers. Close the filter dialog
3. Click on testCohort1.test external identifier for cohort 1
4. Click on download -> csv | filtered rows
5. The page opens in a JSON error message stating 'Query failed: : column reference "logo" is ambiguous. '
6. In some cases going back results in an HTTP 400 error:
   

Expected behaviour

Normally step 4 would start a download and keep the browser at the same page.

Note that applying step 4 on the table filtered on the id string column instead of the reference column, containing the same single row for testCohort1 does not yield the error. Leading me to believe the error has to do with reference columns

System configuration

• Device: Apple MacBook Pro 2019
• Operating system: macOS Sonoma 14.6.1
• Browser: Firefox 133.0.3