KB-4478 rev 2

H11b Description Detail Missing Query

1 min read Revision 2
hcquerydescription-governanceh11bS178-Fix30

SELECT count(*) AS h11b_total FROM v_entity_full_classification v WHERE v.governance_role = 'governed' AND v.description IS NOT NULL AND btrim(v.description) <> '' AND (v.description_provenance = 'PROV-DOT' OR v.description_provenance IS NULL) AND v.species_code NOT IN ( SELECT jsonb_array_elements_text(COALESCE( (SELECT value::jsonb FROM dot_config WHERE key = 'h11b_exclude_species'), '[]'::jsonb )) )