#115 fix services report

closed
nobody
None
5
2011-05-27
2010-03-16
No

This is a patch to a recent checkout of Trunk from SVN.

After adding a service, attempt to view the service from search for
services (Goods and Services, Reports, Services) resulted in an error:

DBD::Pg::st execute failed: ERROR: column pv.entity_id does not exist
LINE 7: JOIN entity e ON (e.id = pv.entity_id)
^ at LedgerSMB/IC.pm
line 181.

With recent changes to the partsvendor table, column entity_id no longer
exists.

With this change, the entity table is joined through the vendor view
rather than directly to the partsvendor table. The vendor view does have
a foreign key to the entity table and was already joined to partsvendor
in the query.

Discussion

  • Chris Travers

    Chris Travers - 2011-05-27

    previously committed.

     
  • Chris Travers

    Chris Travers - 2011-05-27
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks