I am running into an odd result I don’t understand and was hoping someone could shed light on it.
I was running reports in phpmyadmin off the MySQL tables including off Layout-Based-Forms. I don’t mind the table structure to pull the data from the lbf_data table but when running reports or exporting data I noticed that several of the forms we use frequently just aren’t in the lbf_data table, as in none of their fields are saved there. I can see the fields in layout_options and if I open the forms in the EMRs the data is there, but none is lbf_data table.
There are currently about 8900 lines in the current lbf_data table, so I don’t think that is it “too full”. Is it possible for data to sit in the LBF form saved, but not make it into the lbf_data table?
I need to be able to pull some of these fields for mandatory reports; Any thoughts as to what to look into to correct this would be much appreciated.