[jira] Updated: (OFBIZ-501) Allow orders with discontinued products to be modified...

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-501) Allow orders with discontinued products to be modified...

Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ray Barlow updated OFBIZ-501:
-----------------------------

    Attachment: orderview_discontinued_product.patch

> Allow orders with discontinued products to be modified...
> ---------------------------------------------------------
>
>                 Key: OFBIZ-501
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-501
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Improvement
>          Components: order
>    Affects Versions: SVN trunk
>         Environment: N/A
>            Reporter: Ray Barlow
>         Assigned To: Jacopo Cappellato
>         Attachments: order_edit_discontinued.patch, orderview_discontinued_product.patch
>
>
> Problem:
> Customers are placing orders for product X but it's end of line and you run out so you discontinue the product in the catalogue manager. Unfortunately at this point you will no longer be able to edit existing orders containing product X for any reason as the load routine checks the discontinued date for all items and throws an exception.
> Solution:
> For this improvement I've added an extra boolean to allow the suppression of this test so you can cancel other line items and edit quantites etc as may be required by customers.
> It does not allow, rightly so in my mind, the addition of a discontinued product into an existing order, or from quotes and shopping lists etc.

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

SQL Join

Michael Irving
I'm trying to figure out how to setup a join with findAll or
findByCondition.  Essentially, the query I want to do is something like:

SELECT col1, col2
  FROM WorkOrderItemFulfillment wf
      ,WorkEfforts we
  WHERE we.workeffortId = wf.workeffortId
    AND wf.workEffortParentId IS NULL;


Can someone point me in the right direction?

Thanks