Jul 11th, 2011, 8:21 AM
Hi Alex,
Sorry for not getting back to you!
The Submission History table works by making and maintaining a copy of your submissions form, with a few extra fields in it. If your form ID was 5 (and your DB prefix ft_), your main submission table would be called ft_form_5 and the history table would be ft_form_5_history.
Unlike the main submissions table, the history tables logs multiple records for each submission. Each record logs a particular change to a submission. So that's where your history data is stashed.
If I were you, I'd take a look at the module's functions and see if there's anything in there you can re-use. This function in the /modules/submission_history/global/code/code.php file looks especially promising!
- Ben
Sorry for not getting back to you!
The Submission History table works by making and maintaining a copy of your submissions form, with a few extra fields in it. If your form ID was 5 (and your DB prefix ft_), your main submission table would be called ft_form_5 and the history table would be ft_form_5_history.
Unlike the main submissions table, the history tables logs multiple records for each submission. Each record logs a particular change to a submission. So that's where your history data is stashed.
If I were you, I'd take a look at the module's functions and see if there's anything in there you can re-use. This function in the /modules/submission_history/global/code/code.php file looks especially promising!
Code:
$info = sh_get_last_submission_history_row($form_id, $submission_id);
- Ben