173229 - no subject - We have a Portal Report that work on ver

mohamedb over 8 years ago

We have a Portal Report that work on version 7.3 to read some data from a CDT process variable. The Department columns in this report is configured to get its value from the following expression.

=if(isnull(pv!cdtHighLevelEstimate1.tDeptAssigned),pv!cdtHighLevelEstimateLevel2.tDeptAssigned,pv!cdtHighLevelEstimate1.tDeptAssigned)

All the other columns are defined using the same CDTs in the same fashion. The Portal Report takes care of formatting and looping; which is nice.

Now, we want to replace this Portal Report with a Dynamic Channel that displayed the table as displayed below. How can we achieve that and loop on the CDTs while doing the same if-condition as we did in Portal Report?

Thanks.

Discussion posts and replies are publicly visible

Parents

0 Chris over 8 years ago

You can achieve this by creating an expression rule which takes your 2 inputs, and decides which one to return by utilizing isnull() as you do above - then in your dynamic grid utilize: apply(rule!yourExpressionHere,merge(pv!cdtHighLevelEstimate1.tDeptAssigned,pv!cdtHighLevelEstimateLevel2.tDeptAssigned)).

Your custom expression rule would have 2 inputs, say Estimate1 and Estimate2, and work as:

=if(isnull(ri!Estimate1),ri!Estimate2,ri!Estimate1)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Chris over 8 years ago

You can achieve this by creating an expression rule which takes your 2 inputs, and decides which one to return by utilizing isnull() as you do above - then in your dynamic grid utilize: apply(rule!yourExpressionHere,merge(pv!cdtHighLevelEstimate1.tDeptAssigned,pv!cdtHighLevelEstimateLevel2.tDeptAssigned)).

Your custom expression rule would have 2 inputs, say Estimate1 and Estimate2, and work as:

=if(isnull(ri!Estimate1),ri!Estimate2,ri!Estimate1)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data