141806 - no subject - I have an existing legacy table, which d

guozhangy over 9 years ago

I have an existing legacy table, which doesn't have a primary key. Because this table is shared by other applications and I can't add primary key column, which means I can't create CDT for this table.

I want to display the rows from this table in a Grid Report, is there a way to use "Query Database" smart service to retrieve the data from the table and display it in Grid? If yes, can anyone show me the example?

Thank you so much.

Discussion posts and replies are publicly visible

Parents

0 Tim
Certified Lead Developer
over 9 years ago

You can create a database view for this table and create your own primary identifier in the view sql which can then be mapped in the CDT. You could concatenate a selection of fields to create your unique column or use the internal rowid from the database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tim
Certified Lead Developer
over 9 years ago

You can create a database view for this table and create your own primary identifier in the view sql which can then be mapped in the CDT. You could concatenate a selection of fields to create your unique column or use the internal rowid from the database.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data