Return null values

Hi,

I have been trying to get data assist to return blank/null values as well as events that have passed the current time.

Basically, I have an events database, where when a customer opens the page, the events from the current date onward are displayed.

Now, the customer wants current time to be included in the filter, so if a user visits the website, and events that have been that day are also ignored.

I have managed to get that working, no problem.

My issue is certain events in the DB are over a date range, so no time is set.

It is working BEFORE the time feature has been requested, but now, when I add the current time filter, only records with a time set (i.e. events that are not over a date range) are returned.

Is there a way I can get the below to also include Null records?

$WADbSearch1->addComparison("time",$_GET["time"],"AND",">=",0);

Thanks,

Aled

Basically, need the SQL to run something like:

SELECT * FROM `eventtable` WHERE ((`date` >= "2013-09-05") OR (`dateTo` >= "2013-09-05")) AND ((`time` >= '16:51') OR (`time` = ' '))

Got it as far as:

[05-Sep-2013 16:02:39 UTC] AND ((date >= "2013-09-05 00:00:00") OR (dateTo >= "2013-09-05 00:00:00")) AND (time >= '17:02') OR (time = ' ')

Obviously not quite there!

Is there one of wada_search.php's functions that do this for me?

No, there is not a way for Data Assist Search to achieve this result. Data Assist Search does not allow for both of those conditions, only one or the other.

Hi Jason,

That's what I was afraid of!

Thanks for your reply, do you have any suggestions of how we could achieve this?

Aled

You would need to hand code the search rather than use Data Assist Search, we do not offer support for this.