Filter on checkbox field not working as expected (Content search portal and relationship filter)

[Neehakethi]

Parent Issue

No response

Problem Statement

While looking to filter, the Relationships filter/Content Search Filter is not functioning as expected
When selecting specific checkboxes, the content disappears entirely instead of being filtered.

Steps to Reproduce

1. Create a content type (Test-relation).

2. Add a checkbox field to it. ( Have two values and mark a default value)

3. Mark the field as required, and user searchable
4. Create example contentlets of this content type
   
5. Create another content type test-B and relate this to it.
6. While creating a new contentlet of Test-B, try filtering by the check box value

7. The content disappears entirely instead of being filtered when selecting specific checkboxes.

Acceptance Criteria

The filtering should work as expected on the checkbox field.

dotCMS Version

24.04
latest version (demo) : 25.03.14

Proposed Objective

Core Features

Proposed Priority

Priority 3 - Average

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

https://dotcms.freshdesk.com/a/tickets/30098

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response