Bug Tracker Incident #15670

 


Summary
Project
INCDT - xTuple ERP
Incident Category
Bugs
Incident Number
15670
Visibility
public


Product Version
3.8.0Alpha
Fixed In Version
3.8.0Beta


Summary
*Selecting to query the ‘Time-Phased Sales History’ screen without selecting any period generates a DB log error


Description

Querying without selecting any period generates a DB log error in ‘Time-Phased Sales History’ screen

Steps to Reproduce:
1. Sales->Analysis->Time Phased Sales History
2. Select a calendar from the drop down list
3. Un Select all the periods and click on Query button
4. Observe that an error message is displayed and a DB log error is generated

DB log error:
Wed 14. Sep 18:16:12 2011 ERROR: syntax error at or near ")"
LINE 32: )
^
QPSQL: Unable to create query
-- Group: timePhasedSales
-- Name: detail
-- Notes:

SELECT

cust_id, cust_number, cust_name,

uom, warehous_code
-- Loop through each period bucket to find bookings for period

FROM (
SELECT cohist_invcdate,

cust_id, cust_number, cust_name

, warehous_code

, round((cohist_qtyshipped * currtobase(cohist_curr_id, cohist_unitprice, cohist_invcdate)), 2) AS amount
, ' USD-$' ::text AS uom

FROM cohist JOIN itemsite ON (itemsite_id=cohist_itemsite_id)
JOIN item ON (item_id=itemsite_item_id)

JOIN site() ON (itemsite_warehous_id=warehous_id)

JOIN custinfo ON (cohist_cust_id=cust_id)

WHERE ((cohist_invcdate BETWEEN
)
)) data
GROUP BY

cust_id, cust_number, cust_name,

uom, warehous_code
ORDER BY

cust_number,

uom, warehous_code;


Details
Reporter
vinaysingu
CRM Account
ZenQ
Status
Closed
Assigned
reddog


Priority
Normal
Severity
Minor
Updated
09-28-11 08:27
Resolution
Fixed



Comments

DateUsernameComment
09/28/11 08:27nagesh

Tested in 380 Beta:Issue fixed

09/14/11 11:26reddog

change parent window displayTimePhased and add edit that requires at least one period is selected

09/14/11 11:25svn

Revision: 12448
http://postbooks.svn.sourceforge.net/postbooks/?rev=12448&view=rev
Author: sunsetsolutions
Date: 2011-09-14 15:25:11 +0000 (Wed, 14 Sep 2011)
Log Message:
-----------
Issue #15670:add edit requiring at least one period selected

Modified Paths:
--------------
xtuple/trunk/guiclient/displayTimePhased.cpp

09/14/11 08:47vinaysingu

Querying without selecting any period generates a DB log error in ‘Time-Phased Sales History’ screen

Steps to Reproduce:
1. Sales->Analysis->Time Phased Sales History
2. Select a calendar from the drop down list
3. Un Select all the periods and click on Query button
4. Observe that an error message is displayed and a DB log error is generated

DB log error:
Wed 14. Sep 18:16:12 2011 ERROR: syntax error at or near ")"
LINE 32: )
^
QPSQL: Unable to create query
-- Group: timePhasedSales
-- Name: detail
-- Notes:

SELECT

cust_id, cust_number, cust_name,

uom, warehous_code
-- Loop through each period bucket to find bookings for period

FROM (
SELECT cohist_invcdate,

cust_id, cust_number, cust_name

, warehous_code

, round((cohist_qtyshipped * currtobase(cohist_curr_id, cohist_unitprice, cohist_invcdate)), 2) AS amount
, ' USD-$' ::text AS uom

FROM cohist JOIN itemsite ON (itemsite_id=cohist_itemsite_id)
JOIN item ON (item_id=itemsite_item_id)

JOIN site() ON (itemsite_warehous_id=warehous_id)

JOIN custinfo ON (cohist_cust_id=cust_id)

WHERE ((cohist_invcdate BETWEEN
)
)) data
GROUP BY

cust_id, cust_number, cust_name,

uom, warehous_code
ORDER BY

cust_number,

uom, warehous_code;



Characteristics

Backport
No
CodeReview
Needed
Operating System
all
Doc Flag
False
Copyright Assigned
Yes
HaxTuple
No
Points
None

Files

No Files

Related Documents

TypeNumberDescriptionRelationshipRemove
ProjectXTUPLEAPPSPorted From Mantisx


Subscribers

You do not have permission to view subscribers.


Incident History

DateUsernameFieldChange
09/14/11 08:47vinaysinguNewIncident Added
09/14/11 08:47vinaysinguCharacteristic Backport Added: "No"
09/14/11 08:47vinaysinguCharacteristic CodeReview Added: ""
09/14/11 08:47vinaysinguCharacteristic Operating System Added: "all"
09/14/11 08:47vinaysinguCharacteristic haxTuple Added: "No"
09/14/11 08:47vinaysinguCharacteristic Estimated Hours Added: ""
09/14/11 08:47vinaysinguCharacteristic Doc Flag Added: "False"
09/14/11 08:47vinaysinguCharacteristic Copyright Assigned Added: "Yes"
09/14/11 08:47acdrupalFound In: -> 3.8.0Alpha
09/14/11 11:26reddogCharacteristic CodeReview Changed: "" -> "Needed"
09/14/11 11:26reddogDescription Updated: "Querying without sel..." -> "Querying without sel..."
09/14/11 11:26reddogStatusStatus Changed: New -> Resolved
09/14/11 11:26reddogAssignedAssigned to: "" -> "reddog"
09/14/11 11:26reddogResolutionResolution Changed: -> Fixed
09/14/11 11:26reddogFixed In: -> 3.8.0
09/28/11 08:27nageshDescription Updated: "Querying without sel..." -> "Querying without sel..."
09/28/11 08:27nageshStatusStatus Changed: Resolved -> Closed

 

mead