TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
SQL interface to Teamdesk
There are occasions when I need to update many rows in one transaction. i.e. I recently added some fields to an existing table and wanted them to be required fields but as they contained null values in the existing records this turned into a mammoth task. A simple SQL interface where a query such as "update table set column = value" could be executed would have made life so much simpler.
ID
141
Category
User Experience
Author

Denis Barry-Smith
Date Created
6/25/2007 11:44:57 AM
Date Updated
6/25/2007 11:44:57 AM
Status
New Idea
Score
40
Promoted By
Arnold HakobyanMatthew PorterScott Miller
Denis Barry-Smith
Comments
Slava Shinderov  Staff  6/25/2007 12:10:47 PM
Denis,

You have two options:

1. Export table data into Excel using Setup->Table->"Export data from table", fill newly-created column with the data, import data back through Setup->Table->"Import data into table" (you can copy/paste directly from Excel). Please note that it is enough to import just newly-created column and table key column – the system will update existing records.

2. Use formula column. Create formula column first. Use “Change Type” action to convert formula column into a real column. Column value will be calculated for each row and stored into a real column.

Regards,
Slava.
Feedback
 
Back to Search Results