Hiya Chris,

I think you should be able to do this with the IContentService. The IContentService has methods like GetDescendants(int nodeId) with an overload, which takes an IContent. This gets the descendant IContents of a current IContent.

So, bascially:

var contentService = ApplicationContext.Services.ContentService;
var rootContent = contentService.GetById(1234) // should not be hardcoded, this is just for having a starting point.
var rooms = contentService.GetDescendants(rootContent).Where(x => x.ContentType.Alias.Equals("room") && HasProperty("numberOfChairs) && x.GetValue<int>("numberOfChairs") > 5);

Things to note about this:

1. the GetDescendants() call can be slow if there's a lot of child (and sub-child) nodes in the tree.
2. using the IContentService performs database calls, afaik (correct me if I'm wrong here) which also is not very performant. However, it's needed to get the unpublished nodes aswell.

An alternative is the method GetContentOfContentType(int id) method on the IContentService, but this should only ever be used if you are certain you want all nodes of a given type. I.e., this might not be the case when running multilingual sites.

Hope this helps any :-)

All the best,

Bo

Hi Chris,

You could do something like:

var _buildingNode = Umbraco.TypedContentAtRoot().DescendantsOrSelf("buildDocumentTypeAlias").FirstOrDefault();
var _rooms = _buildingNode.Descendants("roomsDocumentType").Where(a => int.Parse(a.GetPropertyValue("numberOfChairs")) > 5);

/Michael

Caveat emptor: this will be DB-heavy, but should do the trick.

var roomType = ApplicationContext.Current.Services.ContentTypeService.GetContentType("Room");
        var allRoomsWithFiveChairs = ApplicationContext.Current.Services.ContentService.GetContentOfContentType(roomType.Id)
            .Where(p => p.HasProperty("NumberOfChairs") && p.GetValue<int>("NumberOfChairs") > 5);

        var buildings =
            allRoomsWithFiveChairs.Select(p => p.Ancestors().Single(b => b.ContentType.Alias == "Building"));

Hi Chris,

I presume it needs to be the structure that you said because there are pages for each of Building > Floor > Room ?

My answer if not would be to store all the data on the Building node but I guess you're stuck with that structure.

If not, how about using Examine to search the Room nodes and then when you have the result display the Parent.Parent or if thats not possible with IContent (not done much with it sorry) you could query the path put that into a comma separated array and go 2 levels up.

Sorry if I've misunderstood any of your requirement!

Ben

Hi All,

I think you must all be thirsty, I mentioned beer on twitter and this thread just lit up :-)

Thank you all for your replies, really appreciated.

I think Benjamin Howarth has quite possibly hit the nail on the head, I will give it a go and get back to the thread shortly.

Cheers, Chris

You didn't say 'correctly answering' so can I just get a beer?

Just edited my answer above to filter out the doc types. I fully admit that Ben Howarth's answer is more readable and I really like the way he thought about it the other way round but my answer'll work just as well :)

J

Hi All,

Thank you all for your replies, in the end I actually ended up using Jule's solution hence I marked it as the solution, however I think Ben Howarth also provided a good solution as well.

I have not had the chance to test if one out performs the other, maybe if I ever get some spare time I will test it.

Thanks again for all your quick responses and for Richard Terris... you can have a half ;-)

Cheers,

Chris

is working on a reply...