Kentico CMS 7.0 Developer's Guide

Managing data in custom tables

Managing data in custom tables

Previous topic Next topic Mail us feedback on this topic!  

Managing data in custom tables

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

As a content editor, you can manage data stored in custom tables in CMS Desk -> Tools -> Custom tables. As an administrator, you can access the same interface through Site Manager -> Development -> Custom tables -> edit (Edit) -> Data as well.

 

devguide_clip0526

 

Adding data into custom tables

 

This example uses the People custom table that you have created if you followed the Creating custom tables chapter. The procedure is the same for any other custom table (except for the fields, which are always specific for a particular table).

 

1. Navigate to CMS Desk -> Tools -> Custom tables.

 

2. Click the Edit (Edit) icon next to the People table.

 

3. Click the NewRecord New item button.

 

4. Fill in any values.

 

devguide_clip2285

 

5. Click Save Save to store the data into the custom table.

 

6. Use the NewRecord Create another button and create at least two more records.

 

Viewing data in custom tables

 

This example uses the People custom table that you have created if you followed the Creating custom tables chapter. The procedure is the same for any other custom table (except for the fields, which are always specific for a particular table).

 

1. Navigate to CMS Desk -> Tools -> Custom tables.

 

2. Edit (Edit) the People custom table. The system displays the list of entries in the custom table.

 

devguide_clip2284

 

3. Click the SelectFields Select displayed fields button. The system displays the Select displayed fields dialog box.

 

4. Turn the check-boxes on for the fields that you want to display.

 

devguide_clip2283

 

5. Click OK. You can now see the modified view of the entries.

 

devguide_clip2282

 

6. Click the View (View) icon next to any of the data records. The system displays a dialog box with detailed information about the entry.

 

devguide_clip2281

 

Note that you can also create custom filter for listing custom table data using alternative forms.