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

Ektron List All PageBuilder Pages

Posted on

SET NOCOUNT ON DECLARE @Domain VARCHAR(50) SET @Domain = ‘/’ SELECT c.[content_id], c.[content_title], c.[content_html], CASE WHEN c.[content_status] = ‘A’ THEN ‘Approved’ WHEN c.[content_status] = ‘O’ THEN ‘Checked Out’ WHEN c.[content_status] = ‘I’ THEN ‘Checked In’ WHEN c.[content_status] = ‘S’ THEN ‘Submitted for Approval’ WHEN c.[content_status] = ‘M’ THEN ‘Marked for…

Read More

Prevent Spaces In Textbox

Posted on

<script type="text/javascript"> function stripspaces(input) { input.value = input.value.replace(/s/gi, ""); return true; } </script> <input type="text" ID="txtUserID" MaxLength="20" onkeyup="javascript:stripspaces(this)" onkeydown="javascript:stripspaces(this)"> Originally Posted on November 7, 2013Last 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…

Read More

UNIX Bash – Random Secure Password

Posted on

Tested on Raspberry Pi but should work on any Debian based OS # Install Dictionaries if [ $(dpkg-query -W -f=’${Status}’ wamerican 2>/dev/null | grep -c "ok installed") -eq 0 ]; then sudo apt install wamerican -y; else echo ‘Already Installed’; fi if [ $(dpkg-query -W -f=’${Status}’ wbritish 2>/dev/null | grep…

Read More