You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Jacques Le Roux (JIRA)" <ji...@apache.org> on 2015/09/23 15:05:04 UTC
[jira] [Comment Edited] (OFBIZ-6495) The tag in
view entity PartyExport does not work
[ 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)