[jira] Created: (OFBIZ-1115) OrderReportView has an unjoined table

[Nicolas Malin (Jira)]

OrderReportView has an unjoined table
-------------------------------------

                 Key: OFBIZ-1115
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1115
             Project: OFBiz
          Issue Type: Bug
          Components: order
    Affects Versions: SVN trunk
            Reporter: Adam Heath


OrderReportView.shipMethod comes from the alias SMT; however, that alias is never joined to any other table.

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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12509561 ]

Jacopo Cappellato commented on OFBIZ-1115:
------------------------------------------

Hi Adrian,

do you have a patch for this? By the way, thanks for the bug report.

> OrderReportView has an unjoined table
> -------------------------------------
>
>                 Key: OFBIZ-1115
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1115
>             Project: OFBiz
>          Issue Type: Bug
>          Components: order
>    Affects Versions: SVN trunk
>            Reporter: Adam Heath
>
> OrderReportView.shipMethod comes from the alias SMT; however, that alias is never joined to any other table.

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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-1115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12509592 ]

Adam Heath commented on OFBIZ-1115:
-----------------------------------

Um, I'm Adam, not Adrian.

No, I don't have a patch.  I am unfamiliar with the order system.  I am working on the entity engine(sql-based querying), and it reported this error.  I figured it'd be better to have it reported, so someone else with more knowledge could fix it, rather than leaving it as a hidden problem.

I did verify that the jasper report driven by this view does use the unjoined field in question, so it does need to be fixed.

> OrderReportView has an unjoined table
> -------------------------------------
>
>                 Key: OFBIZ-1115
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1115
>             Project: OFBiz
>          Issue Type: Bug
>          Components: order
>    Affects Versions: SVN trunk
>            Reporter: Adam Heath
>
> OrderReportView.shipMethod comes from the alias SMT; however, that alias is never joined to any other table.

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

[Nicolas Malin (Jira)]

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

Jacopo Cappellato reassigned OFBIZ-1115:
----------------------------------------

    Assignee: Jacopo Cappellato

> OrderReportView has an unjoined table
> -------------------------------------
>
>                 Key: OFBIZ-1115
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1115
>             Project: OFBiz
>          Issue Type: Bug
>          Components: order
>    Affects Versions: SVN trunk
>            Reporter: Adam Heath
>            Assignee: Jacopo Cappellato
>
> OrderReportView.shipMethod comes from the alias SMT; however, that alias is never joined to any other table.

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

[Nicolas Malin (Jira)]

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

Jacopo Cappellato closed OFBIZ-1115.
------------------------------------

    Resolution: Fixed

Thanks *Adam*

I've removed the entity and two fields from the reports that couldn't stay there... I guess that we should remove that old stuff sooner or later.

> OrderReportView has an unjoined table
> -------------------------------------
>
>                 Key: OFBIZ-1115
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1115
>             Project: OFBiz
>          Issue Type: Bug
>          Components: order
>    Affects Versions: SVN trunk
>            Reporter: Adam Heath
>            Assignee: Jacopo Cappellato
>
> OrderReportView.shipMethod comes from the alias SMT; however, that alias is never joined to any other table.

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