List of all 'No period found for code' errors in latest BugsCEP import.
with error_values as (
select *, string_to_array(translate(bugs_data, '{}', ''), ',') as data_array, bugs_data
from bugs_import.bugs_errors
where TRUE
and message = 'No period found for code'
) select data_array[4] as period_code, data_array[5] as dating_method, count(*) as count
from error_values
group by data_array[4], data_array[5]
order by 1, 2 desc
List of all 'No period found for code' errors in latest BugsCEP import.