SEARCHSQL
The SEARCHSQL table designates a SQL statement to be used in a search transaction.
This table is used by the following functional feature.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| SEARCH_SQL_ID | The primary key to uniquely identify the search SQL record. | BIGINT | Not Null | Yes |
| INPUT_CLASS | The fully qualified name of the input search class for the search transaction that should use this searchsql. For example: com.dwl.tcrm.coreParty.search. TCRMPersonSearchInput. | VARCHAR(255) | Not Null | No |
| SQL_STATEMENT_ID | The SQLSTATEMENT table primary key. | BIGINT | Not Null | No |
| DESCRIPTION | A textual description of this search SQL. | VARCHAR(255) | Null | No |
| PROCESSOR_CLASS | The fully qualified name of the resultset processor class which will handle the results of this SQL. For example: com.dwl.tcrm.coreParty.component. TCRMPersonSearchResultProcessor. | VARCHAR(255) | Not Null | No |
| ACTIVE_IND | Designates whether this SQL is active. Only active SQLs are considered. Use 'Y' for active, 'N' for otherwise. | CHAR(1) | Not Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| ROW_HANDLER_CLASS | The fully qualified name of the row handler class which will handle the results of this SQL. For example, "com.dwl.tcrm.coreParty.component.TCRMPersonSearchRowHandler". | VARCHAR(255) | Null | No |