Hi everyone,
Not too long ago we received an error saying we’d reached the maximum column limit on the Case (incident) table. We already have a large number of custom columns, Business Process Flows (BPFs), and forms.
We can delete some columns and possibly consolidate a few BPFs, but we don’t see that as a long-term solution. The incident table is very dynamic in our operations, and we’ll continue to need new fields and processes.
What’s the best approach to handle this? We’re considering creating a new custom table related to the incident table, moving some existing case types and their processes there (important: we can't lose any historical data), and then creating all new columns and processes on the new table. Practically speaking, is this possible? How much effort would it take, and what level of technical competence is required? If there’s an easier or more sustainable approach, we’re open to suggestions.
Thanks!


Report
All responses (
Answers (