I just tried another property on this with perfect results:

var result = Umbraco.TypedContent(56752);

var age = result.GetPropertyValue<int>("age");
var ageProp = result.GetProperty("age");

var contentService = ApplicationContext.Current.Services.ContentService;
var contentResult = contentService.GetById(56752);

var ageContent = contentResult.GetValue<int>("age");

All came out at 60. Strange

var ispbInt = result.GetPropertyValue

Also gives 0, when using Umbraco "Helper"

var properties = result.Properties;

on the UmbracoHelper result gives me 13 properties ias XmlPublishedProperty. One of these is "ispb' and is set to false.

How odd.

Incidentally, there are three versions of this property for this result in [cmsPropertyData]. One is null, one is 0 and one is 1.

There are also four versions of the result document. The versionid guid of the most recently saved result document is repeated in the correct property data row.

So how to I get UmbracoHelper to choose the most recent one? I don't think this is my job as a simple developer of an Umbraco website, C# programmer or no.

Hi Amanda

Yes you are right the ContentService is not to be used on the frontend of the website, it interacts directly with the Umbraco database, which is not optimised for querying data and UmbracoHelper is the 'way to go'; or for large numbers of nodes use Examine search.

When you publish content with Umbraco, the content for the pages is inserted/updated into the Umbraco Xml Cache file, which is just an xml file in app_data/umbraco.config.

When you use UmbracoHelper it is this XML file in memory that is being queried, which improves the speed of returning the published content.

You've possibly seen the reference stuff on UmbracoHelper here ? https://our.umbraco.org/documentation/Reference/Querying/UmbracoHelper/

Anyway from what you are typing I think you are already up-to-speed with that...

So yes your specific thing:

var result = Umbraco.TypedContent(56752); 
var ispb = result.GetPropertyValue("ispb");

GetPropertyValue returns an object here - but there is a strongly typed overload so you can write:

var ispb = result.GetPropertyValue<bool>("ispb");

which should then cast the result to be a true/false boolean value.

If you are querying for all content with ispb property true you should be able to write something like:

Umbraco.TypedContentAtRoot().First().Descendants().Where(f => f.IsVisible() && f.HasProperty("ispb") && f.HasValue("ispb") && f.GetPropertyValue<bool>("ispb"));

to return an IEnumerable

Hi Amanda, Can you please post your Document Type showing the property in question (screen shot if you like)...

Also, after publishing, open up the ~/App_Data/umbraco.config file and search for the node you are expecting the true value on. Sure fire way to know whether the cache is being refreshed properly or not.

Apart from that, as mentioned previously you should never ever be using ContentService for querying data in the front end - it's okay if you need to update something in response to a user action, but that's pretty much the only time.

Yes, I know I shouldn't be using ContentService. I did mention that in the very first part of this thread.

Here is the entry in umbraco.config

as you can see, not even the "age" is filled in here, which is strange, as I can access that value via UmbracoHelper.

ok, so, what happens to the cache when you edit another property? Is it updated?

And can you confirm the value of the property after save and publish that it's still true?

So are you importing the Race Results? What happens if you un-tick this property and re-tick it? What is the value of the property type when you import it? Is it a bool? An int? This may be the root of your problem if the import isn't converting the property value before assigning it.

Having said that, perhaps I missed out on how to update the cache/xml files in the website project after using the backend project? How do I update them (aside from republish, which doesn't seem to cut it)?

Ho did you tick the entries? Are you programmatically setting the values, or just using the backoffice UI?

The only thing I can think of that may be causing this is that the wrong value type is being saved back to the property.

The other thing you could try is go to the log file in ~/app_data/logs and see if there are any errors reported there when you try to save the document...

I have just deleted umbraco.config again and all the ExamineIndexes files. Then run the website again. Still the wrong value for "ispb" when using the UmbracoHelper right one when using contentservices. In fact, even the "age" is not incorrect when using the UmbracoHelper (but not the content service).

Actually all 13 properties are now marked as hasValue = false

At my wits' end here. I think it is something simple. Looks like manipulating data using content (and other) service from a separate project has led to problems.

Hi Amanda, Try stopping and re-starting the website service. Also, has there been any errors reported in the log file?

Next hair pulling avoiding step

Would be to find one race result in the back office content tree

Open it

Look on Properties tab - what url does it say it is published under ? Take a note of it's Id

What is the status of the ispb checkbox property ?

Check it.

Save and Publish the node.

Open up your Umbraco.Config file on disc, find the element with the Id of the race result you have just published, find it's ispb property in the xml, what is the value stored there ?

If the entity isn't in the xml config cache, there is a different problem to the Umbraco Helper not returning the right value - if it is there, and it is a boolean value, then test UmbracoHelper on that particular NodeId, is the correct value returned using .GetPropertyValue

If you used Save on the content service when importing the items will not be published in Umbraco.

Republishing the site, won't cause nodes that have not been published before to become published.

The content service has a PublishWithStatus method, if you wanted to update the cache after each result import. (but import will take longer)

Agree you are really close !!

Ok, I opened up a known result in the Umbraco back office. This one had pb marked as true. I published this result. Then I used UmbracoHelper to fetch it and find the value of "ispb". It came back true!!! Hooray!

I can't get too excited about doing this manually on 6000 plus results. Marc, you mentioned publishwithstatus and import. I don't know what import is in this context.

How about if I use publishwithstatus on each result? I'd do this with contentservice in the console application I have been using to put data into Umbraco.

Amanda

is working on a reply...