[ https://issues.apache.org/jira/browse/OFBIZ-4709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13216436#comment-13216436 ]
Jacques Le Roux commented on OFBIZ-4709: ---------------------------------------- Ok I read the convo, and I'm still in favor of Sascha's global view. {quote} My Suggestion is to keep the DB site as simple and flat as possible and let the repository do the rest.... {quote} So Anne's suggestion of adding a storageTypeId field to Content Entity seems the best solution to me, so far. Anne, for the point: * a document may become invalid before its expiry date (e.g. because the law changed) You could use the Content.statusId field Unrelated, but I wanted to say that from/thruDate are cool, but not close to what a versioning system can offer... ---- *Mostly notes for myself* By and large (not only this issue), I must say that I'd like to think more about it. I mean to envision more scenarios, notably for handling Contents moves and udpates. And also activation (which version of a Content to use at a moment) not sure yet if it relates with activity concept in JackRabbit (in http://www.day.com/maven/jsr170/javadocs/jcr-2.0/javax/jcr/version/VersionManager.html, oops, for less than a second I did not remember Adobe had bought Day Software, ok not a pb still ASL2 anyway) OK also regarding Adam's comment I mentionned, I read http://wiki.apache.org/jackrabbit/PersistenceManagerFAQ and it's a more evolved than I thought, why a lot of Persistence Manager types and descripted strategies. > Support jcr-stored file content within Applications > --------------------------------------------------- > > Key: OFBIZ-4709 > URL: https://issues.apache.org/jira/browse/OFBIZ-4709 > Project: OFBiz > Issue Type: Sub-task > Components: ALL APPLICATIONS > Affects Versions: SVN trunk > Reporter: Anne Jessel > Assignee: Sascha Rodekamp > > My current requirements: > * store uploaded documents (pdf and scans), mainly for legal compliance > reasons > * old document versions should be accessible > * documents should be associated with existing entities. So far I've > identified a need to associate with Product, Party, OrderHeader, > ShipmentItem, probably InventoryItemDetail and maybe WorkEffort. I would not > be surprised if we discover more as this project proceeds. > * documents may have a type and a purpose, though sometimes I'm not sure of > the difference. For example, type: drivers_licence might be purpose: > identification, and/or purpose: permission_to_drive, while type: > shipping_label would be purpose: shipping_label > * many documents have an expiry date (e.g. drivers licence) > * a document may become invalid before its expiry date (e.g. because the law > changed) > * a specific version of a document may need to be associated with an entity. > For example, a licence agreement document accessed via a Product should > always be the latest version. However the version of that document actually > shipped with the product should be associated with the ShipmentItem. > * a single document might be associated with more than one entity type: see > the example in the previous point > Not all documents require all of the above. For example, there are some > documents where we don't need to track which version was used when, and some > without expiry dates. > I'm thinking of using the from/thruDate pattern to handle expiry related > needs. I'd like to put as much information into the jcr path as possible, so > less needs to go into entities, as per Sascha's suggestion on the dev ML. > However (at least) from/thruDate and which version of a document was actually > used where will presumably need to be stored in an entity. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira