uc-apx create region chart

Insert a new chart region with one or more SQL-backed series.

Supported —chart-type values (v1, label/value column mapping only): area, bar, line — cartesian charts (axis x + axis y emitted) pie, donut — radial charts (no axis blocks)

—series is repeatable; each value is a semicolon-separated key=value list with required keys name, label, value, sql and optional id. The sql= key must come LAST and slurps to end-of-arg so SQL with ; or , round-trips intact. Example:

—series ‘name=Acme;label=PRODUCT_NAME;value=QUANTITY;sql=select product_name, quantity from sales where customer = ”Acme'''

Series are emitted in flag order with execution.sequence 10, 20, 30, ….

Usage

uc-apx create region chart [flags]

Flags

Flag	Type	Default	Description
--chart-type	string		Chart type: area, bar, donut, line, pie [required]
--column-span	int		12-col grid span for the region’s layout (0 = omit; e.g. 6 for a half-width chart)
--dry-run			Print rendered region to stdout without writing
--force			Reserved for future use
--id	string		Region id (default: kebab-case of —name)
--name	string		Display name of the region [required]
--page	string		Target page (numeric ID, alias, or name) [required]
--sequence	int		Layout sequence (default: max existing + 10)
--series	stringArray		Repeatable series spec: ‘name=…;[id=…;]label=COL;value=COL;sql=<SQL>’ (sql must be last). At least one —series is required.
--slot	string	body	Page slot to place the region in

Global Flags

Flag	Type	Default	Description
--app-dir	string	.	Path to the APEX application directory
--json-pretty			Output in pretty-printed JSON (human-readable) instead of minified JSON
--toon			Output in TOON format (human-readable, token-efficient) instead of JSON

Example Generated APEXlang

Using --dry-run to preview the generated construct (no files are written):

uc-apx --app-dir examples/brookstrut create region chart --page 46 --name Sales Chart --chart-type bar --series name=Sales;label=STORE_NAME;value=TOTAL;sql=select store_name, sum(quantity) as total from oow_demo_sales_history group by store_name --dry-run

Generated APEXlang

region sales-chart (
        name: Sales Chart
        type: chart
        layout {
            sequence: 50
            slot: body
        }
        appearance {
            template: @/standard
            templateOptions: #DEFAULT#
        }
        chart {
            type: bar
        }

        series sales (
            name: Sales
            execution {
                sequence: 10
            }
            source {
                type: sqlQuery
                sqlQuery:
                    ```sql
                    select store_name, sum(quantity) as total from oow_demo_sales_history group by store_name
                    ```
            }
            columnMapping {
                label: STORE_NAME
                value: TOTAL
            }
        )

        axis x (
            name: x
        )

        axis y (
            name: y
        )
    )