Description
When creating a new policy, the system requires the user to search for and select an existing product by entering the products's name, type, code. The search field is expected to display matching registered products in an autocomplete dropdown.
Steps to Reproduce
1. Go to Annuity Policies 2. Click on Add new policy 3. Input Product Name, Trpe or code
Expected Result
When a user enters the name, type, or code of an existing registered product in the product search field, the system should display matching product records in the autocomplete dropdown, allowing the user to select the appropriate product and continue with policy creation.
Actual Result
The autocomplete dropdown does not display any matching product records even though the product exists in the database. Consequently, the user cannot select the product, preventing the creation of a new policy.
Developer Resolution Notes
Root cause: ProductController@search queried WHERE status = "active" but the products table uses "product_status" column (not "status"). Fixed by changing ->where("status", "active") to ->where("product_status", "active") in Api/ProductController.php.
Bug Details
- Priority
- High
- Severity
- High
- Module
- Annuity Policies
- Browser
- Chrome 148.0
- Operating System
- Windows 10
- Reported By
- CLAAPP Super Admin
- Reported At
- Jun 8, 2026 at 7:28 PM
Update Status
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.