Not able to filter on blanks

[Uchechukwu-Onye-Igbo]

Hello Datopian,

Some datasets have true blanks in them as this is the best way of dealing will nulls or N/A’s according to our experts here. However, ODP does not allow for filtering on blanks.

https://opendata.nhsbsa.net/dataset/prescription-cost-analysis-pca-monthly-data/resource/c8c5d961-d0f9-4e4f-9e4d-7eb0dcf25cb5

When downloading the filtered file, it confirms that the SUPPLIER_NAME has not been filtered on only blanks:

Please can this be rectified.

Thank you,

[amautadev]

Hi @NHSBSA-Open-Data,

Currently I am reproducing the bug locally and doing changes locally. I will keep you posted once I push correct fixes for staging.

[amautadev]

Hi @NHSBSA-Open-Data,

Now blank values are supported in filters. Deployed to staging.

They appear as (Blank) in the dropdown and can be selected normally.

Filtering by blank values works correctly and returns the expected records

Example:
https://ckan.nhs.staging.datopian.com/dataset/prescription-cost-analysis-pca-monthly-data/resource/38cc2bf7-13a3-4cb7-9744-fbb6940a99b9

Blank values themselves are fine, and the filtering behaviour is now correct.

[NHSBSA-Open-Data]

@amautadev Thank you for this.

I'm very happy with this in staging so far - let me please do UAT testing and I will then be able to formally confirm that this can then be released into Prod.

Will complete UAT asap.

Thank you again,
Kate

[NHSBSA-Open-Data]

@amautadev Can confirm that this has passed Prod UAT testing 2026-02-09.

Thank you,
Kate

[NHSBSA-Open-Data]

@amautadev I noticed that I could not filter on these blanks:

https://opendata.nhsbsa.net/dataset/immigration-health-surcharge-ihs-health-and-care-reimbursement-scheme-performance-data/resource/31805131-f9fc-471c-a7be-cfaa6a581565?filters=COMPLETION_RATE%3A

Could this be looked into, please?

Thank you,
Kate

[amautadev]

@NHSBSA-Open-Data

Hi Kate, I am looking into this issue. Will update you as I progress with this task.