Endpoint '/api/requisitions/search' with 'modifiedDateFrom' parameter does not return all data

Description

I noticed that in the database in the requisition table, records with status 'INITIATED' have an empty field 'modifieddate'. This generates a problem when I use an endpoint /api/requisitions/search with modifiedDateFrom parameter. Result of this request does not include records that have an empty 'modifieddate' column.
As a result, it is not possible to get all data because records with the status 'INITIATED' are not included.

It should be possible to get all created requisition records from the database based on the parameter 'modifiedDateFrom'.

Proposed solution:
Upon initiating or skipping the requisition, the modified date should be set to the created date. Also add a migration that will set the modified date to the created date for all records with modified date not set.

Environment

None

Assignee

Oskar Hinc

Reporter

Aleksandra Sołtys

Story Points

3

Time tracking

16h

Epic Link

Components

Sprint

None

Fix versions

Priority

Critical
Configure