Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0036024 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Retail Modules] Retail Widgets | minor | have not tried | 2017-05-17 13:24 | 2017-05-17 13:30 | |||||||
| Reporter | aferraz | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Linux 64 bit | Database | PostgreSQL | Java version | 1.6.0_18 | |||||||
| OS Version | Professional Appliance | Database version | 8.3.9 | Ant version | 1.7.1 | |||||||
| Product Version | SCM revision | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | No | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0036024: Error in Best Selling Store widget | |||||||||||
| Description | Error in Best Selling Store widget | |||||||||||
| Steps To Reproduce | Run Best Selling Store widget. Following exception is raised: Exception while fetching the summary columns of the widget Best Selling Store. It is not supported using as summaries columns that are defined using a subquery, or that are defined using a summary function. Query = select sum(quantity), sum(totalsales), sum(totaldiscount), sum(totaldiscpercentage)/count(*), sum(totalcost), sum(markup)/count(*), sum(grossmargin), sum(grossmarginpercentage)/count(*) from OrderLineTax olt where olt.salesOrderLine = sol)),2) as totalsales, round(sum(tc.cost),2) as totalcost, case when round(sum(tc.cost),2)>0 then round(sum(sol.lineNetAmount + (select sum(taxAmount) from OrderLineTax olt where olt.salesOrderLine = sol))/(sum(tc.cost)),2) else NULL end as markup, round(sum(sol.lineNetAmount + (select sum(taxAmount) from OrderLineTax olt where olt.salesOrderLine = sol)-tc.cost),2) as grossmargin, round((sum(sol.lineNetAmount + (select sum(taxAmount) from OrderLineTax olt where olt.salesOrderLine = sol)-tc.cost)/sum(sol.lineNetAmount + (select sum(taxAmount) from OrderLineTax olt where olt.salesOrderLine = sol)))*100,2) as grossmarginpercentage from TransactionCost as tc join tc.inventoryTransaction as t right join t.goodsShipmentLine as iol left join iol.salesOrderLine as sol left join sol.salesOrder as o left join o.obposApplications as posapp left join o.organization as org where o.salesTransaction = 'Y' and o.documentStatus = 'CO' and posapp.client.id=:client and posapp.organization.id IN (:organizationList) and to_date(to_char(o.creationDate, 'YYYY-MM-DD'), 'YYYY-MM-DD')>=to_date(:datefrom,'YYYY-MM-DD') and to_date(to_char(o.creationDate, 'YYYY-MM-DD'), 'YYYY-MM-DD')<=to_date(:dateto,'YYYY-MM-DD') and 1=1 group by org.name, org.id | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-05-17 13:24 | aferraz | New Issue | |
| 2017-05-17 13:24 | aferraz | Assigned To | => Retail |
| 2017-05-17 13:24 | aferraz | OBNetwork customer | => No |
| 2017-05-17 13:24 | aferraz | Triggers an Emergency Pack | => No |
| 2017-05-17 13:30 | aferraz | Note Added: 0096641 | |
| 2017-05-17 13:30 | aferraz | Relationship added | related to 0032604 |
| 2024-12-01 20:09 | AugustoMauch | Note Deleted: 0096641 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |