[TYPO3-mvc] How to get calculated data from a query into an object?

[Nikolas Hagelstein]

Hi,

> 1) Should be fairly straightforward. From the repository you can
> execute any SQL query you want.
In order to annul the data mapper (for later manual processing) 
it would be necessary to either fire a low level query directly or
manipulate 
querySettings->returnRawQueryResult and use $query-statement...

For the distance/store case I would say:
If you don't need the distance as a query criteria you could even use a
simple findBy 
with having returnRawQueryResult set.

Franz: do you need the distance as query criteria?

> 2) Needs digging into ExtBase. I think you can get hold of the mapper
> object(s). If you've got it,
> you must only call the mapSingleRow() method. I can look it up in the
> evening.

Yes, after some short diggin I would say: seems to be a viable way :).

Pretty interesting...

Regards,
Nikolas