# Class WorkflowProcessTransitionHistory

OptimaJet.Workflow.SQLite.WorkflowProcessTransitionHistory

Database object for workflow process transition history operations.

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

```csharp
public class WorkflowProcessTransitionHistory : DbObject<ProcessTransitionHistoryEntity>
```

## Type Hierarchy

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

## Constructors

`public WorkflowProcessTransitionHistory(string schemaName, int commandTimeout)` 

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

### Parameters

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

## Methods

`public Task<int> DeleteByProcessIdAsync(SqliteConnection connection, Guid processId, SqliteTransaction transaction = null)` 

Deletes all transition history records for the specified process.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `processId` | `Guid` | The process identifier. |
| `transaction` | `SqliteTransaction` | An optional transaction. |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` | The number of rows affected. |

`public Task<ProcessTransitionHistoryEntity[]> SelectByProcessIdAsync(SqliteConnection connection, Guid processId, Paging paging = null)` 

Selects transition history records for the specified process, sorted by transition time descending.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `processId` | `Guid` | The process identifier. |
| `paging` | `Paging` | The paging settings, or `null` to return all records. |

### Returns

| Type | Description |
| --- | --- |
| `Task<ProcessTransitionHistoryEntity[]>` | An array of transition history entities. |

`public Task<ProcessTransitionHistoryEntity[]> SelectByIdentityIdAsync(SqliteConnection connection, string identityId, Paging paging = null)` 

Selects transition history records for the specified identity, sorted by transition time descending.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `identityId` | `String` | The identity identifier. |
| `paging` | `Paging` | The paging settings, or `null` to return all records. |

### Returns

| Type | Description |
| --- | --- |
| `Task<ProcessTransitionHistoryEntity[]>` | An array of transition history entities. |

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