define criteria in query ?

[pasgou13]

Hello,

this is a noob question :-)

I want to view in the case module, when i am on default view, only the case who arenew or assigned. I have search in some files, but i dont know how do it .

Could someone tell me where i can change this ?

thankx

Pasgou

[kbrill]

Not exactly sure what you are asking. Is this something that you cannot do with the search pane at the top?

[pasgou13]

Hello Kbrill,

Not on the search criteria, but when i am on cases home. I just want to see on cases home, the cases that r open, or assigned or anything else except closed.

Du u see what i mean ?

regards

Pasgou

[pasgou13]

I try this but seem to be not good because i can t see them in advanced search .

if(isset($_REQUEST['query']))
{
// we have a query
// first save columns
$current_user->setPreference('ListViewDisplayColumns', $displayColumns, 0, $currentModule);
$searchForm->populateFromRequest(); // gathers search field inputs from $_REQUEST
$where_clauses = $searchForm->generateSearchWhere(true, "Cases"); // builds the where clause from search field inputs
//pascal
array_push($where_clauses, "(cases.status <> 'Closed')");
//end pascal
if (count($where_clauses) > 0 )$where = implode(' and ', $where_clauses);
$GLOBALS['log']->info("Here is the where clause for the list view: $where");
}

Heeeelp !

[pasgou13]

Can somebody said what it s wrong ..? pleeeeeease :-)