AnsweredAssumed Answered

Database stored keys and array drop down key integrity

Question asked by Neil Conacher on Mar 15, 2016
Latest reply on Mar 16, 2016 by Neil Conacher

Learning the Sugar ropes - concerned by the separation of key data stored in db and dropdown key and label arrays held in php code.


See attached file for simple scenario.


Without the help of scripts to help maintain integrity of db data and php array keys, I anticipate issues of inaccurate results from the db.


I'm surprised that an enterprise solution displays this 'feature'.


Would welcome views around best practice and tools for achieving ongoing integrity.