Showing results for 
Show  only  | Search instead for 
Did you mean: 

App Portal / App Broker

Is it possible to globally update  a Catalog Title name that has a specific common word in each title.  We would like to find the common word and replace /rename it with another.  We have hundreds of Catalog items needing a specific word rename and would not like to open each one to rename.


(2) Replies
By Level 12 Flexeran
Level 12 Flexeran

The catalog item titles are stored in the WD_WebPackages table in the column PackageTitle.. As such, I think that a query similar to the following would work for you.. 

update WD_webpackages
set PackageTitle = Replace(PackageTitle, 'notepad', 'textpad')

The above query will replace the word "notepad" with "textpad" for every row (for each catalog item)

Hi Charles,

Thanks for the information!  Really appreciate the quick reply.