Dynamic reordering ?

Yes this is exactly what I need. The best would be to be able to use a joomla query object but I don't know if you use it in the component's models.

There is also a good help with what I want to do with this document .

I don't know how to cleanly achieve this. Maybe by using plugins events in the fields files ?

using joomla query object , makes little difference in our case,
unless you would extend and then override the category model,

and it would make little difference, because:
-- overriding the model CLASS would mean that you can override the methods too, aka the query building method

- and if we add parameters for these clauses, it would not make difference how the clauses are added to the query
- even then if we add methods to the model to add joins, order, etc clauses
the model is created inside view.html.php file which is not overridable

Hello

about Joomla query object, it is used in 10% of FLEXIcontent queries, the rest set an SQL string

about adding parameters to allow
-1- extra select columns
-2- extra join clauses
-3- custom order clause
-4- additional AND-WHERE

i think we can add them, it would be the responsibilty of the developer not to break the query,

but for performance reason we use 2 queries,
- get the item ids (which will use 2,3,4 of the above clauses)
- then get item data (which will use 1,2 of the above clauses)

even if a query gets broken Joomla debug will print it and you can correct, so no need to give more info for the query

What about this:

docs.joomla.org/How_to_override_the_comp...rom_the_Joomla!_core

it seems that you can override the category model
(create a class to extend the FLEXIcontent category model)
and then you will "only" modify the query building

what we can override controller !! very good news !!!
its compatible with flexicontent controller ?