I am trying to become acquainted with the Reporting Add-On. I am getting the basics of it pretty well but I ran into a bit of a wall. I have a many (DEIPRODUCTCONFIG2_PROD_PACKAGE) to many (DEIPRODUCTCONFIG2_ASSEMBLY_CM) relationship that I’m trying to show as a list in my report. So far I can get a single item from the list to show up but I’m at a loss as to how to grab all of the entities and put them in a list.
My query:
select
DEIPRODUCTCONFIG2_PRODUCT.PRODUCT_NUMBER as "productNumber",
DEIPRODUCTCONFIG2_PRODUCT.description as "description",
DEIPRODUCTCONFIG2_PRODUCT.DS_DOC_NUMBER as "dsDocNumber",
DEIPRODUCTCONFIG2_PRODUCT.PACKAGE_SCD_DOC_NUMBER as "packageScdDocNumber",
DEIPRODUCTCONFIG2_PRODUCT.TRAVELER_DOC_NUMBER as "travelerDocNumber",
DEIPRODUCTCONFIG2_PRODUCT_STATUS.FULL_NAME as "status.fullName",
DEIPRODUCTCONFIG2_PROD_PACKAGE.PACKAGE_NUMBER as "packageType.packageNumber",
DEIPRODUCTCONFIG2_ASSEMBLY_CM.NAME as "assemblers"
from DEIPRODUCTCONFIG2_PRODUCT
join DEIPRODUCTCONFIG2_PRODUCT_STATUS
on DEIPRODUCTCONFIG2_PRODUCT_STATUS.ID = DEIPRODUCTCONFIG2_PRODUCT.STATUS_ID
join DEIPRODUCTCONFIG2_PACK_DIE_PROD
on DEIPRODUCTCONFIG2_PACK_DIE_PROD.ID = DEIPRODUCTCONFIG2_PRODUCT.ID
join DEIPRODUCTCONFIG2_PROD_PACKAGE
on DEIPRODUCTCONFIG2_PROD_PACKAGE.ID = DEIPRODUCTCONFIG2_PACK_DIE_PROD.PACKAGE_TYPE_ID
join DEIPRODUCTCONFIG2_PROD_PACKAGE_ASSEMBLY_CM_LINK
on DEIPRODUCTCONFIG2_PROD_PACKAGE_ASSEMBLY_CM_LINK.PROD_PACKAGE_ID = DEIPRODUCTCONFIG2_PACK_DIE_PROD.PACKAGE_TYPE_ID
join DEIPRODUCTCONFIG2_ASSEMBLY_CM
on DEIPRODUCTCONFIG2_ASSEMBLY_CM.ID = DEIPRODUCTCONFIG2_PROD_PACKAGE_ASSEMBLY_CM_LINK.ASSEMBLY_CM_ID;