TIM Wiki / NEW TIM 6 Documentation

Dies ist eine alte Version des Dokuments!

---

DROP VIEW IF EXISTS `view_instance`;
CREATE OR REPLACE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_instance` AS SELECT `pi`.`ID_` AS `id`,
`pi`.`NAME_` AS `name`,
`pd`.`NAME_` AS `definitionName`,
`pi`.`CLIENT_` AS `clientId`,
`pi`.`CREATION_TIME_` AS `creationTime`,
`pi`.`KEY_` AS `key`,
`pi`.`CREATION_USER_` AS `creationUserId`,
`pi`.`PROCESSDEFINITION_` AS `definitionId`,
`pi`.`DESCRIPTION_` AS `instanceDescription`,
`pi`.`CREATION_GROUP_` AS `creationGroup`,
`pi`.`END_` AS `end`,
`pi`.`ARCHIV_` AS `archiv`,
`pi`.`ARCHIVATIONUSER_ID_` AS `archivationUserID`,
`pi`.`PARENT_FOLDER_` AS `parentFolderID`,
`pi`.`ROOTTOKEN_` AS `rootToken`,
`pi`.`SUPERPROCESSTOKEN_` AS `parentProcessToken`,
`pi`.`NEXT_ESCALATIONTIME_` AS `nextEscalationTime`,
`pi`.`processVariableIndex_ID_` AS `processVariableIndexId`,
`pvi`.`field1` AS `index1`,
`pvi`.`value1` AS `value1`,
`pvi`.`field2` AS `index2`,
`pvi`.`value2` AS `value2`,
`pvi`.`field3` AS `index3`,
`pvi`.`value3` AS `value3`,
`pvi`.`field4` AS `index4`,
`pvi`.`value4` AS `value4`,
`pvi`.`field5` AS `index5`,
`pvi`.`value5` AS `value5`,
`pvi`.`field6` AS `index6`,
`pvi`.`value6` AS `value6`,
`pvi`.`field7` AS `index7`,
`pvi`.`value7` AS `value7`,
`pvi`.`field8` AS `index8`,
`pvi`.`value8` AS `value8`,
`pvi`.`field9` AS `index9`,
`pvi`.`value9` AS `value9`,
`pvi`.`field10` AS `index10`,
`pvi`.`value10` AS `value10` FROM ((`loom_processinstance` `pi` JOIN `loom_processvariableindex` `pvi` ON((`pi`.`processVariableIndex_ID_` = `pvi`.`ID_`))) JOIN `loom_processdefinition` `pd` ON((`pi`.`PROCESSDEFINITION_` = `pd`.`ID_`))) WHERE ((`pi`.`ARCHIVATIONUSER_ID_` <> 1022) AND isnull(`pi`.`SUPERPROCESSTOKEN_`));