I'm trying to load a specific row from my database table with JTable. In my case i have 3 fields which is unique. In most cases, two of these fields will be a null value, while one will always have a value.
Here's an example of how i try to retrieve the row
$table = $this->getTable("table"); $table-load(['field1' =>'something', 'field2' => null, 'field3' => null]);
Through debugging i found out that joomla creates a query like
field1 = 'something' AND
field2 = '' AND
field3 = '' which the fails to find the row with the null values.
Is there any workaround still using JTable, or do i have to use the database without JTable in this situation. I've read some places that they don't take a null value to consideration when querying, but still hope there is a solution
Here's a pastebin link of how the table look http://pastebin.com/TkKRG7FV