列出应用/表单的数据【search】

请求示例：

https://app.redbeandata.cn/cubedrive/formData/search

http方法： POST

参数:

• @RequestBody FormDataSearchCommand command (JSON format)

content-type: application/json

{
	formId: "6671575366949146624", // Required: 表单id
	start: 0,     // Required： 数据开始
	limit: 100,   // Required： 数据条数
	scene: { // Option: 场景
	    index: 0,   // Required: 场景的序号
	    map: null   // Option: 即获取form信息时返回的varVals
	},
	criteria: {
	    $and: [
	        {"data.u524": {$regex: ".*小公募.*", $options: "si"}},
	        {"data.u8397": {$lt: "$iso8601:2021-10-30T04:00:00.000Z"}}, 
	        {"data.u8397": {$gte: "$iso8601:2021-09-27T04:00:00.000Z"}}
	    ]
	},
	"sort":{"data._weight_u5275":1,"data._weight_u8397":-1,"data.u8397”:1} // Option: 排序，这个可能实际情况中不需要
}

* criteria， scene, sort 是可选择项（option） u8397是表单查询字段的ID；这个ID在这个表单是唯一的。请到表单编辑界面查看字段的ID。Criteria的结构是基于MongoDB的查询结构，详细请看具体文档。

步骤

下面是使用步骤

• 获取系统的xAuthToken -- GET {{baseuri}}/getLogin?j_username={{username}}&j_password={{password}}
• 通过【列出我的应用】获取应用/表单id 【对应下面的formId】
• 组成 FormDataSearchCommand json数据 调用 search API

@baseuri = http://localhost:8080/cubedrive-webapp
@username= admin
@password= abcabc
@xAuthToken=bbb6c793-832c-4733-9601-a023366d918f

###
GET {{baseuri}}/getLogin?j_username={{username}}&j_password={{password}}

###
POST {{baseuri}}/formData/search
X-Auth-Token: {{xAuthToken}}
Content-Type: application/json

{
	formId: "6671575366949146624"
	start: 0
	limit: 100
	scene: {index: 0, map: null}
	criteria: {$and: [{data.u524: {$regex: ".*小公募.*", $options: "si"}}]}
}
    

返回示例

{
  "success": true,
  "totalCount": "2",
  "results": [
    {
      "id": "6677436857191501825",       // formData Id
      "data": {
        "u7317": "Health investigate2",   
        "u7269": {
          "dt": 1,
          "values": [
            "e84fdadc-9bfe-2345",
            "e84fdadc-9bfe-4a9d",
            "e84fdadc-9bfe-4a9c"
          ]
        }
      },
      "parentIds": [],
      "userId": 22,
      "author": "张/管理员",
      "createdAt": "2020-06-13 13:10:07",
      "updatedAt": "2020-06-13 13:10:07",
      "status": null,
      "version": 0,
      "tags": [],
      "topPermission": null,
      "owner": true
    },
    {
      "id": "6677436857191501824",
      "data": {
        "u6278": "annotations_gtf||i1_fastq||r1_fastq||r2_fastq||ref_genome_fasta||sample_id||tar_star_reference||whitelist",
        "u7317": "DNA convert2",
        "u5105": "1b8d32f9-17f6-49c0-911b-bf9c8c745cfe||gs://hca-dcp-sc-pipelines-test-data/alignmentReferences/optimusGencodeV27/GRCh38.primary_assembly.genome.fa||gs://hca-dcp-sc-pipelines-test-data/alignmentReferences/optimusGencodeV27/buildReference/output_bucket/star_primary_gencode_v27.tar||gs://hca-dcp-sc-pipelines-test-data/alignmentReferences/optimusGencodeV27/gencode.v27.primary_assembly.annotation.gtf.gz||gs://hca-dcp-sc-pipelines-test-data/whitelists/737K-august-2016.txt||gs://org-hca-dss-checkout-prod/bundles/0a43b2ec-f2a0-401e-aba1-db426c0fbc9a.2019-07-03T090630.607000Z/MantonCB6_HiSeq_3_S11_L003_I1_001.fastq.gz, gs://org-hca-dss-checkout-prod/bundles/0a43b2ec-f2a0-401e-aba1-db426c0fbc9a.2019-07-03T090630.607000Z/MantonCB6_HiSeq_3_S11_L004_I1_001.fastq.gz||gs://org-hca-dss-checkout-prod/bundles/0a43b2ec-f2a0-401e-aba1-db426c0fbc9a.2019-07-03T090630.607000Z/MantonCB6_HiSeq_3_S11_L003_R1_001.fastq.gz, gs://org-hca-dss-checkout-prod/bundles/0a43b2ec-f2a0-401e-aba1-db426c0fbc9a.2019-07-03T090630.607000Z/MantonCB6_HiSeq_3_S11_L004_R1_001.fastq.gz||gs://org-hca-dss-checkout-prod/bundles/0a43b2ec-f2a0-401e-aba1-db426c0fbc9a.2019-07-03T090630.607000Z/MantonCB6_HiSeq_3_S11_L003_R2_001.fastq.gz, gs://org-hca-dss-checkout-prod/bundles/0a43b2ec-f2a0-401e-aba1-db426c0fbc9a.2019-07-03T090630.607000Z/MantonCB6_HiSeq_3_S11_L004_R2_001.fastq.gz"
      },
      "parentIds": [],
      "userId": 22,
      "author": "张/管理员",
      "createdAt": "2020-06-13 13:10:07",
      "updatedAt": "2020-06-13 13:10:07",
      "status": null,
      "version": 0,
      "tags": [],
      "topPermission": null,
      "owner": true
    }
  ],
  "form": { ... },
  "locks": null
}