Is it possible (and if so how?) to create dynamically calculated values as part of a SharePoint programmatic Search Query?
My predicament is I need to filter search results to only items that are within a proximity distance of a user-supplied postcode value (e.g. Schools within 5 miles of my house). I know it is possible to use Sort Formulas (http://msdn.microsoft.com/en-us/library/office/jj938031.aspx#code-snippet-6) to sort items based on these formulae but I also need to filter by them (i.e. all results within 5 miles) and also retrieve the distance as a value for each item in the result set.
If I was to compare this requirement to a SQL database query you can add dynamic columns to your result set, you can sort by them and you can filter by them. From what I've found in SharePoint 2013 search you are only able to sort on these dynamic values, not return them or filter by them. Does anyone know different?
My end goal is to create a custom refiner based on the Distance values (which has a separate question here: Using SharePoint 2013 Geolocation Field as a Search "Distance" Refiner).