pjs_webui.assignment_management

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/pjs_webui.assignment_management.sql": Failed to set variable records_count: In "dwui/table/pjs_webui.assignment_management.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 assignment_management;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM pjs_webui.assignment_management 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) ->> 'cell_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'cell_uuid')::UUID = cell_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'cell_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'cell_title')::"varchar" = cell_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'job_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'job_uuid')::UUID = job_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'job_jobcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'job_jobcode')::"varchar" = job_jobcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'work_start_ts' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'work_start_ts')::TIMESTAMPTZ = work_start_ts) AND ((CAST(? AS TEXT)::JSONB) ->> 'work_end_ts' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'work_end_ts')::TIMESTAMPTZ = work_end_ts) AND ((CAST(? AS TEXT)::JSONB) ->> 'assignee_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'assignee_uuid')::UUID = assignee_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_title')::"varchar" = user_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'record_created_by_user_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'record_created_by_user_uuid')::UUID = record_created_by_user_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_current' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_current')::INT4 = is_current) AND ((CAST(? AS TEXT)::JSONB) ->> 'item_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'item_count')::"numeric" = item_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'key' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'key')::"varchar" = key)))
dwui/table/pjs_webui.assignment_management.sql: line 48
dwui/table/pjs_webui.assignment_management.sql: line 48

Backtrace

Failed to set variable records_count

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

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM pjs_webui.assignment_management 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) ->> 'cell_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'cell_uuid')::UUID = cell_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'cell_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'cell_title')::"varchar" = cell_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'job_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'job_uuid')::UUID = job_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'job_jobcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'job_jobcode')::"varchar" = job_jobcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'work_start_ts' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'work_start_ts')::TIMESTAMPTZ = work_start_ts) AND ((CAST(? AS TEXT)::JSONB) ->> 'work_end_ts' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'work_end_ts')::TIMESTAMPTZ = work_end_ts) AND ((CAST(? AS TEXT)::JSONB) ->> 'assignee_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'assignee_uuid')::UUID = assignee_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'user_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'user_title')::"varchar" = user_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'record_created_by_user_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'record_created_by_user_uuid')::UUID = record_created_by_user_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'is_current' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'is_current')::INT4 = is_current) AND ((CAST(? AS TEXT)::JSONB) ->> 'item_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'item_count')::"numeric" = item_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'key' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'key')::"varchar" = key)))
dwui/table/pjs_webui.assignment_management.sql: line 48

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