Page History
The setfinder query definition and the analysis plug-in definition information is stored in the QT_QUERY_MASTER table.
QT_QUERY_MASTER |
|
|
| |||
Key | Column Name | Column Definition | Nullable? | |||
PK | QUERY_MASTER_ID | Unique id for the query | NO | |||
| NAME | Name of the query | NO | |||
| USER_ID | The user's login id | NO | |||
| GROUP_ID | The project id | NO | |||
| MASTER_TYPE_IDCD | If it is a setfinder query this field will be empty. | YES | |||
| PLUGIN_ID | No used in the setfinder query | YES | |||
| GENERATED_SQL | The database SQL transformation of the query definition. | YES | |||
| REQUEST_XML | The query definition part of the request xml | YES | |||
| I2B2_REQUEST_XML | The full request xml including the i2b2 header | NO | |||
| PM_XML | The full request for from the PM cell | YES | |||
| CREATE_DATE | Date that the request was created | YES | |||
| DELETE_DATE | Date that the request was deleted | YES | |||
| DELETE_FLAG | Y/N if the query is deleted | YES |
...