Find Library Item Links In Content

Posted on By David Kittell 
SELECT c.[content_id]
	,c.[content_title]
	,c.[folder_id]
	,cft.[folder_name]
	,cft.FolderPath
	,cft.FolderIdPath
FROM [content] c
INNER JOIN [content_folder_tbl] cft ON c.folder_id = cft.folder_id
WHERE content_html LIKE '%uploadedFiles%'
Originally Posted on May 31, 2014
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Ektron MSSQL MSSQL - Ektron MSSQL - Ektron 8.7 SQL

Related Posts

NetSuite – SuiteScript 1.0 – Useful Functions

Posted on

These first function snippets are from https://gist.github.com/W3BGUY // function to figure out the number of days in month. function getDaysInMonth(thisMonth,thisYear){ var monthArray=[31,28,31,30,31,30,31,31,30,31,30,31]; if(thisMonth!=2){return monthArray[thisMonth-1]}; if(thisYear%4!=0){return monthArray[1]}; if(thisYear%100==0 && thisYear%400!=0){return monthArray[1]}; return monthArray[1]+1; } // NetSuite usage example nlapiLogExecution(‘DEBUG’,getDaysInMonth(11,2016)) // function to add leading zeros on date parts. function zeroPad(num,len){ var…

Read More

UNIX – Create New User & Add To Group

Posted on

username="dkittell" usergroup="developers" useradd $username && passwd $username # Set initial password # Force user to change password once logged in chage -d 0 $username groupadd $usergroup usermod -aG $usergroup $username All information on this site is shared with the intention to help. Before any source code or program is ran…

Read More

Format Zip Code Properly

Posted on

Sometimes a zip code is presented in a database with all nine numbers in the same column that has only five numbers. This query below will assist in formatting the numbers properly. SELECT CASE WHEN len(zip) = 10 AND substring(zip, 6, 1) = ‘-‘ THEN zip WHEN len(zip) = 5…

Read More