This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Diagnostics; | |
using System.Linq; | |
using System.Web; | |
using System.Web.Mvc; | |
using Umbraco.Web.Mvc; | |
using Umbraco.Web; | |
using Examine; | |
using UmbracoExamine; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--ALL UNPUBLISHED CONTENT (COMPLETELY UNPUBLISHED) | |
SELECT un.id, un.text FROM umbracoNode un | |
INNER JOIN cmsDocument cd ON un.id = cd.nodeId | |
WHERE cd.newest = 1 AND cd.published = 0 | |
AND (SELECT COUNT(a.nodeId) FROM cmsDocument a WHERE a.nodeId = un.id AND a.published = 1 AND a.newest = 0) = 0 | |
--ALL UNPUBLISHED CONTENT (COMPLETELY UNPUBLISHED), EXCLUDING DELETED ITEMS | |
SELECT un.id, un.text FROM umbracoNode un | |
INNER JOIN cmsDocument cd ON un.id = cd.nodeId | |
WHERE cd.newest = 1 AND cd.published = 0 AND un.path NOT LIKE '%-21,%' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.IO; | |
using System.Linq; | |
using System.Net; | |
using System.Text; | |
using System.Web; | |
using System.Web.Mvc; | |
using Umbraco.Core.Models; | |
using Umbraco.Web; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//test each method, synchronously | |
var promises = []; | |
promises.push($.ajax({ | |
url: '/umbraco/surface/benchmark/AllChildrenFromNode', | |
success: function (resp) { | |
var num = parseFloat(resp); | |
console.log('All By Direct Children: ' + num); | |
}, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.Collections.Generic; | |
using System.Diagnostics; | |
using System.Linq; | |
using System.Web; | |
using System.Web.Mvc; | |
using Umbraco.Web.Mvc; | |
using Umbraco.Web; | |
using Examine; | |
using UmbracoExamine; |