[jira] [Commented] (OFBIZ-6495) The tag in view entity PartyExport does not work

["Jacques Le Roux (JIRA)" <ji...@apache.org>]

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

Jacques Le Roux commented on OFBIZ-6495:
----------------------------------------

Thanks for your explanation Wei. I tried your suggestion and got

{code}
EntityName: PartyExport Sql: SELECT PRT.PARTY_ID, PRT.STATUS_ID, PRT.PREFERRED_CURRE
NCY_UOM_ID, GRP.GROUP_NAME, PER.FIRST_NAME, PER.MIDDLE_NAME, PER.LAST_NAME, PR.PARTY_ID_FROM, CGRP.GROUP_NAME, PRL.ROLE_TYPE_ID, CM.CONTACT_MECH_TYPE_ID, PCP.CONTACT_MECH_PURPOSE_TYPE_ID, CM.INFO_STRING, TN.C
OUNTRY_CODE, TN.AREA_CODE, TN.CONTACT_NUMBER, PA.ADDRESS1, PA.ADDRESS2, PA.CITY, PA.STATE_PROVINCE_GEO_ID, PA.POSTAL_CODE, PA.COUNTRY_GEO_ID FROM (((((((((OFBIZ.PARTY PRT LEFT OUTER JOIN OFBIZ.PARTY_GROUP GRP
 ON PRT.PARTY_ID = GRP.PARTY_ID) LEFT OUTER JOIN OFBIZ.PERSON PER ON PRT.PARTY_ID = PER.PARTY_ID) LEFT OUTER JOIN OFBIZ.PARTY_RELATIONSHIP PR ON PRT.PARTY_ID = PR.PARTY_ID_TO AND (PR.ROLE_TYPE_ID_FROM = 'ACCO
UNT' AND PR.PARTY_RELATIONSHIP_TYPE_ID = 'EMPLOYMENT')) LEFT OUTER JOIN OFBIZ.PARTY_GROUP CGRP ON PR.PARTY_ID_FROM = CGRP.PARTY_ID) LEFT OUTER JOIN OFBIZ.PARTY_ROLE PRL ON PRT.PARTY_ID = PRL.PARTY_ID) LEFT OU
TER JOIN OFBIZ.PARTY_CONTACT_MECH PCM ON PRT.PARTY_ID = PCM.PARTY_ID) LEFT OUTER JOIN OFBIZ.POSTAL_ADDRESS PA ON PCM.CONTACT_MECH_ID = PA.CONTACT_MECH_ID) LEFT OUTER JOIN OFBIZ.CONTACT_MECH CM ON PCM.CONTACT_
MECH_ID = CM.CONTACT_MECH_ID) LEFT OUTER JOIN OFBIZ.TELECOM_NUMBER TN ON PCM.CONTACT_MECH_ID = TN.CONTACT_MECH_ID) LEFT OUTER JOIN OFBIZ.PARTY_CONTACT_MECH_PURPOSE PCP ON PCM.CONTACT_MECH_ID = PCP.CONTACT_MEC
H_ID AND PCM.PARTY_ID = PCP.PARTY_ID WHERE (((PRL.ROLE_TYPE_ID = ? OR PRL.ROLE_TYPE_ID = ? OR PRL.ROLE_TYPE_ID = ?) AND (PRT.STATUS_ID <> ? OR PRT.STATUS_ID IS NULL) AND PRT.PARTY_ID = ?)) ORDER BY PRT.PARTY_
ID ASC where clause:[PRL_ROLE_TYPE_ID=CUSTOMER, PRL_ROLE_TYPE_ID=SUPPLIER, PRL_ROLE_TYPE_ID=EMPLOYEE, PRT_STATUS_ID=PARTY_DISABLED, PRT_PARTY_ID=admin]
{code}
before applying your patches and
{code}
EntityName: PartyExport Sql: SELECT PRT.PARTY_ID, PRT.STATUS_ID, PRT.PREFERRED_CURRE
NCY_UOM_ID, GRP.GROUP_NAME, PER.FIRST_NAME, PER.MIDDLE_NAME, PER.LAST_NAME, PR.PARTY_ID_FROM, CGRP.GROUP_NAME, PRL.ROLE_TYPE_ID, CM.CONTACT_MECH_TYPE_ID, PCP.CONTACT_MECH_PURPOSE_TYPE_ID, CM.INFO_STRING, TN.C
OUNTRY_CODE, TN.AREA_CODE, TN.CONTACT_NUMBER, PA.ADDRESS1, PA.ADDRESS2, PA.CITY, PA.STATE_PROVINCE_GEO_ID, PA.POSTAL_CODE, PA.COUNTRY_GEO_ID, PCM.FROM_DATE, PCM.THRU_DATE FROM (((((((((OFBIZ.PARTY PRT LEFT OU
TER JOIN OFBIZ.PARTY_GROUP GRP ON PRT.PARTY_ID = GRP.PARTY_ID) LEFT OUTER JOIN OFBIZ.PERSON PER ON PRT.PARTY_ID = PER.PARTY_ID) LEFT OUTER JOIN OFBIZ.PARTY_RELATIONSHIP PR ON PRT.PARTY_ID = PR.PARTY_ID_TO AND
 ((PR.ROLE_TYPE_ID_FROM = 'ACCOUNT' AND PR.PARTY_RELATIONSHIP_TYPE_ID = 'EMPLOYMENT'))) LEFT OUTER JOIN OFBIZ.PARTY_GROUP CGRP ON PR.PARTY_ID_FROM = CGRP.PARTY_ID) LEFT OUTER JOIN OFBIZ.PARTY_ROLE PRL ON PRT.
PARTY_ID = PRL.PARTY_ID) LEFT OUTER JOIN OFBIZ.PARTY_CONTACT_MECH PCM ON PRT.PARTY_ID = PCM.PARTY_ID AND (((PCM.THRU_DATE IS NULL OR PCM.THRU_DATE > '2015-09-23 14:27:04.919') AND (PCM.FROM_DATE IS NULL OR PC
M.FROM_DATE <= '2015-09-23 14:27:04.919')))) LEFT OUTER JOIN OFBIZ.POSTAL_ADDRESS PA ON PCM.CONTACT_MECH_ID = PA.CONTACT_MECH_ID) LEFT OUTER JOIN OFBIZ.CONTACT_MECH CM ON PCM.CONTACT_MECH_ID = CM.CONTACT_MECH
_ID) LEFT OUTER JOIN OFBIZ.TELECOM_NUMBER TN ON PCM.CONTACT_MECH_ID = TN.CONTACT_MECH_ID) LEFT OUTER JOIN OFBIZ.PARTY_CONTACT_MECH_PURPOSE PCP ON PCM.CONTACT_MECH_ID = PCP.CONTACT_MECH_ID AND PCM.PARTY_ID = P
CP.PARTY_ID AND (((PCM.THRU_DATE IS NULL OR PCM.THRU_DATE > '2015-09-23 14:27:04.919') AND (PCM.FROM_DATE IS NULL OR PCM.FROM_DATE <= '2015-09-23 14:27:04.919'))) WHERE (((PRL.ROLE_TYPE_ID = ? OR PRL.ROLE_TYP
E_ID = ? OR PRL.ROLE_TYPE_ID = ?) AND (PRT.STATUS_ID <> ? OR PRT.STATUS_ID IS NULL) AND PRT.PARTY_ID = ?)) ORDER BY PRT.PARTY_ID ASC where clause:[PRL_ROLE_TYPE_ID=CUSTOMER, PRL_ROLE_TYPE_ID=SUPPLIER, PRL_ROL
E_TYPE_ID=EMPLOYEE, PRT_STATUS_ID=PARTY_DISABLED, PRT_PARTY_ID=admin]
{code}
after. So yes there is a difference, but it's not obvious to spot whatn and especially why "The tag <entity-condition></entity> in view entity PartyExport does not work". Because the result is the same in both cases (exportParty.csv):
{code}
partyId,"preferredCurrencyUomId","groupName","firstName","middleName","lastName","companyPartyId","companyName","roleTypeId","contactMechPurposeTypeId","contactMechTypeId","emailAddress","telCountryCode","telAreaCode","telContactNumber","address1","address2","city","stateProvinceGeoId","postalCode","countryGeoId",
{code}

Could you please give me some light about what you are doing and why? Thanks!

BTW I tried only the export, were you concerned by the import?

> The tag <entity-condition/> in view entity PartyExport does not work
> --------------------------------------------------------------------
>
>                 Key: OFBIZ-6495
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6495
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: Trunk
>            Reporter: Wei Zhang
>            Assignee: Jacques Le Roux
>         Attachments: patches-6495.zip
>
>
> The tag <entity-condition/> in view entity PartyExport in applications\party\entitydef\entitymodel.xml does not work.



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