Dashlet custom query not working

[sivakumar.bdu]

I created dashlets for task module. i could not use my own query. My requirement is i want to search the task table name field ends with "birthday".

This is my process method in MyTask.php dashlets class


function process() {
if (isset($this->displayColumns) && array_search('name', $this->displayColumns) !== false) {

$query =true;
$lvsParams['select'] = "name ";
$lvsParams['from'] = "Tasks";
$lvsParams['where']="name REGEXP 'Birthday'";

}
parent:rocess($lvsParams);
}
}





i am not sure this is correct..... any body help me ..




Thanks

[eggsurplus]

Have you tried $lvsParams['where']="name like '%Birthday'"; ?

[sivakumar.bdu]

Yes i tried with $lvsParams['where']="name like '%Birthday'";
also still its not working.....

This is the process method





function process() {
if (isset($this->displayColumns) && array_search('name', $this->displayColumns) !== false) {


$query =true;
$lvsParams['select'] = "name ";
$lvsParams['from'] = "Tasks";
$lvsParams['where']="name like '%Birthday'";
}
parent:rocess($lvsParams);
}
}



any other solution for this...............