Entries in table export depend on current viewport and state of ext_references
I wanted to download the result of a select query as xsl and ended up having the following result:
| ID | date | project |
|------|------------|---------|
| 9720 | 2020-11-11 | 2020_l |
| 9722 | 2020-11-24 | 2020_l |
| (...)| (...) | (...) |
| 9725 | 2021-01-12 | 2155 |
| 9727 | 2021-01-19 | 2155 |
It turns out that the excel converter (possibly also the tsv converter) downloads the result as shown on the screen. This means that only a part of the project references have been resolved to "2020_l" and others (which were not visible) remain to show the ID of the entity 2155.
I think this is not what the user wants.
I suggest running a full ext_references (disregarding the current viewport) before triggering the xls/tsv download.