Dealing with data which includes a field having an array of strings

2 Answers 75 Views

Data Query

nodsec asked on 17 Aug 2022, 07:42 AM

Does exists any operator, which is able to filter all data values, where "X includes 1" ?

<script>
var dataSource = new kendo.data.DataSource({
  data: [
    { name: "Jane Doe", birthday: new Date(1983, 1, 1), x: [1, 2]},
    { name: "John Doe", birthday: new Date(1980, 1, 1), x: [2, 3]}
  ],
  filter: { field: "x", operator: "eq", value: 1 }
});
dataSource.fetch(function(){
  var view = dataSource.view();
/* The result can be observed in the DevTools(F12) console of the browser. */
  console.log(view.length); // displays "1"
/* The result can be observed in the DevTools(F12) console of the browser. */
  console.log(view[0]); // displays "Jane Doe"
});
</script>

Thanks a lot for an each help :-)

2 Answers, 1 is accepted

0

Accepted

answered on 17 Aug 2022, 09:20 AM

Solution: use operator: "contains" with "ignoreCase:false":

<script>
var dataSource = new kendo.data.DataSource({
  data: [
    { name: "Jane Doe", birthday: new Date(1983, 1, 1), x: ["aaa", "bbb"]},
    { name: "John Doe", birthday: new Date(1980, 1, 1), x: ["bbb", "ccc"]}
  ],
  filter: { field: "x", operator: "contains", value: "bbb", ignoreCase: false }
});
dataSource.fetch(function(){
  var view = dataSource.view();
/* The result can be observed in the DevTools(F12) console of the browser. */
  console.log(view.length); // displays "1"
/* The result can be observed in the DevTools(F12) console of the browser. */
  console.log(view[0]); // displays "Jane Doe"
});
</script>

Thanks a lot for an each help :-)

0

Tags

Data Query

Asked by

Answers by