This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, I was wondering how I may construct queries involving aggregate operators (MIN, MAX, SUM, COUNT, etc.) using LS. Many Thanks, Kavan |
|
|
Hi Kavan, Count is available as a method on Repository. The other common aggregate functions are going to be added shortly. I will let you know when they are available. Cheers, Andrew.
|
|
|
Hi Andrew, Happy New Year! What would be great in your future implementation is if LS had a way of aliasing routine aggregations. For example if I had a customer and wanted total orders exposed as a property, I would declare a field and decorate it with an alias attribute that would contain the aggregation expression. Then when LS retrieves the object it also queries the aggregation info, keeping it all server side. This type of thing is very useful since populating grids and the such routinely require aggregations as fields (e.g Order Count, Next Appointment Date, Total Dollar Volume, etc.), and to compute this with in memory data is very intensive when the user also wants to sort and filter on larger data sets. Keep up the great work, Kavan |
|
|
Hi Kavan, Nice idea. I will have a think about this. Cheers, Andrew. |
|
|
Hi!
Best regards Björn Andersson |
|
|
Hi Björn, Preliminary support for calculations will be available in tonight's build. Cheers, Andrew. |
|