Column Name : DataType | Note |
ID : Integer | The Primary Key for the Table which then gets propagated down to each CORTICON_ADC_READ_DEFS record. |
NAME : String | A logical name that you want to associated with this CORTICON_ADC_READ. This is the name that will be specified inside of each Service Call-out's Runtime Properties tab for the appropriate Query Name. |
ADDTOPAYLOAD : String (true or false) | Controls whether all data retrieved from the read will be added to the response payload. If this value is null or any value other than true, the default value is false. |
Column Name : DataType | Note |
ID : Integer | The Primary Key for the Table. |
READ_ID : Integer (required) | Foreign Key back to CORTICON_ADC_READ.ID column. There can be many CORTICON_ADC_READ_DEFS associated with a CORTICON_ADC_READ record. |
SEQUENCE : Integer (required) | The integer value that specifies the order of execution of each CORTICON_ADC_READ_DEFS within a given CORTICON_ADC_READ_ID. |
SQL : String (required) | An SQL Statement, a template to be used for the current CORTICON_ADC_READ_DEFS operation. |
PRIMARY_ENTITY : String (required) | The Corticon Entity to which the SQL statement will map. |
PARENT_ENTITY : String and PARENT_ROLENAME : String (optional) | The values needed to create an Association between the Parent Entity (PARENT_ENTITY) to the Target Entity (PRIMARY_ENTITY) through Association Role Name (PARENT_ROLENAME). |
ENABLE : String (true or false) | Suppresses or allows the CORTICON_ADC_READ_DEFS to execute. If this value is null or any value other than false, the default value is true. |