Is it true that rows in items table are not deleted?

Hi Sten,

You are right, there is something weird about this...

When you delete pages they are usually moved to the trashbin and the attached items will be deleted when you empty the trashbin.
When you delete paragraphs they are also moved to the trashbin, but the attached items will NOT be deleted when you empty the trashbin.
You can also have other kinds of items, e.g. items in an itemlist field, which are also never deleted.

Anyway, if you are going to present any of these items in front end, then I suggest that you...

Use the available template extensions like @RenderItem(...) / @Item.Render() or @RenderItemList(...) / @Item.RenderList to include items in your template.
Use the API for advanced queries instead of querying the database directly. You can use Dynamicweb.Content.Items.Queries.Repository to fetch the items you need.

This can also help to ensure that you don't display items that are inactive / unpublished or items which the user doesn't have permission to access.

Morten

Developer forum