[ 
https://issues.apache.org/jira/browse/OFBIZ-5256?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13705398#comment-13705398
 ] 

Hans Bakker commented on OFBIZ-5256:
------------------------------------

Finally I got a solution and thank you all for your comments. The winning tip 
goes to Leon.

the viewlink section is a bit messy with a mix of keymaps and conditions, both 
are required and this is the one that works:
{noformat} 
       <view-link entity-alias="INV" rel-entity-alias="ITM" rel-optional="true">
            <key-map field-name="invoiceId"/>
        </view-link>
        <view-link entity-alias="INV" rel-entity-alias="PFR" 
rel-optional="true">
            <key-map field-name="partyIdFrom" rel-field-name="partyId"/>
            <entity-condition>
                <condition-expr entity-alias="PFR" 
field-name="partyIdentificationTypeId" value="INVOICE_EXPORT"/>
            </entity-condition>
        </view-link>
        <view-link entity-alias="INV" rel-entity-alias="PTO" 
rel-optional="true">
            <key-map field-name="partyId"/>
            <entity-condition>
                <condition-expr entity-alias="PTO" 
field-name="partyIdentificationTypeId" value="INVOICE_EXPORT"/>
            </entity-condition>
        </view-link>
        <view-link entity-alias="ITM" rel-entity-alias="GI" rel-optional="true">
            <key-map field-name="productId"/>
            <entity-condition>
                <condition-expr entity-alias="GI" 
field-name="goodIdentificationTypeId"/>
            </entity-condition>
        </view-link>
{noformat} 

Regards,
Hans

                
> allow a value in the view relation definition
> ---------------------------------------------
>
>                 Key: OFBIZ-5256
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5256
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: SVN trunk
>         Environment: any
>            Reporter: Hans Bakker
>            Assignee: Hans Bakker
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: value.diff
>
>
> I need help from our framework experts.
> I want to copy invoices from an ofbiz system to other systems. However the 
> export has partyId's and productid's which are different on the other 
> systems. I want to use the product and party alternative id's to translate 
> these values.
> In order to be able to replace party and product id's values in a csv export 
> it is required to be able to have a 'value' specified instead of a field name
> the link in a view definition is as follows: (first key-map current, second 
> line new key-map possibility:
>       <view-link entity-alias="INV" rel-entity-alias="PFR" 
> rel-optional="true">
>             <key-map field-name="partyIdFrom" rel-field-name="partyId"/>
>             <key-map value="INVOICE_EXPORT" 
> rel-field-name="partyIdentificationTypeId"/>
>         </view-link>
> i will attach a diff for my implementation...
> Since we (Antwebsystems) focus on application development and not framework 
> development a check with our framework committers is highly appreciated.
> The patch includes a view which uses this new feature.
> Regards,
> Hans

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Reply via email to