| | | Supreme Being
       
Group: Forum Members Last Login: 2 days ago @ 4:42 AM Posts: 59, Visits: 154 |
| | Hello In wich table stored Workflow Acivities Details such as Timeout for Activity, Actors and other? Thanks |
| | | | Supreme Being
       
Group: Forum Members Last Login: Thursday, April 10, 2008 Posts: 23, Visits: 38 |
| | Hi Jimmilee, You will be able to get the details of Skelta Tables from the Skelta Help File. Please search for Database quick reference in help file, you will get the details. Skelta BPM.Net 2007 help files are available for download from the Skelta Website, you can access the link at the product download page. Regards RSimon |
| | | | Supreme Being
       
Group: Forum Members Last Login: 2 days ago @ 4:42 AM Posts: 59, Visits: 154 |
| | I read help but didn't find this information |
| | | | Supreme Being
       
Group: Forum Members Last Login: Thursday, April 10, 2008 Posts: 23, Visits: 38 |
| | Hi These details can be obtained from a combination of tables and the main tables involved are, SWExecute | This table stores information about the workflows that are executed. From this table, the total number of workflows that are instantiated can be determined. It also gives the execution status of the workflow like Finished (FN), Sleep Mode (SL), Execution Finished with Error (FE) etc. | SWExecutionDetails | This table stores information about the activities, their links, status etc. that are involved in a particular execution. It may have resource dependant activities like Approval, Information, Checklist etc. or resource independent actions like Email, Script etc. This table has a collection of instances of activities that are triggered. |
SKWorkItem | This table stores details about the Tasks assigned to an actor |
Regards, RS |
| | | | Supreme Being
       
Group: Forum Members Last Login: 2 days ago @ 4:42 AM Posts: 59, Visits: 154 |
| | This details I already see But I need to obtain information about timeouts in workflow template I found it only in "swstaginglong" table and only in xml format - <property name="Timeout for Acknowledgement"> - <property name="Timeout warning for Action"> - <property name="Timeout for Action"> - <![CDATA[ 0.00:01:00 ]]> Can I obtain it with another methods? |
| | | | Supreme Being
       
Group: Forum Members Last Login: Thursday, April 10, 2008 Posts: 23, Visits: 38 |
| | Hi, The column 'TimeOutData' in table SKHWSActivity stores the timeout data whose details can be obtained from table SWTaskList Regards, RS |
| | | | Supreme Being
       
Group: Forum Members Last Login: 2 days ago @ 4:42 AM Posts: 59, Visits: 154 |
| | Activity "Approve1" with TimeOut exists in table "SKHWSActivity" "TimeOutData" Field: <timeoutdata><timeout taskid="22" timeouttype="MULTIPLEACTIVITYWARNINGTIMEOUT" /></timeoutdata> But "SWTaskList" Table has no rows |
| | | | Supreme Being
       
Group: Forum Members Last Login: Thursday, April 10, 2008 Posts: 23, Visits: 38 |
| | Hi, Mutiple Time Out warning is stored in a combination of two tables, SKMultipleTimeoutWarning and SWTaskList. Regards, RS |
| |
|
|