stockbase.count_checked_commandline

Add record

This view shows the grouped words joined to a commandline. Note that this should still be checked with a empty cell learning.
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.count_checked_commandline.sql": Failed to set variable records_count: In "dwui/table/stockbase.count_checked_commandline.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 table commandline;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM stockbase.count_checked_commandline 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) ->> 'command_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'command_uuid')::UUID = command_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'source' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'source')::"varchar" = source) AND ((CAST(? AS TEXT)::JSONB) ->> 'min_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'min_count')::INT8 = min_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'max_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'max_count')::INT8 = max_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'notice_description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'notice_description')::"varchar" = notice_description) AND ((CAST(? AS TEXT)::JSONB) ->> 'match_description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'match_description')::"varchar" = match_description) AND ((CAST(? AS TEXT)::JSONB) ->> 'order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'order_nr')::INT8 = order_nr) AND ((CAST(? AS TEXT)::JSONB) ->> 'keyword_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'keyword_uuid')::UUID = keyword_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'referred_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'referred_uuid')::UUID = referred_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'sentence_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sentence_uuid')::UUID = sentence_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'word_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'word_count')::INT8 = word_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'start_word_order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'start_word_order_nr')::INT8 = start_word_order_nr) AND ((CAST(? AS TEXT)::JSONB) ->> 'end_word_order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'end_word_order_nr')::INT8 = end_word_order_nr)))
dwui/table/stockbase.count_checked_commandline.sql: line 48
dwui/table/stockbase.count_checked_commandline.sql: line 48

Backtrace

Failed to set variable records_count

In "dwui/table/stockbase.count_checked_commandline.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 table commandline;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM stockbase.count_checked_commandline 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) ->> 'command_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'command_uuid')::UUID = command_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'source' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'source')::"varchar" = source) AND ((CAST(? AS TEXT)::JSONB) ->> 'min_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'min_count')::INT8 = min_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'max_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'max_count')::INT8 = max_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'notice_description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'notice_description')::"varchar" = notice_description) AND ((CAST(? AS TEXT)::JSONB) ->> 'match_description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'match_description')::"varchar" = match_description) AND ((CAST(? AS TEXT)::JSONB) ->> 'order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'order_nr')::INT8 = order_nr) AND ((CAST(? AS TEXT)::JSONB) ->> 'keyword_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'keyword_uuid')::UUID = keyword_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'referred_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'referred_uuid')::UUID = referred_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'sentence_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'sentence_uuid')::UUID = sentence_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'word_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'word_count')::INT8 = word_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'start_word_order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'start_word_order_nr')::INT8 = start_word_order_nr) AND ((CAST(? AS TEXT)::JSONB) ->> 'end_word_order_nr' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'end_word_order_nr')::INT8 = end_word_order_nr)))
dwui/table/stockbase.count_checked_commandline.sql: line 48

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