Get all filtered records

Example DB Table

smartPanda.mdh.brand

CREATE TABLE `brand`
(
    `id`       int          NOT NULL AUTO_INCREMENT,
    `name`     varchar(255) NOT NULL DEFAULT '',
    `logo`     text,
    `logo_url` varchar(255)          DEFAULT NULL,
    `website`  varchar(255)          DEFAULT NULL,
    `disabled` tinyint(1)   NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
);

Get all records according to the ID or unique identifier specified in the method name

db.schema.table.getBatchBy* Get all records that meet the conditions according to the ID or unique identifier specified in the method name and return a sorted list [].

API getBatchBy*

Example Request

{
  "method": "smartPanda.mdh.brand.getBatchById",
  "params": [1, 2, 3]
}

Example Response

[
  {
    "id": 1,
    "name": "Brand A",
    "logo": "logo_a.png",
    "logoUrl": "http://example.com/logo_a.png",
    "website": "http://example.com/brand_a",
    "disabled": 0
  },
  {
    "id": 2,
    "name": "Brand B",
    "logo": "logo_b.png",
    "logoUrl": "http://example.com/logo_b.png",
    "website": "http://example.com/brand_b",
    "disabled": 0
  },
  {
    "id": 3,
    "name": "Brand C",
    "logo": "logo_c.png",
    "logoUrl": "http://example.com/logo_c.png",
    "website": "http://example.com/brand_c",
    "disabled": 0
  }
]