General order

helmarkz

New member
Hi, maybe it's a simple question but I dont find the answer.

How can I select the order of main table of results?

Thanks
 

helmarkz

New member
Woops!, ok, thanks.

I think it would be usefull, and clients sometimes need to have clear results,... by the way, how is it ordered now?

Thanks again
 

eugenio

Administrator
Staff member
At the moment no order, maybe (I haven't tried it) you can change the order just by adding an order by to the sql created by build_installed_table_infos_ar
 

peartaa

New member
I found a way to customize the order in which the tables are displayed without changing php code:

1. Add a field `id` to table `dadabik_table_list`. Assign the id numbers to each table in the order you want them displayed. For example, if you want table `table_1` to be displayed first, assign '1' as the id.
2. Rename table `dadabik_table_list` to something else (I used `dadabik_table_list_table`)
3. Create a VIEW called `dadabik_table_list` with the following query: [pre]CREATE VIEW `databik_table_list` AS
SELECT `dadabik_table_list_table`.* FROM `dadabik_table_list_table`
ORDER BY `dadabik_table_list_table`.`id`;[/pre]
 
Top