Dynamic reordering ?

Hello,

I am wondering if Flexicontent can order according to some submitted sql.
For instance, I have a field that contains GPS location for an item and I would like to be able to order the items according to the user location so that they can have the closest item they want.
I know the sql code to compute the metric distance between 2 GPS points but I don't know where to put it.

Can someone help me ?

you need a pro dev for a plugin for this ....

Hello

is it a text field ?

there is not an option for custom SQL code for ordering,
to do that would probably need:
- parameter for ORDER BY clause
- parameter of custom JOIN clauses
- parameter for an "AND" clause to append to the WHERE clause

possible but not implemented

I am actually a developper.

The field is custom made by me, it allows the user to place a marker directly on a google map.

I already more or less done it for a client through a custom module. (You can see it at www.ot-dreux.fr/ by using a mobile)

But it is "emulated" because there is a custom query that find and sort items' ids according to position and distance. Those id are used to load the data and render it with templating.

I would like to have it working for components view without "hacking" something. Too bad it is not possible yet.

I'm upping this topic because I'm going to need this very soon.

I'm going to hack the core but I would like to have a cleaner way to do dynamic reordering.

Thanks in advance

Hello

so you want to add
- custom join
- custom AND clause for WHERE
- custom ORDER clause

to category view and to universal content module