recordset criteria

[PhanMan]

i want to display a record set. 

Code:

<?php

$task_find = $IT_task->newFindCommand('task_instances');
$task_findCriterions = array('current_year'=>'='.$task_row->getField('completion_year'),);
foreach($task_findCriterions as $key=>$value) {
    $task_find->AddFindCriterion($key,$value);
}

fmsSetPage($task_find,'task',50); 
?>

I want to display any record that the current_year field = completion_year field.  these fields have the yyyy format.  somehow my code is not working.. any suggestions? thanks

[Whoosah]

Hi PhnMn!

I think you need to use "==" double equal in order for this to work!

/Heine

[PhanMan]

i figured it out by browsing around this forum.

Code:

<?php

$this_year = date("Y");

$task_done_find = $IT_task->newFindCommand('task_instances');
$task_done_findCriterions = array('task_id'=>'*','type'=>'Annual','completion_year'=>'=='.$this_year,);
foreach($task_done_findCriterions as $key=>$value) {
    $task_done_find->AddFindCriterion($key,$value);
}

fmsSetPage($task_done_find,'task_done',50);