# Class WorkflowGlobalParameter

OptimaJet.Workflow.SQLite.WorkflowGlobalParameter

Database object for workflow global parameter operations.

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

```csharp
public class WorkflowGlobalParameter : DbObject<GlobalParameterEntity>
```

## Type Hierarchy

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

## Constructors

`public WorkflowGlobalParameter(string schemaName, int commandTimeout)` 

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

### Parameters

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

## Methods

`public Task<GlobalParameterEntity[]> SelectByTypeAndNameAsync(SqliteConnection connection, string type, string name = null, Sorting sort = null, string tenantId = null)` 

Selects global parameters by type with optional name filter, sorting, and tenant scope.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `type` | `String` | The parameter type. |
| `name` | `String` | The exact parameter name to filter by, or `null` for all names. |
| `sort` | `Sorting` | The sorting settings, or `null` for default order. |
| `tenantId` | `String` | The tenant identifier, or `null` for shared parameters. |

### Returns

| Type | Description |
| --- | --- |
| `Task<GlobalParameterEntity[]>` | An array of matching global parameter entities. |

`public Task<GlobalParameterEntity[]> SearchByTypeAndNameWithPagingAsync(SqliteConnection connection, string type, string name = null, Paging paging = null, Sorting sort = null, string tenantId = null)` 

Searches global parameters by type with a partial name match, paging, and tenant scope.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `type` | `String` | The parameter type. |
| `name` | `String` | A partial name to search for, or `null` for all names. |
| `paging` | `Paging` | The paging settings, or `null` to return all results. |
| `sort` | `Sorting` | The sorting settings, or `null` for default order. |
| `tenantId` | `String` | The tenant identifier, or `null` for shared parameters. |

### Returns

| Type | Description |
| --- | --- |
| `Task<GlobalParameterEntity[]>` | An array of matching global parameter entities. |

`public Task<int> GetCountByTypeAndNameAsync(SqliteConnection connection, string type, string name = null, string tenantId = null)` 

Returns the count of global parameters matching the specified type, optional name, and tenant scope.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `type` | `String` | The parameter type. |
| `name` | `String` | A partial name to filter by, or `null` for all names. |
| `tenantId` | `String` | The tenant identifier, or `null` for shared parameters. |

### Returns

| Type | Description |
| --- | --- |
| `Task<Int32>` | The number of matching parameters. |

`public Task<int> DeleteByTypeAndNameAsync(SqliteConnection connection, string type, string name = null, string tenantId = null)` 

Deletes global parameters matching the specified type, optional name, and tenant scope.

### Parameters

| Name | Type | Description |
| --- | --- | --- |
| `connection` | `SqliteConnection` | The SQLite connection. |
| `type` | `String` | The parameter type. |
| `name` | `String` | The exact parameter name to filter by, or `null` for all names. |
| `tenantId` | `String` | The tenant identifier, or `null` for shared parameters. |

### Returns

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

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