112264 - no subject - We want to show a CDT in a process dashb

Keith over 10 years ago

We want to show a CDT in a process dashboard using ncolumntable function. Since your not suppose to use byreference for a CDT, the question is how can you show the CDT values in a sub process on the parent dashboard. I see you can create a web content channel and point it to a sub process. the issue is when that sub process archives, not what do you show on the parent dashboard. Is there a way to have an if statement that looks if the process is completed, then show data from one process verses showing data from a sub process.

I understand that if we had a data store we could use a query rule and get the data. We don't want to create a SQL table for everything.
Keith

...

Discussion posts and replies are publicly visible

0 joel671 over 10 years ago

I think if you user if(or(isnull(pv!cdt),pv!cdt=""),"",pv!cdt.element). It will hide the fields when the sub process archives.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sswilliams over 10 years ago

The CDT is showing on the process dashboard successfully. However, the date that is showing in the ncolumntable has the letters T and Z in the time stamp - 2014-06-10T07:23:35.100Z What does the T and Z represent and is there a way to get rid of these letters?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 elizabeth.epstein over 10 years ago

They are standard elements of the Date and Time format: www.w3.org/.../NOTE-datetime
T means Time, and Z means it's using UTC.

Where is this data coming from? If it's coming from an Appian DateTime PV, you can try wrapping the entire column in tostring() or todate(). You can also write your own formatting rule using the text() function and apply() it to all the values in the column.

If it's coming from an external service, you'll need to figure out a way to parse it into a different format. Depending on the format you're looking for, I could probably provide more guidance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel