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

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.


OriginalPostID-173229



  Discussion posts and replies are publicly visible

Parents
  • Note, I noticed a type in the table expression. Try:

    =ncolumntable(
              {"text1","text2","text3"},
              apply(rule!getPipelineData1,merge(pv!cdtHighLevelEstimate1.tDeptAssigned,pv!cdtHighLevelEstimateLevel2.tDeptAssigned)),
              apply(rule!getPipelineData2,merge(pv!cdtHighLevelEstimate1.iTaskId,pv!cdtHighLevelEstimateLevel2.tStatus,pv!cdtHighLevelEstimate1.tStatus)),
              apply(fn!text,apply(fn!todate,apply(rule!getPipelineData2,merge(pv!cdtHighLevelEstimate1.iTaskId,pv!cdtHighLevelEstimateLevel2.dTaskDueDate,pv!cdtHighLevelEstimate1.dTaskDueDate))),"mmm dd, yyyy")
    )
Reply
  • Note, I noticed a type in the table expression. Try:

    =ncolumntable(
              {"text1","text2","text3"},
              apply(rule!getPipelineData1,merge(pv!cdtHighLevelEstimate1.tDeptAssigned,pv!cdtHighLevelEstimateLevel2.tDeptAssigned)),
              apply(rule!getPipelineData2,merge(pv!cdtHighLevelEstimate1.iTaskId,pv!cdtHighLevelEstimateLevel2.tStatus,pv!cdtHighLevelEstimate1.tStatus)),
              apply(fn!text,apply(fn!todate,apply(rule!getPipelineData2,merge(pv!cdtHighLevelEstimate1.iTaskId,pv!cdtHighLevelEstimateLevel2.dTaskDueDate,pv!cdtHighLevelEstimate1.dTaskDueDate))),"mmm dd, yyyy")
    )
Children
No Data