mdsupport

On a related note, the ORDataObject model uses REPLACE INTO taking away the option of hard error if two parallel processes got same ID because of lack of locks. So...

I just wanted to make future devs aware of these unexpected code variations since we assumed a library will implement add, change and delete methods. Combining "add+change" in single code...

Possible fix to ORDataObject is : 1. Replace the current SHOW COLUMNS by native ADODB calls that return field objects for mySQL databases. 2. Where the sequences is called, check...

@adunsulag, check #4862 that maintains backward compatibility in legacy code using ORDataObject. Eliminating generate_id function will need to be handled on a per table basis. Easy targets are like insurance_companies...

@sjpadgett Your #5365 about documents table is partially addressed in #4862. Global counter in a modern database is a strange thing to retain. Not only the current code single thread...

For anyone stumbling upon this post, `categories_seq` table is used like `sequences` table.

To provide context for the original question, we are exploring possibility of eliminating use of anything goes type of layouts and/or "forms" - starting with at least the observations. Each...

Long term goal is to gather all observations prior to (portal) and during visit using installation specific panels. Essentially EMR will automatically have [10s if not 100s of prebuilt forms](https://loinc.org/panels/)...

@sjpadgett, Have you explored Bootstrap's [masonary layout](https://getbootstrap.com/docs/5.0/examples/masonry/)? It seems to offer combination of list and grid. Re. QuestionnaireResponse - Like EDI, these are documents. So aren't they best stored in...

@sunsetsystems is correct. Majority of contrib forms are pure input/output - probably specific to a situation - that can now be handled with lbf or any templating engine. Instead of...