Sorry if this has been asked before, but the search function appears to be broken, at least for me. I get only a blank page and a 500 Internal Server error from the server.
I have a MySQL table, controlling a workflow. The fields are mainly dates for when a specific part of the flow has been reached.
The fields could be like these:
When a field has the default value of "NULL" the step is pending.
What I need to do is to take all the rows with NULL in the field "task2ComplitionTime" but it seems that findBytask2CompletionTime has no way to searching for null. Is it not possible to use the findBy method when you are looking for null?
The code I am trying to make work is
$pendingTasks = workFlow::findByTask2ComplitionTime('NULL'); // Pure null and 'is null' has also been tried. var_dump($pendingTasks->toArray()); // Only gives an empty array.
The following code works:
$pendingTasks = workFlow::find('task2ComplitionTime IS NULL'); var_dump($pendingTasks->toArray()); // Dumps the expected rows.
But I would really like to use the findBy if possible, as it looks nicer when reading the code.