Hi,
I have a website where I store nodes and search them with lucene - by keyword and I return the results sorted by updateDate. I have custom search indexes and in addition I have some custom logic in Umbraco.Core.Services.ContentService.Published += _contentServiceEventHandlers.ContentService_Published;
My website users can vote for this nodes. The problem is that when a user vote for node the updateDate updates and this node is shown before the others. Is there a way to prevent this. I don't want the updateDate to be changed when a user votes. I use very simple solution for voting - I just have a property in the node "Rating" and I use SaveAndPublish() to save the rating.
I was thinking to create additional field lastUpdateDate and to make the sorting over this field but as I metioned I already have a lot of custom logic in Published event and I don't know who is making the Published event - users with voting or the site admins. If the site admins are publishing then the lastUpdateDate should be updated as well. Is there a way to know who is publishing?
Personally I don't think storing user votes in content is good solution.
Why ?
Each time you update the vote in the content you will publish the item again. This will empty the Umbraco cache, examine indexes need to be rebuild etc...
Causing a performance hit.
It's better to store this kind of information in your own datasource, for example a database table.
Here are some blogs explaing how you can use your own tables with umbraco.
Publishing Events
Hi, I have a website where I store nodes and search them with lucene - by keyword and I return the results sorted by updateDate. I have custom search indexes and in addition I have some custom logic in
Umbraco.Core.Services.ContentService.Published += _contentServiceEventHandlers.ContentService_Published;My website users can vote for this nodes. The problem is that when a user vote for node the updateDate updates and this node is shown before the others. Is there a way to prevent this. I don't want the updateDate to be changed when a user votes. I use very simple solution for voting - I just have a property in the node "Rating" and I use SaveAndPublish() to save the rating.
I was thinking to create additional field lastUpdateDate and to make the sorting over this field but as I metioned I already have a lot of custom logic in
Publishedevent and I don't know who is making the Published event - users with voting or the site admins. If the site admins are publishing then the lastUpdateDate should be updated as well. Is there a way to know who is publishing?Please help
Hi Mila,
Personally I don't think storing user votes in content is good solution.
Why ?
Each time you update the vote in the content you will publish the item again. This will empty the Umbraco cache, examine indexes need to be rebuild etc... Causing a performance hit.
It's better to store this kind of information in your own datasource, for example a database table.
Here are some blogs explaing how you can use your own tables with umbraco.
http://umbracodynamics.blogspot.nl/2016/08/umbraco-petapoco-to-store-blog-comments.html
https://www.wiliam.com.au/wiliam-blog/using-petapoco-with-umbraco-is-pretty-sweet
https://creativewebspecialist.co.uk/2013/07/16/umbraco-petapoco-to-store-blog-comments/
Dave
Hi, Dave, Thank you for pointing out the potential problems. I implemented POCO classes successfully following the articles in your comment.
Regards Mila
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.