Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[Lists] [Non-ECS Eureka] Empty contributorType is null in the exported .csv file

Description

ENV: Non-ECS Eureka - https://eureka-bugfest-ramsons.int.aws.folio.org/

PRE-CONDITION:

  • List is created with “Items” entity type

  • Query Builder is opened

STEPS.

  1. Select the following field/operator/value - “Material type — Name” equals audio – other

  2. Click on “+” button from the “Actions”

  3. Select the following field/operator/value - “Holdings — Call number” contains 00

  4. Click on “Test query”

  5. Click on “Run query and save”

  6. When refresh is done, click on “Actions” → Export all columns (CSV)

  7. Open the exported file and check the “Instances — Contributors” column

ACTUAL RESULT: Contributor type is empty in the result table, but null value is displayed on the exported csv file

EXPECTED RESULT: Contributor type is empty in the exported list as well

CSP Request Details

None

CSP Rejection Details

None

Potential Workaround

None

Attachments

1

Checklist

hide

Activity

Show:

Khalilah GambrellNovember 13, 2024 at 5:18 PM

and - should this issue be reassigned to Development Team = Corsair?

Matt WeaverNovember 13, 2024 at 2:24 PM

I just noticed that this is a nested table, so it’s just plain JSON getting dumped into CSV. It’s JSON, so we’re not even trying to render it in a way similar to the UI, and the data really is null. So in this case, I think null makes sense.

Kathleen MooreNovember 12, 2024 at 9:56 PM

I honestly can’t recall – and I’m not aware of a Quesnelia environment where I can see if this a regression, or if I can see if this is just how we’ve been handling it.

Matt WeaverNovember 12, 2024 at 9:39 PM
Edited

- I can’t remember if we ever made a hard decision on what to do with null values when exporting… What should the expected behavior be here? Do we do an empty string or “null”? Both options have their own downsides (basically, ““ vs “null” vs null - all are valid values and it’s hard to differentiate between them in CSV)

Details

Assignee

Reporter

Labels

Priority

Development Team

Corsair

RCA Group

TBD

TestRail: Cases

Open TestRail: Cases

TestRail: Runs

Open TestRail: Runs

Created November 12, 2024 at 6:41 AM
Updated March 11, 2025 at 11:44 AM
TestRail: Cases
TestRail: Runs