CAPA Feedback Flashcards
General Development Practices
Why is error handling and logging important?
To track processes, identify errors, and prevent logic from getting stuck, especially during integrations or automations.
General Development Practices
What tools should be used for maintaining readable and consistent code?
General Development Practices
SQL Linters, refactoring, consistent data types, and adhering to the DRY (Don’t Repeat Yourself) principle.
General Development Practices
Why is thorough testing essential before go-live?
It ensures regression testing, edge-case handling, and consistency across inputs, outputs, and navigation paths.
Functional Development
What should be considered when dealing with list pages or child pages?
Validate dependent functionality and ensure adequate regression testing for cross-functional elements like save buttons.
Functional Development
How can performance issues in list pages be avoided as data scales?
Implement filtering or pagination to limit the data displayed.
Data Management
How can query performance be optimized?
Eliminate unnecessary joins, DISTINCT statements, UDFs in joins or where clauses, and redundant fields.
Data Management
How should dynamic numbering in concurrent scenarios be tested?
Stress test to ensure no duplicate numbers are generated due to race conditions.
Data Management
What should be considered for database cleanup?
Remove data from unused fields, tables, and custom data beyond standard cleanup scripts.
Configuration & Environment Management
Why avoid hardcoding configuration settings?
To prevent errors when promoting code between environments; use dynamic configuration files instead.
Configuration & Environment Management
What best practices should be followed for Node-Red development?
Use dockerized dev environments and store environment-specific settings in configuration files.
Configuration & Environment Management
How should self-hosted client environments be managed?
Sync promptly, document discrepancies, and use comparison tools to validate updates.
APIs, Integrations, & Interfaces
How should API calls handle errors?
Implement error handling for non-200 responses and use pagination logic for APIs with record limits.
APIs, Integrations, & Interfaces
What should SOAP API-dependent code account for?
Handle both single-object and array responses based on returned rows.
Excel Reporting & Outputs
How can Excel numerical formatting issues be handled?
Use preformatted templates, treat numbers as text, or apply custom cell formatting in code.
Input Validation
What should be assumed for text fields in inputs?
Always assume untrusted inputs may contain special characters or exceed database limits.
Project Management & Deployment
What should be done during rollout to avoid code reversion?
Use release processes or enforce installation order in test and production environments.
Project Management & Deployment
What must be verified before closing a ticket?
Ensure code is merged, deployed to production, and all documentation (e.g., CAPA) is complete.
Project Management & Deployment
How can patches and updates be validated during upgrades?
Use Git history logs, comparison tools, and regression testing to confirm critical features remain functional.
Special Considerations
Why consider edge cases during development?
To handle missing data, concurrent processes, and interactions between updated and dependent features.
Special Considerations
How should prior versions of documents or data be handled?
Maintain them in a non-editable, published state for consistency.
Special Considerations
What steps help prevent regression in large projects or aging tickets?
Simplify with releases or sprints, and use comparison tools to validate updates.
