# Class ProcessInstanceTree

OptimaJet.Workflow.SQLite.ProcessInstanceTree

Database object for querying the process instance tree hierarchy.

Namespace: [OptimaJet.Workflow.SQLite](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/)

```csharp
public class ProcessInstanceTree : DbObject<ProcessInstanceTreeItem>
```

## Type Hierarchy

-   [DbObject<ProcessInstanceTreeItem>](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/DbObject-TEntity/)
    -   ProcessInstanceTree Current type

## Constructors

`public ProcessInstanceTree(string schemaName, int commandTimeout)` 

Initializes a new instance of [ProcessInstanceTree](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/ProcessInstanceTree/).

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `schemaName` | `String` | The database schema name. |
| `commandTimeout` | `Int32` | The command timeout in seconds. |

## Methods

`public Task<List<IProcessInstanceTreeItem>> GetProcessTreeItemsByRootProcessId(SqliteConnection connection, Guid rootProcessId)` 

Retrieves all process instance tree items for the specified root process.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `rootProcessId` | `Guid` | The root process identifier. |

### Returns

| Type | Description |
| --- | --- |
| `Task<IProcessInstanceTreeItem>` | A list of process instance tree items. |

[Previous FileSchemePersistenceSqliteProvider](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/FileSchemePersistenceSqliteProvider/) [Next SqliteProvider](https://api.workflowengine.io/sqlite/OptimaJet.Workflow.SQLite/SqliteProvider/)