Como fazer para desabilitar o filtro por classes filhas nas cláusulas where's de classe?

Data de postagem: Aug 06, 2010 6:49:28 PM

A propriedade disableGetChildren permite definir se as chaves das classes filhas da classe informada para o iQuery serão adicionadas a cláusula 'WHERE' da query gerada. Por default a propriedade está definida como 'false' e não precisa ser incluída na chamada do método where.

O exemplo abaixo por ser executado no iDBSql para efeito de testes:

includeOnce -1897036629 /* /products/INTEQengine/library/iquery/IQuery.ijs */

var iquery = IQuery.from( -2007890000 )

.where({field: "CLASSE", operator: "=", value: -2007890000, disableGetChildren: false})

.column({field: "CODIGO"})

iquery.toSql()

O SQL gerado através do método 'toSql' do objeto 'iQuery' será este:

select ENTIDADE1.CODIGO

from ENTIDADE ENTIDADE1

where (

(ENTIDADE1.CLASSE in (-2007890000,-2007889000,-2007888900,-2007888000,-2007887900,-2007887800,-2007887000,-2007886900,-2007886800,-2007886000,-1899999395,-1899998273,-1899997888,-1899933495,-1898188410,-1898188236,-1897054262,-1897054250,-1897053171,-1897052489,-1897052488,-1897050888,-1897050838,-1897050521,-1897049480,-1897047849,-1897047848,-1897047846,-1897037640,-1897037639,-1897037637,-1897037359,-1896048403,-1896048402,-1896047400,-1895836240,-1894835183,-1894443367,106,107,108,109,110,111,112,114,1923,9865,49345,49346,49347,49348,51558,51559,170257,

173007,173903,176413,178443,182979,185219,187746,188040,188356,278346,278347,278348,315481,332590,

399529,403627,523559,3742881,3742891,3800974,4141089,4310828,12407575,36230299,39018029,39018048,

40160535,43614400,43616000,44840991)))

and (

(ENTIDADE1.CLASSE in (-2007890000,-2007889000,-2007888900,-2007888000,-2007887900,-2007887800,-2007887000,-2007886900,-2007886800,-2007886000,-1899999395,-1899998273,-1899997888,-1899933495,-1898188410,-1898188236,-1897054262,-1897054250,-1897053171,-1897052489,-1897052488,-1897050888,-1897050838,-1897050521,-1897049480,-1897047849,-1897047848,-1897047846,-1897037640,-1897037639,-1897037637,-1897037359,-1896048403,-1896048402,-1896047400,-1895836240,-1894835183,-1894443367,106,107,108,109,110,111,112,114,1923,9865,49345,49346,49347,49348,51558,51559,170257,-173007,173903,176413,178443,182979,185219,187746,188040,188356,278346,278347,278348,315481,332590,-399529,403627,523559,3742881,3742891,3800974,4141089,4310828,12407575,36230299,39018029,39018048,-40160535,43614400,43616000,44840991)))

Para desabilitar a busca nas classes filhas basta configurar a propriedade pra 'true':

includeOnce -1897036629 /* /products/INTEQengine/library/iquery/IQuery.ijs */

var iquery = IQuery.from( -2007890000 )

.where({field: "CLASSE", operator: "=", value: -2007890000, disableGetChildren: true})

.column({field: "CODIGO"})

iquery.toSql()

O SQL gerado através do método 'toSql' do objeto 'iQuery' será este:

select ENTIDADE1.CODIGO

from ENTIDADE ENTIDADE1

where (

ENTIDADE1.CLASSE = -2007890000)

and (

ENTIDADE1.CLASSE in (

-2007890000,-2007889000,-2007888900,-2007888000,-2007887900,-2007887800,-2007887000,

-2007886900,-2007886800,-2007886000,-1899999395,-1899998273,-1899997888,-1899933495,

-1898188410,-1898188236,-1897054262,-1897054250,-1897053171,-1897052489,-1897052488,

-1897050888,-1897050838,-1897050521,-1897049480,-1897047849,-1897047848,-1897047846,

-1897037640,-1897037639,-1897037637,-1897037359,-1896048403,-1896048402,-1896047400,

-1895836240,-1894835183,-1894443367,106,107,108,109,110,111,112,114,1923,9865,49345,49346,

49347,49348,51558,51559,170257,173007,173903,176413,178443,182979,185219,187746,188040,

188356,278346,278347,278348,315481,332590,399529,403627,523559,3742881,3742891,3800974,

4141089,4310828,12407575,36230299,39018029,39018048,40160535))