[OFBIZ-12671] Entity SQL Processor "where" issue

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: Upcoming Branch
• Component/s: webtools
• Assignee: Michael Brohl
• Reporter: Ingo Wolfmayr
• Created: 20/Jul/22 11:55
• Updated: 22/Jul/22 06:30
• Resolved: 22/Jul/22 06:30

Description

The entity sql processor in webtools fails with:

SELECT * FROM ofbiz.CONTACT_MECH WHERE INFO_STRING = "[e-mail]"

results in

SQL Exception while executing the following:SELECT * FROM ofbiz.CONTACT_MECH WHERE INFO_STRING = "[e-mail]" (Column '[e-mail]' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then '[e-mail]' is not a column in the target table.)