[SERVER-11157] Type casting operator for aggregation (and query) Created: 12/Oct/13  Updated: 10/Dec/14  Resolved: 15/Oct/13

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: New Feature Priority: Minor - P4
Reporter: rgpublic Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-6206 need a policy for incompatible types ... Closed
duplicates SERVER-6203 Aggregation operators should have wel... Backlog
Participants:

 Description   

The aggregation framework is great and has very powerful operators. You can apply string operations, calculate with numbers and dates etc. Unfortunately you must have the right type to begin with to make use of all these That's not always the case! For instance it is sufficient that you have a field containing "7x8" and there's nothing you can do to calculate (i.e. area in sqm) or compare anything (numerically). Especially, I'm missing an operator to at least convert a string to an integer: {$cast=>"number"} or something like that. I hope, this isn't too complicated to implement - that's why I'm proposing it here. Being able to use it for normal queries (i.e. without aggregaton) would be very cool as well.



 Comments   
Comment by Daniel Pasette (Inactive) [ 15/Oct/13 ]

I think your issue is duplicated by SERVER-6203 and SERVER-6206.

Generated at Thu Feb 08 03:25:03 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.