expected_schema_view (view) Content
| uniform_resource_publication | study_id | TEXT | 0 | 1 |
| uniform_resource_publication | tenant_id | TEXT | 0 | 1 |
| uniform_resource_author | author_id | TEXT | 1 | 1 |
| uniform_resource_author | name | TEXT | 0 | 1 |
| uniform_resource_author | TEXT | 0 | 1 | |
| uniform_resource_author | investigator_id | TEXT | 0 | 1 |
| uniform_resource_author | study_id | TEXT | 0 | 1 |
| uniform_resource_author | tenant_id | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | metadata_id | TEXT | 1 | 1 |
| uniform_resource_cgm_file_metadata | devicename | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | device_id | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | source_platform | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | patient_id | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | file_name | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | file_format | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | file_upload_date | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | data_start_date | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | data_end_date | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | study_id | TEXT | 0 | 1 |
| uniform_resource_cgm_file_metadata | tenant_id | TEXT | 0 | 1 |
Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
Error in query number 6:
Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
⬆️
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
Backtrace
sql parser error: Expected: END, found: ' ||
' at Line: 42, Column: 149"console/content/view/expected_schema_view.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.