[
https://issues.apache.org/jira/browse/OFBIZ-9138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16144665#comment-16144665
]
Wei Zhang commented on OFBIZ-9138:
----------------------------------
Hi Nicolas,
This fix causes a another problem. You may get the problem by the code below.
{code:borderStyle=solid}
<view-entity entity-name="ExampleTypeView"
package-name="org.apache.ofbiz.example.example">
<member-entity entity-alias="EX" entity-name="Example"/>
<alias entity-alias="EX" name="exampleId" field="exampleId" />
<alias entity-alias="EX" name="exampleTypeId" group-by="true"/>
</view-entity>
EntityQuery.use(delegator).from("ExampleTypeView").queryList()
{code}
And the error message is:
2017-08-29 10:27:09,990 |jsse-nio-8443-exec-3 |GenericDelegator
|E| Failure in findByCondition operation for entity [ExampleTypeView]:
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT EX.EXAMPLE_ID, EX.EXAMPLE_TYPE_ID FROM
public.EXAMPLE EX GROUP BY EX.EXAMPLE_TYPE_ID (ERROR: column "ex.example_id"
must appear in the GROUP BY clause or be used in an aggregate function
Position: 8). Rolling back transaction.
org.apache.ofbiz.entity.GenericDataSourceException: SQL Exception while
executing the following:SELECT EX.EXAMPLE_ID, EX.EXAMPLE_TYPE_ID FROM
public.EXAMPLE EX GROUP BY EX.EXAMPLE_TYPE_ID (ERROR: column "ex.example_id"
must appear in the GROUP BY clause or be used in an aggregate function
Position: 8)
at
org.apache.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:446)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericDAO.selectListIteratorByCondition(GenericDAO.java:869)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.datasource.GenericHelperDAO.findListIteratorByCondition(GenericHelperDAO.java:141)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.find(GenericDelegator.java:1552)
~[ofbiz.jar:?]
at
org.apache.ofbiz.entity.GenericDelegator.findList(GenericDelegator.java:1586)
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery.query(EntityQuery.java:451)
[ofbiz.jar:?]
at
org.apache.ofbiz.entity.util.EntityQuery.queryList(EntityQuery.java:381)
[ofbiz.jar:?]
at org.apache.ofbiz.entity.util.EntityQuery$queryList$1.call(Unknown
Source) [ofbiz.jar:?]
at
org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
[groovy-all-2.4.12.jar:2.4.12]
at
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
[groovy-all-2.4.12.jar:2.4.12]
at
org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:117)
[groovy-all-2.4.12.jar:2.4.12]
at uk.co.robertheath.mobile.FooServices.getFoo(FooServices.groovy:31)
[script:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
~[?:1.8.0_112]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
~[?:1.8.0_112]
Kind Regards,
Wei
> Create a common theme
> ---------------------
>
> Key: OFBIZ-9138
> URL: https://issues.apache.org/jira/browse/OFBIZ-9138
> Project: OFBiz
> Issue Type: Sub-task
> Components: framework
> Reporter: Nicolas Malin
> Assignee: Nicolas Malin
> Fix For: Upcoming Release
>
> Attachments: common-theme-macro.svg, common-theme-screen.svg
>
>
> A first task to UI Improvement would be create a common that receive the
> existent code.
> The benefice would be have a framework/common who list all screens that
> available for theme surcharge, so without technology information (css/html or
> something like that)
> Different task to do :
> * move all ftl template from framework/common to themes/common
> * move framework/images to themes/common (this directory contains unlogical
> element for theme but will be manage at a second time)
> * move default macro ftl template from framework/widget to themes/common
> After the realization on this task, all current themes call theme/common for
> html rendering instead of framework/common, framework/images and
> framework/widget. Just pave the way for the next
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
