Can removeDate be optional?

Hi,

The removeDate is optional, but by default it will be factored into your query. If a date field is empty, it is stored as a value of 0000-00-00 00:00:00.

If you want to have removeDate as a field but only want it to be factored if removeDate actually has a value, you can structure your query like this:

list($newsRecord, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'where' => "removeDate >= NOW() OR removeDate='0000-00-00 00:00:00'",
'ignoreRemoveDate' => true,
));

ignoreRemoveDate will take away the automatic where clause that removeDate creates. We then create our own where clause that looks for removeDate to be after the current date, or to have no value.

Hope this helps

Great. And how would I combine that with another where statement that I need to include...

'where' => 'archive=0',
'where' => "removeDate >= NOW() OR removeDate='0000-00-00 00:00:00'",

Hi,

Try this:

'where' => "(removeDate >= NOW() OR removeDate='0000-00-00 00:00:00') AND archive=0",

In this example, it will only return records where the archive checkbox hasn't been checked.

Hope this helps

Thanks again. And in case anyone else tries to utilize this, note that you also need to add the "'ignoreRemoveDate' => true," to your detail pages.