[ 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)