Associated table and find specific datetime

[braguzz]

Hi, I have this situation, I'd like to version two tables

Procedures
Specifics

Procedures has many Specifics

When I change something in a Procedure, all related specifics should point to last version.

When I change a Procedure last version should point to the specific.

I have to retrieve a procedure and its specific at a given a datetime (I mean I'd love to retrieve that procedure and specific at that datetime).

It is possible?
It's the right plugin?

[jeremyharris]

Hi! I'm not sure I fully understand your use case, but in general the way this plugin works is transparent to your queries. Versions are saved in the background for later reference, but you will always query against the latest data (the current version).

If you change a Procedure it does not affect its Specifics. Likewise if you change a single Specific, it does not change the version of the Procedure or other Specifics. Updating those records only saves the old version (before the changes) into its version table.

If this doesn't answer your question, could you reply with some more information and maybe a more concrete example?