Support Decimal / Money Datatype
Please add support for Decimal / Money datatype in index schema.
Thank you for your feedback. We need some more information before we can take action on this request.
Can you share some more context re why you need a decimal (vs. the EDM.double that we support today) or money? Do your fields include signs like $?
As a workaround, with the recent release of Cognitive Search, you can create a custom skill to transform any field
Azure Search Product Team
Tarquin Vaughan-Scott commented
This would save a lot of time when setting up an import from the azure portal and the database has decimal or money fields.
I doubt that there are many use cases where the decimal type would be used in a filter or sort where the decimal portion is actually used.
Retrieving and then using decimal values would be a deal breaker as financial applications must have decimals. There could be workarounds using converters or joining back to the original data source but not great solution.
Tiago Barbosa commented
Decimal datatype provides a level of accuracy that Double does not. On a financial application where every fraction counts, double types cannot be used. Decimal is mandatory.
Will that help in supporting this feature to be added to the roadmap? Thanks!