코드와 레이블 모두 검색합니다.

- path: properties/active
  blocks:
  - type: query
    resource: mysql.qa
    sqlType: select
    sql: >
      SELECT * 
      FROM properties 
      WHERE (LENGTH(:type) = 0 OR `type` = :type)
      ORDER BY id ASC 
      LIMIT 100
    params:
    - key: type
      label: 분류코드
      ***datalist: 
      - value: A000
        label: 분류1
      - value: A002
        label: 분류2***

- path: properties/active
  blocks:
  - type: query
    resource: mysql.qa
    sqlType: select
    sql: >
      SELECT * 
      FROM properties 
      WHERE (LENGTH(:type) = 0 OR `type` = :type)
      ORDER BY id ASC 
      LIMIT 100
    params:
    - key: type
      label: 분류코드
      ***datalist: true
      datalistFromQuery: 
        type: query
        resource: mysql.qa
        sql: SELECT DISTINCT `type` FROM properties***

https://embed.notionlytics.com/wt/ZXlKd1lXZGxTV1FpT2lKa1ltSmlNRFExWWpWaFlUWTBZMkk1WW1ZeVpqaGlaVFl3TXpCbU9HVXhOQ0lzSW5kdmNtdHpjR0ZqWlZSeVlXTnJaWEpKWkNJNkluTjBTMFZXVUV0aE9FUkRibUY1TkRSUmVGVTJJbjA9