Where on pop-up

[kinshibuya]

Hi!
How can i build a custom where clause on poupupdefs?

[eggsurplus]

In the popupMeta array you'd define a whereStatement index like:

 'whereStatement' => "account_type='Customer'" 
  

Which would limit the accounts shown in a popup to those that are only customers.

[kinshibuya]

ok. I tryed but it didnt work
here what i got:

$module_name = 'Sup_ContratoSuporte';
$_module_name = 'sup_contratosuporte';
$popupMeta = array('moduleMain' => $module_name,
						'varName' => $module_name,
						'orderBy' => $_module_name.'.name',
						'whereStatement' => "sw=1", 
						'whereClauses' => 
							array('name' => $_module_name . '.name', 
							
								),
						    'searchInputs'=> array($_module_name. '_number', 'name', 'priority','status','vencido_com_aditivo_c'),
							'listview' => 'modules/' . $module_name. '/metadata/listviewdefs.php',
							'search'   => 'modules/' . $module_name . '/metadata/searchdefs.php',
							
						);
?>

where sw is my ckeck box field