Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
8 subscribers
Views
2361 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
User Interface
Hi Everyone: I was trying to build a report using CDT. However, there
lins
over 9 years ago
Hi Everyone:
I was trying to build a report using CDT. However, there's a critical variable (time) which only stored in our SQL database. The time variable shows when the update on each project was entered.
How can I include the time variable stored in our SQL database?
Thanks for the help in advance!
OriginalPostID-146253
OriginalPostID-146253
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 9 years ago
There are two ways of doing so:
1. You could make the time stamp attribute a part of CDT by modifying the existing data structure (CDT and view/ table).
2. You can query the timestamp value separately and join to your CDT on a conditional basis (Refer plugin:
forum.appian.com/.../summary)
or build a temporary label/ value pair (existing CDT data + new column) and thereby use it in constructing the grid.
Please do let me know if you have any follow up questions.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 9 years ago
There are two ways of doing so:
1. You could make the time stamp attribute a part of CDT by modifying the existing data structure (CDT and view/ table).
2. You can query the timestamp value separately and join to your CDT on a conditional basis (Refer plugin:
forum.appian.com/.../summary)
or build a temporary label/ value pair (existing CDT data + new column) and thereby use it in constructing the grid.
Please do let me know if you have any follow up questions.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data