# datalistFromQuery에서 label, value 나눌 때 union all 적용 시 반영이 안되는 이슈

**URL:** <https://ask.selectfromuser.com/t/datalistfromquery-label-value-union-all/486>\
**Category:** 자유게시판\
**Tags:** datalistfromquery\
**Created:** [10월 1, 2025, 2:38오전 UTC](https://ask.selectfromuser.com/t/datalistfromquery-label-value-union-all/486 "2025-10-01T02:38:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![austin](https://avatars.discourse-cdn.com/v4/letter/a/77aa72/32.png) [@austin](https://ask.selectfromuser.com/u/austin)\
**Post date:** [10월 1, 2025, 2:38오전 UTC](https://ask.selectfromuser.com/t/datalistfromquery-label-value-union-all/486/1 "2025-10-01T02:38:17Z")

</div>

안녕하세요. datalistFromQuery를 활용해서 클라에 노출되는 label과 데이터로 들어가는 value를 구분해서 드롭다운 선택형으로 구현하려고 하고 있습니다. 일반적인 sql문에서는 적용이 잘 되는데, union all 사용 시 드롭다운 형태로 노출이 안되는 이슈가 있어 확인 부탁드립니다.

```auto
    - key: laundry_company_code
      group: 1
      label: 세탁 업체
      selectOptions:
        enabled: true
      datalist: true
      datalistFromQuery:
        type: query
        resource: mysql.cleanops
        sql: >
          select '전체' as 'label', 'ALL' as 'value', 0 as cnt
          union all
          select 
            rlcl.company_name as 'label', 
            rlcl.`code` as 'value',
            count(*) as cnt 
          from rental_admin_by_branch rabb
          inner join rental_laundry_company_list as rlcl
            on rabb.laundry_company_code = rlcl.code
          where 
            rlcl.status = 'ACTIVE'
            and rabb.status = 'ACTIVE'
            and rabb.email = :email
          group by 1,2
          order by 
            case when label = '전체' then 0 else 1 end,
            company_name
          ;
        params:
          - key: email
            valueFromUserProperty: "{{email}}"

```

---

<div class="post-metadata">

**Author:** ![hbkim](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/hbkim/32/23_2.png) [@hbkim](https://ask.selectfromuser.com/u/hbkim)\
**Post date:** [10월 1, 2025, 3:55오후 UTC](https://ask.selectfromuser.com/t/datalistfromquery-label-value-union-all/486/2 "2025-10-01T15:55:53Z")

</div>

안녕하세요.

이렇게 진행했을때는 되는것으로 보입니다. console 등을 봤을때 어떤 에러가 발생하시는지 알 수 있을까요?

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/selectfromuser/original/1X/56eee51e79357ab449176a3c1339673f0ed26842.png)

```yaml
    params:
      - key: laundry_company_code
        group: 1
        label: 세탁 업체
        selectOptions:
          enabled: true
        datalist: true
        datalistFromQuery:
          type: query
          resource: mysql.qa
          # sql: >
          # select 1 as label, 'a' as value, 0 as cnt
          # union all
          # select id as value, name as label, 123 as cnt from merchants limit 5
          sql: >
            select 1 as label, 'a' as value
            union all
            select 2 as label, 'b' as value

```

아울러 datalistFromQuery의 경우 기능 특성상 제약이 있을 수 있습니다.

필요하신 경우 params.searchOptions 또는 params.filterOptions 등을 이용해보셔도 좋을것 같습니다.

감사합니다.