picture of people

Sign In

Simplify your workflow in minutes.

Don't have an account yet? Sign up.

entity
  • Articles
  • Documentation
  • Changelog
  1. Docs
  2. Introduction
Getting started
  • Docs
  • APIs
  • Technical overview
  • Roadmap
  • Changelog v 5.10
Tags
  • <er:comparevalue />
  • <er:fieldeditor />
  • <er:iffalse></er:iffalse>
  • <er:ifnovalue></er:ifnovalue>
  • <er:iftrue></er:iftrue>
  • <er:ifvalue></er:ifvalue>
  • <er:image />
  • <er:include />
  • <er:item />
  • <er:itemlist />
  • <er:link></er:link>
  • <er:mailto />
  • <er:query></er:query>
  • <er:value />
Pages
  • API docs
  • Artikkellister - eRedaktør tagger
  • CurrentItem
  • Egendefinert spørring i rendering
  • Feltsett (templates)
  • Get the title from the current page in list element/building block
  • Layouts - en innføring
  • Menupath settings
  • Muligheter og tagger i layouts
  • Release roadmap
  • Rendering - eRedaktør tagger
  • Rendering - WebUserControl (ascx)
  • Rettigheter
  • Språkstyring
  • Søk i eRedaktør (non Lucene)
  • Technical overview
  • Util-class

Remove all unused attribute values

Another quick fix to clean up the database a bit.

Run the following query to delete all attribute values for items that does not exist.

Delete From itemfieldvalue Where itemid Not In (Select itemid From item)