Filter in custom view

[silviogarbes]

Hi,

I create a custom view:

SELECT movimento.*
FROM movimento
INNER JOIN chave ON chave.codigo = movimento.chave
INNER JOIN local ON local.codigo = chave.local
INNER JOIN usuario_local ON local.codigo = usuario_local.local
WHERE usuario_local.usuario = '".CurrentUserID()."'
ORDER BY movimento.horarioEntrega DESC

But the code generete:

public function getSqlWhere() // Where
{
	$where = ($this->SqlWhere <> "") ? $this->SqlWhere : "usuario_local.usuario = '\".CurrentUserID().\"'";
	$this->TableFilter = "";
	AddFilter($where, $this->TableFilter);
	return $where;
}

How can I configure for don't escape '\".CurrentUserID().\"'?

[arbei]

Do not use Custom View any more, you may use Recordset_Selecting server event, see the topic Server Events and Client Scripts in the help file.