Data de postagem: May 18, 2010 8:59:27 PM
includeOnce -1897036629 /* /products/INTEQerp infrastructure/library/iQuery/IQuery.ijs */
var solicitacao = IQuery.from( -1897052056 /* Solicitações */ )
.where([
{ field: "CHAVE", operator: "=", value: 1 },
{ field: "VERSAO", operator: "?=", value: null } //O operador ?= com o valor null faz com que esta clausula seja ignorada.
])
.column("CHAVE")
solicitacao.toSql()
SQL Gerado:
select SOLICITACAO1.CHAVE
from SOLICITACAO SOLICITACAO1
where (
SOLICITACAO1.CHAVE = 1)
and (
SOLICITACAO1.CLASSE in (-1897052056,-1897052055,-1897052054,-1897051938,-1897050453,-1897048578,
-1897048577,-1894825103,3930906,35041724))