Skip to content

Data Source Sql

Jump to bottom Edit New page
Hendy Racher edited this page May 30, 2017 · 5 revisions

SQL examples using the Umbraco database:

Umbraco Member Type Picker

SELECT      id AS 'Key',
            [text] AS 'Label'
FROM        umbracoNode
WHERE       nodeObjectType = '9B5416FB-E72F-45A9-A07B-5A9A2709CE43'
ORDER BY    Label

Umbraco Member Group Picker

SELECT      id AS 'Key',
            [text] AS 'Label'
FROM        umbracoNode
WHERE       nodeObjectType = '366E63B9-880F-4E13-A61C-98069B029728'
ORDER BY    Label

Umbraco Macro Picker

SELECT      id AS 'Key',
            macroName AS 'Label'
FROM        cmsMacro
ORDER BY    Label

Hard-coded collection

SELECT * FROM 
(VALUES 
	('key1', 'label3'), 
	('key2', 'label3'), 
	('key3', 'label3')
) x([Key], Label)

Property Editors

Add a custom footer
Clone this wiki locally