Attribute

DefaultQueryOptions (dqo)

Purpose

Specifies a semicolon-separated list of parameters that are used as default filter values (Where clauses) for SQL queries. This option is not mandatory. The driver uses the defined filters for SQL queries when needed. If a required condition is not present, the driver reports the following error: "No URI could satisfy the request on the table schema_name.table_name. Supply one of the following sets of criteria filter_name/."

Valid Values

string

where:

string

is the following set of parameters and default filter values that you want to apply to SQL queries. You can specify any combination of these name-value pairs for these filters.

DefaultQueryOptions=(orgName=org_name;userName=user_name;repoName=repo_name ;projectId=project_id;columnId=column_id)

where:

org_name

is the organization name that you want to use as a default query filter. Organizations are shared accounts that allow members to collaborate across multiple projects at once.

user_name

is the user name (identity) value that you want to use as a default query filter.

repo_name

is the repository name that you want to use as a default query filter. Repositories contain the project files.

project_id

is the project ID that you want to use as a default query filter. You can get the project ID (projectID) from the Projects table.

column_id

is the column ID for project board columns that you want to use as a default query filter. You can get the column ID (columnID) from the ProjectColumns table.

Notes

  • A Where clause used in a SQL query overrides the DefaultQueryOptions passed in a connection URL.

Default Value

No default value

Data Type

String