pretty serious? database view problems in trunk? works in 12.04 and 11.04

[hans_bakker]

I just demo the accounting system to a customer, and tried to create
suppliers to enter a purchase order.

using standard demo data and go to  the purchase order entry screen:
https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry

there the supplier drop-down for purchase order is empty, it uses the
PartyRoleAndPartyDetail view for all parties which have a SUPPLIER
role..... going to look at this view in webtools does not show any records.

I tried it on 11.04:
https://demo-old.ofbiz.apache.org/ordermgr/control/orderentry
and on 12.04 locally where the supplier drop down has content.

anybody who changed something on the entity view after 12.04 could he
have a look?

Regards,
Hans

[hans_bakker]

Ok , i see Jacques already noticed this, the status was added later and
with multiple status records this does not work and for demo data there
is no status records at all....

not that bad...i thought that the general view generation could have an
error.

However i thought Jacques already removed it and it is still there?

remove now?

Regards,
Hans

On 05/24/2013 09:33 AM, Hans Bakker wrote:

> I just demo the accounting system to a customer, and tried to create
> suppliers to enter a purchase order.
>
> using standard demo data and go to  the purchase order entry screen:
> https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry
>
> there the supplier drop-down for purchase order is empty, it uses the
> PartyRoleAndPartyDetail view for all parties which have a SUPPLIER
> role..... going to look at this view in webtools does not show any
> records.
>
> I tried it on 11.04:
> https://demo-old.ofbiz.apache.org/ordermgr/control/orderentry
> and on 12.04 locally where the supplier drop down has content.
>
> anybody who changed something on the entity view after 12.04 could he
> have a look?
>
> Regards,
> Hans
>
>
>
>
>
>

[hans_bakker]

Committed revision 1486016 : removed partystatus from view.

i see nowhere in the ofbiz application the status info is used it just
makes purchase invoicing unusable with demo data.

Regards,
Hans

On 05/24/2013 12:22 PM, Hans Bakker wrote:

> Ok , i see Jacques already noticed this, the status was added later
> and with multiple status records this does not work and for demo data
> there is no status records at all....
>
> not that bad...i thought that the general view generation could have
> an error.
>
> However i thought Jacques already removed it and it is still there?
>
> remove now?
>
> Regards,
> Hans
>
> On 05/24/2013 09:33 AM, Hans Bakker wrote:
>> I just demo the accounting system to a customer, and tried to create
>> suppliers to enter a purchase order.
>>
>> using standard demo data and go to  the purchase order entry screen:
>> https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry
>>
>> there the supplier drop-down for purchase order is empty, it uses the
>> PartyRoleAndPartyDetail view for all parties which have a SUPPLIER
>> role..... going to look at this view in webtools does not show any
>> records.
>>
>> I tried it on 11.04:
>> https://demo-old.ofbiz.apache.org/ordermgr/control/orderentry
>> and on 12.04 locally where the supplier drop down has content.
>>
>> anybody who changed something on the entity view after 12.04 could he
>> have a look?
>>
>> Regards,
>> Hans
>>
>>
>>
>>
>>
>>
>

[Jacques Le Roux]

Hi Hans,

You mean this http://svn.apache.org/viewvc?view=revision&revision=r1470139, right?

I indeed removed only the relation after viewing Adrian's comment

The status was not added later, tt was there when we moved from incubator
http://svn.apache.org/viewvc/ofbiz/trunk/applications/party/entitydef/entitymodel.xml?revision=490457&view=markup&pathrev=490457

There are 74 ref. of PartyRoleAndPartyDetail in whole OFBiz source. Any seems related to status.

It was used with
  <alias-all entity-alias="PS">
    <exclude field="statusId"/>
  </alias-all>
Because Party as already a statusId field

I see at least one case where it's used in

<entity-condition entity-name="PartyRoleAndPartyDetail" list="resources">
    <condition-list combine="and">
        <condition-expr field-name="roleTypeId" operator="equals" value="PROJECT_TEAM"/>
        <condition-expr field-name="statusId" operator="not-equals" value="PARTY_DISABLED"/>
    </condition-list>
    <order-by field-name="lastName"/>
    <order-by field-name="firstName"/>
    <order-by field-name="groupName"/>
</entity-condition>

I believe it's save to completly remove, as you  did.  I don't see any use of statusDate (from PartyStatus)

Jacques

From: "Hans Bakker" <[hidden email]>

> Ok , i see Jacques already noticed this, the status was added later and
> with multiple status records this does not work and for demo data there
> is no status records at all....
>
> not that bad...i thought that the general view generation could have an
> error.
>
> However i thought Jacques already removed it and it is still there?
>
> remove now?
>
> Regards,
> Hans
>
> On 05/24/2013 09:33 AM, Hans Bakker wrote:
>> I just demo the accounting system to a customer, and tried to create
>> suppliers to enter a purchase order.
>>
>> using standard demo data and go to  the purchase order entry screen:
>> https://demo-trunk.ofbiz.apache.org/ordermgr/control/orderentry
>>
>> there the supplier drop-down for purchase order is empty, it uses the
>> PartyRoleAndPartyDetail view for all parties which have a SUPPLIER
>> role..... going to look at this view in webtools does not show any
>> records.
>>
>> I tried it on 11.04:
>> https://demo-old.ofbiz.apache.org/ordermgr/control/orderentry
>> and on 12.04 locally where the supplier drop down has content.
>>
>> anybody who changed something on the entity view after 12.04 could he
>> have a look?
>>
>> Regards,
>> Hans
>>
>>
>>
>>
>>
>>
>