Contents

select validation_errors.invalid_model_name,
       validation_errors.invalid_model_id,
       validation_errors.action,
       validation_errors.created_at,
       json_data.key as error_column,
       json_array_elements(json_data.value)->>'error' as error_type
from validation_errors, json_each(validation_errors.details) as json_data

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
validation_errors-0.3.0	lib/generators/templates/flat_validation_errors_v01.sql.tt
validation_errors-0.2.0	lib/generators/templates/flat_validation_errors_v01.sql.tt
validation_errors-0.1.0	lib/generators/templates/flat_validation_errors_v01.sql.tt