on 03-31-2017 4:34 PM
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 ??
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you try the second option I suggested? What was the result? I would encourage you to try out a few methods and come back to the community with what you tried and how it fails.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.