[
https://issues.apache.org/jira/browse/OFBIZ-6495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14587628#comment-14587628
]
Wei Zhang commented on OFBIZ-6495:
----------------------------------
Hi Jacques,
I changed ViewEntityCondition.getWhereCondition(),
ViewConditionExpr.createCondition() and ViewConditionList.createCondition()
which will add additional condition of filtering by date to where clause.
Please test by following steps.
1. Change the code below in GenericDAO
{code:title=GenericDAO.java|borderStyle=solid}
if (queryTotalTime > 150) {
Debug.logTiming("Ran query in " + queryTotalTime + " milli-seconds: " + "
EntityName: " + modelEntity.getEntityName() + " Sql: " + sql + " where clause:"
+ whereEntityConditionParams, module);
}
{code}
to
{code:title=GenericDAO.java|borderStyle=solid}
if (queryTotalTime > 0) {
Debug.logTiming("Ran query in " + queryTotalTime + " milli-seconds: " + "
EntityName: " + modelEntity.getEntityName() + " Sql: " + sql + " where clause:"
+ whereEntityConditionParams, module);
}
{code}
It will always log the sql to the log file.
2. Open https://localhost:8443/partymgr/control/ImportExport
2. Enter a valid partyId for export and click SUBMIT
3. Check ofbiz.log file under runtime folder. You should able to see the query
below which contains filter data condition
{code:title=SQL of PartyExport view |borderStyle=solid}
SELECT
PRT.PARTY_ID,
PRT.STATUS_ID,
PRT.PREFERRED_CURRENCY_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.COUNTRY_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 (((((((((public.PARTY PRT
LEFT OUTER JOIN public.PARTY_GROUP GRP
ON PRT.PARTY_ID = GRP.PARTY_ID)
LEFT OUTER JOIN public.PERSON PER
ON PRT.PARTY_ID = PER.PARTY_ID)
LEFT OUTER JOIN public.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 public.PARTY_GROUP CGRP
ON PR.PARTY_ID_FROM = CGRP.PARTY_ID)
LEFT OUTER JOIN public.PARTY_ROLE PRL
ON PRT.PARTY_ID = PRL.PARTY_ID)
LEFT OUTER JOIN public.PARTY_CONTACT_MECH PCM
ON PRT.PARTY_ID = PCM.PARTY_ID
AND (((PCM.THRU_DATE IS NULL
OR PCM.THRU_DATE > '2015-06-15 13:21:30.157')
AND (PCM.FROM_DATE IS NULL
OR PCM.FROM_DATE <= '2015-06-15 13:21:30.157'))))
LEFT OUTER JOIN public.POSTAL_ADDRESS PA
ON PCM.CONTACT_MECH_ID = PA.CONTACT_MECH_ID)
LEFT OUTER JOIN public.CONTACT_MECH CM
ON PCM.CONTACT_MECH_ID = CM.CONTACT_MECH_ID)
LEFT OUTER JOIN public.TELECOM_NUMBER TN
ON PCM.CONTACT_MECH_ID = TN.CONTACT_MECH_ID)
LEFT OUTER JOIN public.PARTY_CONTACT_MECH_PURPOSE PCP
ON PCM.CONTACT_MECH_ID = PCP.CONTACT_MECH_ID
AND (((PCM.THRU_DATE IS NULL
OR PCM.THRU_DATE > '2015-06-15 13:21:30.157')
AND (PCM.FROM_DATE IS NULL
OR PCM.FROM_DATE <= '2015-06-15 13:21:30.157')))
AND PCM.PARTY_ID = PCP.PARTY_ID
AND (((PCM.THRU_DATE IS NULL
OR PCM.THRU_DATE > '2015-06-15 13:21:30.236')
AND (PCM.FROM_DATE IS NULL
OR PCM.FROM_DATE <= '2015-06-15 13:21:30.236')))
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
{code}
Hope that make sense.
Regards,
Wei
> 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)
