Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Problem

This SQL removes any software in the software table where there are unrecognised characters in the name.

Solution

 

DELETE FROM PR_MapSoftwareProduct WHERE softwareid IN (SELECT SoftwareID FROM Software WHERE dbo.regexmatch([softwarename],'[^\u0009\u000a\u000d\u0020-\uD7FF\uE000-\uFFFD]',1)=1);

Filter by label (Content by label)
showLabelsfalse
max5
spaces~Glen.Epperson
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "kb-troubleshooting-article" and type = "page" and space = "~Glen.Epperson"
labelskb-troubleshooting-article

Page Properties
hiddentrue


Related issues