Skip to content

Instantly share code, notes, and snippets.

@accasey

accasey/reset_pinned_tiles_url.sql

Created November 2, 2018 15:05
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save accasey/3ca17d5b034b3882412bb8f5770bdab4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save accasey/3ca17d5b034b3882412bb8f5770bdab4 to your computer and use it in GitHub Desktop.
Download ZIP
Reset the URLs for the pinned tiles
Raw
reset_pinned_tiles_url.sql
-- MSSQL
UPDATE PS_PT_PORTAL_PINTO
SET PORTAL_URLTEXT = REPLACE(PORTAL_URLTEXT,'old_path','new_path')
/
-- ORACLE
UPDATE PS_PT_PORTAL_PINTO
SET PORTAL_URLTEXT = REGEXP_REPLACE(PORTAL_URLTEXT,'old_path','new_path')
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment