Cheers Jim.
There may be something more going on as the iform reports are no longer pulling back records from the warehouse. I can only assume this is because the connection settings are no longer functioning?
Throwing sql error
general_errors.There was an SQL error: ERROR: missing FROM-clause entry for table "w" LINE 13: CASE WHEN w.id IN (69) THEN '' ELSE snf.website_title || '->... ^ - SELECT o.id as "occurrence_id", snf.website_title || ' | ' || snf.survey_title as "source", o.sample_id as "sample_id", CASE WHEN cttl.preferred_taxon=cttl.default_common_name then cttl.preferred_taxon ELSE cttl.preferred_taxon || COALESCE(' | ' || cttl.default_common_name, '') END as "taxon", cttl.taxon_group as "taxon_group", o.taxa_taxon_list_id as "taxa_taxon_list_id", o.location_name as "location_name", regexp_replace(snf.public_entered_sref, ',[^ ]', ', ', 'g') as "entered_sref", o.date_start as "date_start", o.date_end as "date_end", o.date_type as "date_type", CASE WHEN w.id IN (69) THEN '' ELSE snf.website_title || '-> ' END || CASE WHEN LENGTH(snf.recorders)>30 THEN 'Recorder' ELSE snf.recorders END as "recorder", o.zero_abundance as "zero_abundance", o.record_status as "record_status", CASE WHEN CAST(o.created_by_id AS character varying) = '229' AND o.website_id IN (69) THEN true ELSE false END as "belongs_to_user", o.certainty as "certainty", round(length(snf.public_entered_sref) / 24.0, 2) as "fo", case o.record_status when 'C' then case o.certainty when 'C' then 'green' when 'L' then 'orange' when 'U' then 'red' else 'blue' end when 'V' then 'green' when 'D' then 'orange' when 'R' then 'red' else 'black' end as "sc", case o.record_status when 'V' then 'green' when 'D' then 'orange' when 'R' then 'red' else 'blue' end as "fc", length(snf.public_entered_sref) as "zi", st_astext(o.public_geom) as "geom", onf.media as "images", case when o.input_form is null then '' else o.input_form end as "input_form" FROM cache_occurrences_functional o JOIN cache_occurrences_nonfunctional onf on onf.id=o.id JOIN cache_samples_nonfunctional snf on snf.id=o.sample_id JOIN cache_taxa_taxon_lists cttl ON cttl.id=o.taxa_taxon_list_id JOIN users privacyusers ON privacyusers.id=o.created_by_id WHERE (o.training=false OR o.training IS NULL) AND (o.website_id in (69) OR privacyusers.id=1 OR privacyusers.allow_share_for_reporting=true OR privacyusers.allow_share_for_reporting IS NULL) AND o.website_id in (69) AND o.record_status not in ('I','T') AND (0=1 OR o.record_status not in ('D','R')) AND (''='' OR st_intersects(o.public_geom, ST_MakeValid(st_geomfromtext('',900913)))) ORDER BY o.id DESC LIMIT 3000
Natural History & Biodiversity Data Enthusiast