If you enter a consultation request without an appointment date and specify that the patient will book their own appointment, the consultation request will not be viewable. This is because the page that displays the consultation requests expects a valid appointment date and time.
The current back-end solution is to plug in a dummy appointment date and time:
update consultationRequests set appointmentDate = ‘1900-01-01′, appointmentTime = ’01:01:01’ where patientWillBook = 1 and appointmentDate is NULL ;