SchemaMap.Tool.SQL.Read
class SchemaMap.Tool.SQL.Read extends SchemaMap.Tool.SQL.Base
Method Inventory
Methods
The %SQL.StatementResult returned by this query is used often, and for various purposes. Among these purposes is to send an object, with certain values from a mapping table row, into the SchemaMap.Tool.Validate.Mapping:GetInfo method to calculate a new MapIssues value for the row. This is done sometimes for an existing row, and sometimes as a preview for a potential row.
To assist the preview of MapIssues for a potential row, callers can use SchemaMap.Tool.Data.Parse:FormMapResultObjectFromValues to create a %DynamicObject that has the same properties as the %SQL.StatementResult from this Map method. Note that whenever the result properties from Map change, developers should check whether FormMapResultObjectFromValues needs to be updated, or calls to GetInfo that use FormMapResultObjectFromValues could break.
This SQL query assigns names to properties in the result object that it returns. These result object property names are NOT necessarily the same as the SQL column names. Property names returned by this method are expected by the code that uses the result object. They are:
ID, Path, DataType, Cardinality, Description
Plus, for FHIR-based schemas only, these properties:
Mod, Category