Amardeep Singh Jhajj created OFBIZ-7519:
-------------------------------------------

             Summary: Some entity-auto services fields doesn't have optional 
false in case of multiple PK's.
                 Key: OFBIZ-7519
                 URL: https://issues.apache.org/jira/browse/OFBIZ-7519
             Project: OFBiz
          Issue Type: Improvement
          Components: accounting, content, marketing
    Affects Versions: Trunk
            Reporter: Amardeep Singh Jhajj
            Assignee: Amardeep Singh Jhajj


Some services with entity-auto doesn't have optional false in case of multiple 
PK's. In this cases if any of the PK is missing then sql error returns.

Please find attached screenshot of error.

According to my analysis of entity auto engine, Here are some cases:

1. One primary key: Takes new sequence if PK not passed.
2. Two primary key: Both PK should be mandatory except the case of secondary 
primary key (like agreementItemSeqId) where next subsequence is generated.
3. More than two PK's, all PK's should be mandatory except the fromDate.

Here is the list of services which need to be fixed according to above points.

1. createAgreementItem
2. updateAgreementItem
3. deleteAgreementItem
4. updateAgreementTerm
5. deleteAgreementTerm
6. createContentMetaData
7. createContentPurpose
8. createContentPurposeOperation
9. createContentAttribute
10. createContentRevisionItem
11. createContentTypeAttr
12. createDataResourceMetaData
13. createDataResourcePurpose
14. createSurveyTrigger
15. createDataResourceAttribute
16. createSalesOpportunityRole

I am working on it and will add patch soon.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to