Skip to Content
avatar image
Former Member

Calculation View Passing Value from one input parameter to Another input parameter

I have a CalculationViewB where i have to filter a Company ID field on basis of CalculationViewA Company ID field but the client wants a descriptive field (Company Name) in drop down at the time of execution as input parameter.

CalculationViewA has two field Company ID and Company Name i.e 3048 ABB

So at the time of execution Client will get a drop down on basis of INPUT PARAMETER 1 that is CompName and at the view level it will filter on basis of INPUT PARAMETER 2 that is CompID.

i.e Client will select Input Parameter CompName: ACC and internally CalculationViewB will get filter on basis of Input Parameter 2 CompID: 1225

Filter: CompanyID =$$CompID$$


Will parameter mapping work in aforesaid scenario ?? Or

Do i have to use scripted calculation view? Or

Is there any other way ??

inputparameter.jpg (60.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 31, 2017 at 05:28 PM

    I see the CalcviewB has both company code and company name, so what is the issue in filtering company name directly based on user input? CompName = $$IP_CompName$$

    OR

    Include ClacviewA as a node in CalcviewB. Filter NodeA as CompName = $$IP_CompName$$. Inner join tjhis with projection in CalcviewB on CompanyCodeB = CompanyCodeA


    Add comment
    10|10000 characters needed characters exceeded