Man Lam asked 9 years ago
the searching function don't work when i am using the following query:
$g->select_command = "select full_name, out_datetime, in_datetime, back_to_office, nature, location from mm_outdoor where (in_datetime is not null and back_to_office = 'YES') or (in_datetime is null and back_to_office = 'NO')";
but it's ok when the query is
$g->select_command = "select full_name, out_datetime, in_datetime, back_to_office, nature, location from mm_outdoor";
not support where clause?
Abu Ghufran answered 9 years ago
Try using extra paranthesis around where clause. The auto filter / search dialog will AND the conditions in where clause.
where ( (….) or (…) )
$g->select_command = "select full_name, out_datetime, in_datetime, back_to_office, nature, location from mm_outdoor where ( (in_datetime is not null and back_to_office = 'YES') or (in_datetime is null and back_to_office = 'NO') )";
