Retrieve from many to one association.

0
Hi, I have one issue. I cannot able to retrieve in many to one association.   Scenario is -- There are two entities Product and Product Package and between them 1 to many association from Product_ProductPackage. I want to retrieve Product from Product Package in an expression but I cannot because association is not coming in expression.   What I need to can anyone please help me on this?     Attaching screenshots --    Actually, I want the below expression -- if (trim($currentObject/RQSFieldChangeManagement.ProductSelectionHelper_Product/RQS.Product/RQS.Product_RQS/RQS.RQS/Name) != '' and $currentObject/RQSFieldChangeManagement.ProductSelectionHelper_Product/RQS.Product/RQS.Product_RQS/RQS.RQS/Name != empty) then$currentObject/RQSFieldChangeManagement.ProductSelectionHelper_Product/RQS.Product/RQS.Product_RQS/RQS.RQS/Name else''"   in the place of below expression --   if (trim($currentObject/RQSFieldChangeManagement.ProductPackageSelectionHelper_ImportedProductPackage/RQSFieldChangeManagement.ImportedProductPackage/RQSFieldChangeManagement.ImportedProductPackage_ImportedConfiguration/RQSFieldChangeManagement.ImportedConfiguration/DisplayName) != '' and $currentObject/RQSFieldChangeManagement.ProductPackageSelectionHelper_ImportedProductPackage/RQSFieldChangeManagement.ImportedProductPackage/RQSFieldChangeManagement.ImportedProductPackage_ImportedConfiguration/RQSFieldChangeManagement.ImportedConfiguration/DisplayName != empty) then$currentObject/RQSFieldChangeManagement.ProductPackageSelectionHelper_ImportedProductPackage/RQSFieldChangeManagement.ImportedProductPackage/RQSFieldChangeManagement.ImportedProductPackage_ImportedConfiguration/RQSFieldChangeManagement.ImportedConfiguration/DisplayName else''"     I was trying with  (please consider first line). but "RQS.ProductPackage_Product" is not coming, so that I can retreive the first expression (Product from ProductPackage association, which I want and proceed for "Name").   Note --  1st module Domain Model -- RQS 1<---* Product *---->1 Product Package 2nd module Domain Model -- ProductPackage 1<----* ProductPackageSelectionHelper (np entity) *---->1 Imported Product Package  *------>1 Imported Configuration *---->1 RQS   If anything, not clear please ask.
asked
1 answers
0

Hi Sweety,

First take a dataview -> take datasource as microflow -> inside this microflow take a retrieve activity and retrieve your object from database & in the range select first and in the xpath pass your association & return the object.

 

Go to on your dataview -> inside this dataview now perform your expression.

 

 

I hope you like the answer.

answered