PLINKFEED
검색ꡬ독
DATABASEΒ·μ€‘μš”λ„ 6Β·2026. 05. 29.Β·Dev.to

πŸ”Ž Build Dynamic SQL Filters for Joget Reports with BeanShell

── KO ──────────────────

Joget λ³΄κ³ μ„œλ₯Ό μœ„ν•œ 동적 SQL ν•„ν„° κ΅¬ν˜„ 방법 μ•ˆλ‚΄.

이 κΈ€μ—μ„œλŠ” Jogetμ—μ„œ 동적 SQL ν•„ν„°λ₯Ό μƒμ„±ν•˜λŠ” 방법을 μ„€λͺ…ν•©λ‹ˆλ‹€. BeanShell νŒ¨ν„΄μ„ ν™œμš©ν•˜μ—¬ ν•„ν„° 값을 읽고, μ•ˆμ „ν•œ νŒŒλΌλ―Έν„°ν™”λœ SQL 쿼리λ₯Ό κ΅¬μΆ•ν•˜λ©°, μƒνƒœλ³„λ‘œ λ ˆμ½”λ“œλ₯Ό κ·Έλ£Ήν™”ν•˜κ³  κ²°κ³Όλ₯Ό λ³΄κ³ μ„œ ν…Œμ΄λΈ”μ— κΈ°λ‘ν•˜λŠ” 과정을 λ‹€λ£Ήλ‹ˆλ‹€. 이 κΈ°μˆ μ€ 차트, 데이터 리슀트 및 λ³΄κ³ μ„œ ν”ŒλŸ¬κ·ΈμΈμ΄ κ°„λ‹¨ν•œ ν…Œμ΄λΈ”μ—μ„œ 데이터λ₯Ό κΈ°λŒ€ν•  λ•Œ μœ μš©ν•©λ‹ˆλ‹€.

── EN ──────────────────

Guide on implementing dynamic SQL filters for Joget reports.

This article explains how to create dynamic SQL filters in Joget using a BeanShell pattern. It details the process of reading filter values, building a safe parameterized SQL query, grouping records by status, and writing the summarized results into a reporting table. This technique is useful when charts, data lists, and report plugins expect data from a simple table.

원문 보기 β†’λͺ©λ‘μœΌλ‘œ