O'Reilly logo

ADempiere 3.6 Cookbook by Ajit Kumar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Developing a new report using view

This recipe describes the steps involved in creating a database view and using it to generate reports.

Getting ready

Complete Chapter 2, ADempiere Customization Part I and Chapter 3, ADempiere Customization Part II and keep the final MOM-related schema handy, as we will be using it in this recipe.

How to do it...

  1. Create the following database view:
    CREATE VIEW adempiere.c_mom_v AS SELECT a.*, b.item_nbr,b.discussion_desc,b.ad_user_id AS actioned_by,b.c_momstatus_id, c.ad_user_id AS participant,c.company, d.name AS status FROM adempiere.c_mom a JOIN adempiere.c_mom_discussionline b ON a.c_mom_id=b.c_mom_id JOIN adempiere.c_mom_participantsline c ON c.c_mom_id=b.c_mom_id JOIN adempiere.c_momstatus d ON b.c_momstatus_id=d.c_momstatus_id; ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required