Im not sure where to put this as it probably can be solved in many ways but here it goes;
I have en document type where I need to dynamically calculate af valueproperty each time it is shown - Im using a XSLT macro to show the list of items so as far as I know I cannot include an .NET macro inside the XSLT so this it not an option, another way was to use the SQL for XSLT (from jesper.com) but it seems not to work when using SQL CE. I have also tried building my own extension but I cannot find af why to return XPathNodeIterator when using an SqlCeConnection.
What I need to calculate are some userinput saved in my own table structure.
Hi Kim,
Is it just one value that gets calculated?
If so you could add another field to your doc type and calculate and update this field when the node gets published. Then you can just use this value directly in your template or xslt.
Hope I understood your problem correctly.
Rich
It is only one value for each item. The calculated value will constantly change so I cannot depend on the webmaster to constantly republish all items to get an updated value - the value must be realtime.
You were right to say there would be many ways to retrieve a dynamic value back, you could use Base, direct database access, web service.
Perhaps if you explains more about what the calculation is then it might become clearer.
If the value changes it seems that it's based on other figure/figures that change, perhaps like an exchange rate? Where are these figures held? In a database, how are they updated?
Sorry to answer your question, with more questions.. Rich
The values are stored in the same database as Umbraco but using my own tables - there are different values to be calculated depending on document type, what the values contain differs a lot; it can be an avarage rating (users can rate items), the number of comment. The extra data are added using .NET usercontrols.
Maybe it is possible to create an .NET macro to loop through the items instead of an XSLT?
Is there a sweet-n-easy Razor way to do sort a node collection on a custom (calculated) property?
Example: we have a text field ReportNumber which mostly looks like a year then 1- or 2-digit number, so 1997-1, 2000-23, 2012-05, etc. We'd use two fields, but sometimes that initial field has a prefix like ISRP 1997-1, or ISAB 1995-12, and we'd rather not confuse users by having them split input into multiple fields.
So on the back end (in pre-Umbraco days) I'd create a calculated field in SQL to create a sort order from the ReportNumber, then we'd OrderBy on that. But not sure how to do the same using the Model.OrderBy() structure in Umbraco.
Or we're maybe supposed to apply a custom sort on the returned collection of nodes?
Dynamically calculated property
Im not sure where to put this as it probably can be solved in many ways but here it goes;
I have en document type where I need to dynamically calculate af valueproperty each time it is shown - Im using a XSLT macro to show the list of items so as far as I know I cannot include an .NET macro inside the XSLT so this it not an option, another way was to use the SQL for XSLT (from jesper.com) but it seems not to work when using SQL CE. I have also tried building my own extension but I cannot find af why to return XPathNodeIterator when using an SqlCeConnection.
What I need to calculate are some userinput saved in my own table structure.
So how can I show my calculated value?
Hi Kim, Is it just one value that gets calculated? If so you could add another field to your doc type and calculate and update this field when the node gets published. Then you can just use this value directly in your template or xslt. Hope I understood your problem correctly. Rich
It is only one value for each item. The calculated value will constantly change so I cannot depend on the webmaster to constantly republish all items to get an updated value - the value must be realtime.
You were right to say there would be many ways to retrieve a dynamic value back, you could use Base, direct database access, web service. Perhaps if you explains more about what the calculation is then it might become clearer. If the value changes it seems that it's based on other figure/figures that change, perhaps like an exchange rate? Where are these figures held? In a database, how are they updated? Sorry to answer your question, with more questions.. Rich
The values are stored in the same database as Umbraco but using my own tables - there are different values to be calculated depending on document type, what the values contain differs a lot; it can be an avarage rating (users can rate items), the number of comment. The extra data are added using .NET usercontrols.
Maybe it is possible to create an .NET macro to loop through the items instead of an XSLT?
you can call a .net macro to iterate the items, another option is that you can call another macro inside xslt macro
As Eran states, if you are comfortable making .net usercontrols then this is certainly a good option.
You can just use the nodeFactory http://our.umbraco.org/wiki/reference/api-cheatsheet/working-with-the-nodefactory to grab your Umbraco data, then directly access your database data in the way you normally would to make the calculations.
Rich
Creating .NET usercontrols was easy! thanks!
Is there a sweet-n-easy Razor way to do sort a node collection on a custom (calculated) property?
Example: we have a text field ReportNumber which mostly looks like a year then 1- or 2-digit number, so 1997-1, 2000-23, 2012-05, etc. We'd use two fields, but sometimes that initial field has a prefix like ISRP 1997-1, or ISAB 1995-12, and we'd rather not confuse users by having them split input into multiple fields.
So on the back end (in pre-Umbraco days) I'd create a calculated field in SQL to create a sort order from the ReportNumber, then we'd OrderBy on that. But not sure how to do the same using the Model.OrderBy() structure in Umbraco.
Or we're maybe supposed to apply a custom sort on the returned collection of nodes?
Such a newbie to a lot of this.
is working on a reply...