复选框怎么设置筛选格式

阅读次数 79
let file = KSDrive.openFile("https://www.kdocs.cn/l/**")
//筛选本周课表数据
  let all = []
  let offset = null;
  while (all.length === 0 || offset) {
    let records = file.Application.Record.GetRecords({
      SheetId: 9,
      ViewId: 'BI',
      Offset: offset,
      Filter: {
      mode: 'AND',
      criteria: [
        {"field": "发送签到","op": "Equals","values":[true]},
        {"field": "日期","op": "Less","values": [
         {
          "dynamicType": "today",
          "type": "DynamicSimple"
          }]}
      ]
    }
    })
    offset = records.offset
    all = all.concat(records.records)
  }
  file.close()
console.log(all)

"发送签到"是复选框我的"values":[true]}怎么设置格式

1 Answers

解决了是

 {"field": "发送签到","op": "Equals","values":["1"]},