0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

Kintone クエリの書き方

Posted at

すぐ忘れてしまう人(自分)へ

退職日が空欄

var paramFields = "&fields=$id," + encodeURIComponent("社員番号,氏名,在籍状況,組織選択");
  var paramQuery = "&query=" + encodeURIComponent("退職日=\"\" order by 社員番号");

社員番号で絞る

 var paramFields = "&fields=$id," + encodeURIComponent("社員番号,受講者名,開始日,終了日,研修名,研修提供会社,研修方法");
  var paramQuery = "&query=" + encodeURIComponent("社員番号=" + syainCode + "order by 社員番号");

ドロップボックスのとき

var paramFields = "&fields=$id," + encodeURIComponent("物品管理番号,必ず選択,入庫日,物品種類,購入入庫目的,廃棄日,廃棄方法");
    var paramQuery = "&query=" + encodeURIComponent("必ず選択 in (\"" + target + "\")"); //"メールアドレス=\"" + email + "\""
   
0
1
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
1

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?