“Edit Columns” in Data Types’ “Records” tab
By using the dropdown in the “add new row” plus sign, and if it’s an existing property, what will happen technically after the “submit” button being hit? Will it generate any additional column in the database? Or will it update the ReportDefinition which drives the table in the “Records” tab? Will it alert any ruleset?
Thank you.
@MichaelC16831869
When you use Edit Columns and pick an existing property, Submit only changes which fields are shown in the Records grid. It does not create any new database columns and does not alter the data type’s table schema. It also does not unlock or change any locked rulesets. The change is saved as view configuration (the list/table presentation for that data type) in your unlocked application ruleset. The Report Definition or data source that feeds the grid is not rewritten by this action; you would edit that separately if needed. If you actually need a physical column or want a property available for reporting, add the field on the Fields tab and save or optimize for reporting, which performs the schema change. For local data storage, schema changes happen only through field definitions, not through Edit Columns. For external systems, you must update the integration or RD yourself; Edit Columns won’t touch those.
@Sairohith Amazing answer. Very comprehensive, detailed, and helpful! Thank you so much.