Bug #6

POLICY MANAGEMENT FILTER OPTION - CASE SENSITIVE

Resolved

Description

Filtering Policy Database either by inputing policy number, customer name , or product

Steps to Reproduce

1- Click On Policy
2- Click all policies
3- Type the data of the information you want to filter.
3- Click on filter

Expected Result

It should give an accurate result based on the filtering conditions without it being case sentitive

Actual Result

It give accurate result when the data is produced in the case format it was inputed. For example, POL20251200 written as pol20251200 will give No Policy Found Result

Attachments

WhatsApp Image 2025-09-25 at 13.44.32_60db5323.jpg

File not found

Missing

Developer Resolution Notes

Fixed by changing LIKE to ILIKE in PolicyController search queries for case-insensitive search.

Resolved by: Admin User on Oct 14, 2025 at 7:52 PM

Bug Details

Priority: Medium
Severity: Medium
Module: Policy Management Filter
Browser: Chrome Version 140.0.7339.208
Operating System: Windows 10
Reported By: Admin User
Reported At: Sep 25, 2025 at 12:45 PM

Update Status

Status

Assign To

Resolution Notes (Developer Updates) For developers to provide technical resolution details

Additional Comments

Use this section to add testing notes, additional context, or follow-up information.

Quick Actions

Danger Zone

Once you delete a bug, there is no going back. Please be certain.