Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
Clear All
new posts

    simple criteria with array value

    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())
    Last edited by claudiobosticco; 24 Sep 2020, 07:05.

    #2
    That kind of criteria can come from
    an apparently empty multiple:true FormItem in a SearchForm, so it needs to be treated as a blank criteria that doesn’t affect results.

    Comment


      #3
      thanks for the clarification

      Comment

      Working...
      X