SmartClient Version: v12.1p_2020-09-23/Enterprise Deployment (built 2020-09-23)
Hello, I just noticed that a simple criteria like {id:[]} produces a '1'='1' in SQL where clause (both expressed in js and server side).
Is it intended that it doesn't produce a id is null as would this js criteria: {fieldName:"id", operator:"inSet", value:[]} ?
Or a '0' = '1' as server side : dsRequest.setCriteriaValue("ID_REC", DataTools.buildList())
Hello, I just noticed that a simple criteria like {id:[]} produces a '1'='1' in SQL where clause (both expressed in js and server side).
Is it intended that it doesn't produce a id is null as would this js criteria: {fieldName:"id", operator:"inSet", value:[]} ?
Or a '0' = '1' as server side : dsRequest.setCriteriaValue("ID_REC", DataTools.buildList())
Comment