Hi Daniel,

Generally looks fine, if you remove the .Where do you get a collection ok? E.g var root = Model.AncestorOrSelf("FrontPage").Descendants("LunchDay");

Also, maybe try:

var root = Model.AncestorOrSelf("FrontPage").Descendants("LunchDay").Where("lunchDate == @0", DateTime.Now.Date);

Jeavon

Dammit! I switched the two. It is the lunchCity that is ruining everything. It should look like this:

Before it looked like this:

var root =Model.AncestorOrSelf("FrontPage").Descendants("LunchDay").Where("lunchDate == DateTime.Now.Date");

Now it looks like this and it is not working:

var root =Model.AncestorOrSelf("FrontPage").Descendants("LunchPage").Where("lunchCity == \"Esbjerg\"").Descendants("LunchDay").Where("lunchDate == DateTime.Now.Date");

Ah ok, try this then

var root =Model.AncestorOrSelf("FrontPage").Descendants("LunchPage").Where("lunchCity == @0", "Esbjerg").Descendants("LunchDay").Where("lunchDate == DateTime.Now.Date");

Daniel Larsen  and Jeavon this razor feels odd.  i could be wrong.  Are you in c# or razor?

IPublishedContent root = Model.AncestorOrSef("string parameter").Descendants("string parameter").Where(x=>x.GetPropertyValue("lunchCity).toString() == "Esbjetg").Descendants("LunchDay").Where(x=>x.GetPropertyValue("lunchDate").toString() == DateTime.Now.Date);

It will be more like that.  Needs some tweaking, just done it off the top of my head rather than in visual studio.  Hope this helps.

Hi Charles,

I might be wrong but I think given this is Umbraco v4 we are dealing with a Razor Macro using DynamicNode (stored in MacroScripts) rather than a View/Partial View/Macro Partial View using IPublishedContent (stored in Views). Perhaps Daniel could confirm?

Jeavon

Hi, I have not had time to test the solution yet, but yes, it is v4 and I am using macro scripts.

Thanks :-)

Hi Daniel,

Actually there is a potential problem with this, you would need to select the first "LunchPage" which matches the lunchCity (and check it's not null), e.g.

var root = Model.AncestorOrSelf("FrontPage").Descendants("LunchPage").Where("lunchCity == @0", "Esbjerg").FirstOrDefault();
if (root != null)
{
    var sub = root.Descendants("LunchDay").Where("lunchDate == DateTime.Now.Date");
}

Jeavon

got you, thanks Jeavon :)

is working on a reply...