uc-apx create region classic-report

Insert a new classic-report region backed by an inline SQL query.

The CLI only scaffolds the sqlQuery shape (source { location: localDatabase, type: sqlQuery, sqlQuery: ``` ... ``` }). Author the SELECT yourself — including any WHERE / ORDER BY / joins.

Usage

uc-apx create region classic-report [flags]

Flags

Flag	Type	Default	Description
--column	string		Comma-separated columns. Syntax: NAME[:TYPE[:LENGTH]]. TYPE ∈ varchar2 (default), number, date, timestamp, clob. At least one column is required [required]
--column-span	int		12-col grid span for the region’s layout (0 = omit; e.g. 6 for a half-width region)
--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)
--slot	string	body	Page slot to place the region in
--sql	string		Inline SQL query (or @path/to/file.sql to read from disk; @@ escapes a literal leading @) [required]

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 classic-report --page 46 --name Product List --sql select product_id, product_name from oow_demo_products --column PRODUCT_ID:number,PRODUCT_NAME:varchar2:100 --dry-run

Generated APEXlang

region product-list (
        name: Product List
        type: classicReport
        source {
            location: localDatabase
            type: sqlQuery
            sqlQuery:
                ```sql
                select product_id, product_name from oow_demo_products
                ```
        }
        layout {
            sequence: 50
            slot: body
        }
        appearance {
            template: @/standard
            templateOptions: #DEFAULT#
        }
        componentAppearance {
            template: @/standard
            templateOptions: #DEFAULT#
        }
        pagination {
            type: rowRangesXToYNoPagination
        }
        messages {
            whenNoDataFound: No data found
        }

        column PRODUCT_ID (
            reportColumnQueryId: 1
            derivedColumn: N
            heading {
                heading: Product Id
                alignment: end
            }
            layout {
                sequence: 10
                columnAlignment: end
            }
        )

        column PRODUCT_NAME (
            reportColumnQueryId: 2
            derivedColumn: N
            heading {
                heading: Product Name
            }
            layout {
                sequence: 20
            }
        )
    )