- Issue created by @swirt
- 🇺🇸United States swirt Florida
The approach I am going to take for reporting is to put all alts found into a table then generate the report once per day on cron (maybe later with a drush command). This way I can store them and denote whether they pass validation or not. Initially we will start with just the image fields, but then later add processing to include the long html fields too (including body).
- 🇺🇸United States swirt Florida
As the process runs, it can add entries to ✨ Create DB table for storing audit details Active
- 🇺🇸United States swirt Florida
Current View from PR has an issue
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM "alt_text_validation_audit" "alt_text_validation_audit" LIMIT 11 OFFSET 0' at line 3: SELECT FROM "alt_text_validation_audit" "alt_text_validation_audit" LIMIT 11 OFFSET 0; Array ( )For some reason the db table name is repeating.
- 🇺🇸United States swirt Florida
This View is operational now. Of course the Auditor that builds the entries is not running yet, but the View works with test content.
- 🇺🇸United States swirt Florida
Since the auditor to populate the audit table has not been added yet, in order to see the View populated with sample data you will have to run: `drush atvfat` This is a temporary Drush command that populated the audit table.