I'm guessing the drop down is returning the ID of the prevalue rather than the text for the prevalue. If that's the case, something like this may work:

var dtService = ApplicationContext.Services.DataTypeService;
var selection = Model.Content.AncestorOrSelf(1)
    .FirstChild(x => "SurveyRepository".InvariantEquals(x.DocumentTypeAlias))
    .Children.Where(x => "Surveys".InvariantEquals(x.DocumentTypeAlias))
    .Where(x => "mon".InvariantEquals(dtService.GetPreValueAsString(x.GetPropertyValue<int>("chooseARegion"))));

Note also that I converted from the dynamic syntax to the normal syntax (or whatever it's called). Gives you better intellisense.

Also, note that GetPreValueAsString can be very slow, so you'll probably want to add some caching to help optimize that.

EDIT: Actually, after rereading what you said, it may just be that you aren't checking the CSV for an item within the CSV. So maybe split the value on commas and then check if one of the items is "mon"?

yes, if it's normal checkbox list. it will be comma seperated. so you need to split it

so the where (using the same syntax as Nicholas) would be

   .Where(x => x.HasProperty("chooseARegion") &&
   x.GetPropertyValue<string>("chooseARegion","").Split(',').Contains("mon"));

Thanks Kevin, Nicolas.

I'll give this a try!

Darren

Hi Kevin, Nicolas,

Sorry for the delay getting back to you. Sorry, this is throwing up an error loading. Here's the macro - I'm sure this is something I'm doing.

@inherits Umbraco.Web.Macros.PartialViewMacroPage

@{

var dtService = ApplicationContext.Services.DataTypeService;
var selection = Model.Content.AncestorOrSelf(1)
.FirstChild(x => "SurveyRepository".InvariantEquals(x.DocumentTypeAlias))
.Children.Where(x => "Surveys".InvariantEquals(x.DocumentTypeAlias))
.Where(x => x.HasProperty("chooseARegion") && x.GetPropertyValue<string>("chooseARegion","").Split(',').Contains("Bellshill"));

}

<ul style="padding:0px; margin:0px; list-style:none !important;">
@foreach(var item in selection){
    <li style="padding:0px; margin:0px; list-style:none !important;">
        <a style="width: 100%;" class="survey" target="_blank" href="@item.surveyUrl")">@item.Name</a>
    </li>
}
</ul>

This image illustrates what I'm trying to achieve - when the user selects Bellshill from the checkbox, the survey ONLY appears on the Bellshill page. Apologies for my ignorance :-)

Thanks again for your help.

Darren

Hi Nicolas,

Here's the output from the log

2016-08-15 16:52:44,106 [P2648/D7/T115] WARN umbraco.macro - Error loading Partial View (file: ~/Views/MacroPartials/Surveys.cshtml). Exception: System.Web.HttpCompileException (0x80004005): c:\inetpub\cld\Views\MacroPartials\Surveys.cshtml(18): error CS1061: 'Umbraco.Core.Models.IPublishedContent' does not contain a definition for 'surveyUrl' and no extension method 'surveyUrl' accepting a first argument of type 'Umbraco.Core.Models.IPublishedContent' could be found (are you missing a using directive or an assembly reference?) at System.Web.Compilation.AssemblyBuilder.Compile() at System.Web.Compilation.BuildProvidersCompiler.PerformBuild() at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate) at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound) at System.Web.Compilation.BuildManager.GetCompiledType(VirtualPath virtualPath) at System.Web.Mvc.BuildManagerCompiledView.Render(ViewContext viewContext, TextWriter writer) at Umbraco.Core.Profiling.ProfilingView.Render(ViewContext viewContext, TextWriter writer) at Umbraco.Web.Mvc.ControllerExtensions.RenderViewResultAsString(ControllerBase controller, ViewResultBase viewResult) at Umbraco.Web.Macros.PartialViewMacroEngine.Execute(MacroModel macro, IPublishedContent content) at umbraco.macro.LoadPartialViewMacro(MacroModel macro) at umbraco.macro.renderMacro(Hashtable pageElements, Int32 pageId)

Thanks for getting back to me.

Darren

I should check the log more often! [email protected] sorts the error (will need a link added, but one problem at a time ;-)). However, then @item.Name appears on every page not just the bellshill page - so I need @item.Name to display when the datatype checklist name matches the node name. Would changing InvariantEquals(x.DocumentTypeAlias) to InvariantEquals(x.NodeName) have any effect?

Cheers Darren

Convert this:

<a style="width: 100%;" class="survey" target="_blank" href="@item.surveyUrl")">@item.Name</a>

To this:

<a style="width: 100%;" class="survey" target="_blank" href="@(item.GetPropertyValue<string>("surveyUrl"))")">@item.Name</a>

Since you were using dynamic syntax before and you are no longer using the dynamic data, you'll have to convert to the explicit syntax.

is working on a reply...