Application API
    Application API
    • Development Guide
    • Filter
    • Filter Demo
    • ErrorCode
    • app
      • Get Application Information
        GET
    • worksheet
      • Create Worksheet
        POST
      • Get worksheet structure information
        POST
      • Get List
        POST
      • Create Row Record
        POST
      • Batch Create Row Records
        POST
      • Get Row Record Details
        GET
      • Get row record details
        POST
      • Update Row Record Details
        POST
      • Batch Update Row Record Details
        POST
      • Delete Row Record
        POST
      • Get associated record
        POST
      • Get Record Share Link
        POST
      • Get total row count of worksheet
        POST
      • Get Row Record Log
        POST
    • Application Role
      • Get Application Role List GET
        GET
      • Create Application Role
        POST
      • Delete Application Role
        POST
      • Add Application Role Member
        POST
      • Remove Application Role Member
        POST
      • Exit application
        POST
      • Get Role Details
        GET
    • Options Set
      • Add Option Set
      • Get Option Set
      • Edit Option Set
      • Delete Option Set
    • Get regional Information
      POST

    Filter Demo

    text#

    image.png
    [
     {
     "controlId": "630b1fba3578400b4810f745",
     "dataType": 2,
     "spliceType": 1,
     "filterType": 2,
     "value": "Zhang San"
     }
    ]

    Value#

    image.png
    [
     {
     "controlId": "630b1fba3578400b4810f767",
     "dataType": 6,
     "spliceType": 1,
     "filterType": 13,
     "value": "3"
     }
    ]

    Date/Time#

    image.png
    [
     {
     "controlId": "630b1fba3578400b4810f764",
     "dataType": 15,
     "spliceType": 1,
     "filterType": 31, "dateRange": 0,
     "dateRangeType": 3,
     "maxValue": "2025-05-03",
     "minValue": "2024-01-01"
     }
    ]

    Options#

    image.png
    [
    {
     "controlId": "630b1fba3578400b4810f75a",
     "dataType": 11,
     "spliceType": 1,
     "filterType": 26,
     "values": [ "19ee464f-0688-4866-9972-bd4a1a62d0dd"
     ]
     }
    ]

    Associated records#

    image.png
    [
     {
     "controlId": "630b1fba3578400b4810f784",
     "dataType": 29,
     "spliceType": 1,
     "filterType": 51,
     "values": [ "1e487b74-7d05-41c9-b58e-7fc846e86e8d"
     ]
     }
    ]

    Level#

    image.png
    [
     {
     "controlId": "67edf3a8c92270e474824e51",
     "dataType": 28,
     "spliceType": 1,
     "filterType": 2,
     "values": [
     "3",
     "4"
     ]
     }
    ]

    Check items#

    image.png
    [
    {
    "controlId": "67edf3961e00fbbb49b63fac",
    "dataType": 36,
    "spliceType": 1,
    "filterType": 2,
    "value": 1
    }
    ]

    Regular combination filtering#

    1.
    Text + single selection
    image.png
    [
    {
    "controlId": "630b1fba3578400b4810f745",
    "dataType": 2,
    "spliceType": 1,
    "filterType": 2,
    "value": "Zhang San"
    },
    {
    "controlId": "630b1fba3578400b4810f75a",
    "dataType": 11,
    "spliceType": 1,
    "filterType": 26,
    "values": [
    "19ee464f-0688-4866-9972-bd4a1a62d0dd"
    ] }
    ]
    Modified at 2025-04-07 08:06:02
    Previous
    Filter
    Next
    ErrorCode
    Built with