I have a question. We are trying to retrieve data using SPIP Versions but we are facing some struggles: Our goal is to check if in a specific data range if there was something in a a certain field at the beginning of the date range.
We have a text field and in the initial version of this article (ID Version 1) this field is filled with a content let’s say « apple ». This version might have changes in some other fields in the following months, and maybe even the content field changes at some point to « tomato ».
Then on the first of August the content field accidentally gets overwritten and is now empty. The same thing happened with many other articles.
Now I would like to get the content back from right before it got accidentally overwritten back in this case « tomato » .
I have the two tables « spip_versions » and « spip_versions_fragments » but so far I haven’t figured out how I can connect the changes in a range of data with a specific field.
Thanks a lot to anyone who might have an idea how to do this!