cgm_table_name_cached (table) Content

cgm_table_name_cached (table) Schema


DCLP1	uniform_resource_cgm_tracing	cgm_tracing.csv
DCLP1	uniform_resource_study	study.csv
DCLP1	uniform_resource_lab	lab.csv
DCLP1	uniform_resource_institution	institution.csv
DCLP1	uniform_resource_cgm_file_metadata	cgm_file_metadata.csv
DCLP1	uniform_resource_investigator	investigator.csv
DCLP1	uniform_resource_site	site.csv
DCLP1	uniform_resource_publication	publication.csv
DCLP1	uniform_resource_author	author.csv
DCLP1	uniform_resource_participant	participant.csv

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/table/cgm_table_name_cached.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'.