Refactors to the findOne function to use a single prisma query opposed to several individual queries and raw queries. Includes helper methods for accessing case_file actions as well as adding action_code and action_type_code constants to avoid hard coded values.
Task #CE-580
Type of change
Please delete options that are not relevant.
[x] Refactoring
How Has This Been Tested?
Manually tested to verify findOne returns the same object as before refactoring
Description
Refactors to the findOne function to use a single prisma query opposed to several individual queries and raw queries. Includes helper methods for accessing case_file actions as well as adding action_code and action_type_code constants to avoid hard coded values.
Task #CE-580
Type of change
Please delete options that are not relevant.
How Has This Been Tested?
Manually tested to verify findOne returns the same object as before refactoring