- type: query
  resource: mysql.qa
  sqlType: select
  sql: >
    SELECT id, fullname AS '예약자명',
      CONCAT(LEFT(phone_primary,3), '****', RIGHT(phone_primary,4)) AS '연락처',
      DATE_FORMAT(visitdate, '%Y-%m-%d') AS '체크인',
      memo AS '메모'
    FROM customer 
    WHERE workspace_id = 12 LIMIT 10
  selectOptions: 
    enabled: true
  actions:
  - type: query
    label: 메모
    resource: mysql.qa
    sqlType: update
    sql: >
      UPDATE customer 
      SET memo = :memo
      WHERE id IN (0, :...ids)
    params:
    - key: ids
      valueFromSelectedRows: true
      valueFromSelectedRowsAs: id
    - key: memo
      valueFromPrompt: true

참고

모달 팝업 - 조회/수정 살펴보기