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

mohamedb over 9 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 rameshm over 9 years ago

We are retrieving 2 tables data from the query rule. for couple of columns the data is empty.
for example: taskDueDate is coming from second table but the table does not have any record. so here we are failing. Please help us.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rameshm over 9 years ago

We are retrieving 2 tables data from the query rule. for couple of columns the data is empty.
for example: taskDueDate is coming from second table but the table does not have any record. so here we are failing. Please help us.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data