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.
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;