You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "rehan3586 (via GitHub)" <gi...@apache.org> on 2026/05/15 11:02:18 UTC
[PR] Fixed: error on the find party screen. (OFBIZ-10824) [ofbiz-framework]
rehan3586 opened a new pull request, #1215:
URL: https://github.com/apache/ofbiz-framework/pull/1215
Fixed: error on the find party screen.
(OFBIZ-10824)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@ofbiz.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Fixed: error on the find party screen. (OFBIZ-10824) [ofbiz-framework]
Posted by "rehan3586 (via GitHub)" <gi...@apache.org>.
rehan3586 commented on PR #1215:
URL: https://github.com/apache/ofbiz-framework/pull/1215#issuecomment-4459256729
When searching for a party using both Postal Address and Telecom Number criteria simultaneously, an SQL Exception is thrown: "Column name 'PC.PARTY_ID' is in more than one table in the FROM list."
This was caused by the `PartyContactMech` member entity being added to the `DynamicViewEntity` multiple times with the exact same alias ("PC") when dynamically building the query in the `performFindParty` service.
The fix is to use unique aliases for the `PartyContactMech` entity depending on the contact mech type being joined (e.g., "PCPA" for PostalAddress, "PCCM" for generic ContactMech, "PCTM" for TelecomNumber). This prevents alias collisions in the generated SQL statement when multiple contact mechanisms are searched at once.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@ofbiz.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [PR] Fixed: error on the find party screen. (OFBIZ-10824) [ofbiz-framework]
Posted by "mridulpathak (via GitHub)" <gi...@apache.org>.
mridulpathak merged PR #1215:
URL: https://github.com/apache/ofbiz-framework/pull/1215
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@ofbiz.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org