[jira] [Comment Edited] (OFBIZ-6495) The tag <entity-condition/> in view entity PartyExport does not work

[Nicolas Malin (Jira)]

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

Jacques Le Roux edited comment on OFBIZ-6495 at 9/23/15 1:04 PM:
-----------------------------------------------------------------

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 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 = '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?


was (Author: jacques.le.roux):
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)