I already feared this, but could solve it by using the uComponents SQL Dropdown and uComponents SQL Autocomplete.
If anyone, needs my SQL to filter out all Nodes by doctype, here it is:
SELECT N.id As Value, N.text As Text FROM cmsContent AS C INNER JOIN cmsContentType AS CT ON C.contentType = CT.nodeId INNER JOIN umbracoNode AS N ON C.nodeId = N.id WHERE CT.alias = 'Company' ORDER BY N.text
Xpath Dropdownlist and uComponents Xpath Autcomplete do not show unpublished content
Hi,
The XPath Dropdownlist and uComponents Xpath Autocomplete datatypes are only showing published content as listoptions.
Is there any possibility to include unpublished content?
My Xpath expression is very easy: //Company
Hi Rubinho,
Unfortunately not, as the XML data source only contains the published nodes.
Thanks Hendy,
I already feared this, but could solve it by using the uComponents SQL Dropdown and uComponents SQL Autocomplete.
If anyone, needs my SQL to filter out all Nodes by doctype, here it is:
SELECT N.id As Value, N.text As Text FROM cmsContent AS C INNER JOIN cmsContentType AS CT ON C.contentType = CT.nodeId INNER JOIN umbracoNode AS N ON C.nodeId = N.id WHERE CT.alias = 'Company' ORDER BY N.text
is working on a reply...