• Post Reply Bookmark Topic Watch Topic
  • New Topic

Historical records and filters

 
Avner Levy
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have a database design where each time an object (record) is changed I insert a new record with the new data and the previous one is left as is.
The primary key is a regular 64 bit ID (sequence) and in additional I have an object ID (UUID) which is the same in all the object's versions records.
All relations between objects are defined through the Object ID (UUID), that way if some property of an object is changed all relations are still valid.
I've tried to use filters in order to solve one2one and many2one relations between objects but they work only on many2many.
Does anybody has an idea on how this can be solved?
Thanks in advance,
Avner
 
Mark Spritzler
ranger
Sheriff
Posts: 17309
11
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please check your Private Messages for an important JavaRanch message.

Thanks

Mark
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!