stockbase_webui.command_with_line_count

Add record

No data

Error in query number 7

We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

In "dwui/table/stockbase_webui.command_with_line_count.sql": Failed to set variable records_count: In "dwui/table/stockbase_webui.command_with_line_count.sql": The following error occurred while executing an SQL statement:
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: 42501, Native error: 1, Message: ERROR: permission denied for view command_with_line_count;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM stockbase_webui.command_with_line_count WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'uuid')::UUID = uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'title')::"varchar" = title) AND ((CAST(? AS TEXT)::JSONB) ->> 'description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'description')::"varchar" = description) AND ((CAST(? AS TEXT)::JSONB) ->> 'functional' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'functional')::INT8 = functional) AND ((CAST(? AS TEXT)::JSONB) ->> 'documentation' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'documentation')::"varchar" = documentation) AND ((CAST(? AS TEXT)::JSONB) ->> 'profession_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'profession_uuid')::UUID = profession_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'order_nr')::INT8 = order_nr) AND ((CAST(? AS TEXT)::JSONB) ->> 'line_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'line_count')::INT8 = line_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'key' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'key')::"varchar" = key)))
dwui/table/stockbase_webui.command_with_line_count.sql: line 48
dwui/table/stockbase_webui.command_with_line_count.sql: line 48

Backtrace

Failed to set variable records_count

In "dwui/table/stockbase_webui.command_with_line_count.sql": The following error occurred while executing an SQL statement:
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: 42501, Native error: 1, Message: ERROR: permission denied for view command_with_line_count;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM stockbase_webui.command_with_line_count WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'uuid')::UUID = uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'title')::"varchar" = title) AND ((CAST(? AS TEXT)::JSONB) ->> 'description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'description')::"varchar" = description) AND ((CAST(? AS TEXT)::JSONB) ->> 'functional' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'functional')::INT8 = functional) AND ((CAST(? AS TEXT)::JSONB) ->> 'documentation' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'documentation')::"varchar" = documentation) AND ((CAST(? AS TEXT)::JSONB) ->> 'profession_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'profession_uuid')::UUID = profession_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'order_nr')::INT8 = order_nr) AND ((CAST(? AS TEXT)::JSONB) ->> 'line_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'line_count')::INT8 = line_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'key' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'key')::"varchar" = key)))
dwui/table/stockbase_webui.command_with_line_count.sql: line 48

Note: You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.