nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Reference of Workflow(table) in the Database

ssharma48

How to find which tables (in DB) are being used for storing the Workflow data (jobComments, jobUser, WorkflowID, Date etc).

We are using TS 7.2.1

Kindly Suggest.

Find more posts tagged with

Comments

vaibhav2288

How to find which tables (in DB) are being used for storing the Workflow data (jobComments, jobUser, WorkflowID, Date etc).

We are using TS 7.2.1

Kindly Suggest.

I am not sure, but I think it is not stored into the database tables.

It's a workflow engine which keeps track of all the active workflow in the system. Once the workflow is ended, you can't get any information about the that workflow.

For getting all the workflows and each workflow information you can use following Perl libraries -

use TeamSite::WFworkflow;
use TeamSite::WFsystem;
use TeamSite::WFtask;

Thanks.....

ssharma48

and for Files i.e. for metadata. How teamsite manage \stores the data.

vaibhav2288

and for Files i.e. for metadata. How teamsite manage \stores the data.

It uses the Intelligent file system(IFS) for storing the files and metadata information into the iw-store.

ssharma48

Thanks Vaibhav

Adam Stoller

How to find which tables (in DB) are being used for storing the Workflow data (jobComments, jobUser, WorkflowID, Date etc).

We are using TS 7.2.1

Kindly Suggest.

Some of this information gets stored within the Event Subsystem DB for potential consumption by TS ReportCenter - but generally, if you're talking about an active job - the information can be extracted from the workflow system - in Perl using the modules referenced by vaibhav2288, or via CSSDK libraries / methods.