Hi Everyone: I was trying to build a report using CDT. However, there

@lins Isn't the time attribute part of your CDT?

@sikhivahans No, it's not. I use the time stamp captured by the SQL database.

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.

You can create a view based on your main CDT and include the time column into the view, if you don't want to change the structure of existing main CDT.

After creating a view, create a CDT for the view containing the extra time field and a datastore entity of the same CDT type. Now, you can create a constant of the type datastore entity holding the value of datastore entity for your view.

You can use this constant to create your report through report builder.

@nileshr thanks very much! I have created a view through SQL and a CDT (please see the attached screenshot). How can I connect the CDT with the view data from SQL?
TIA!