General order

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

Hi, it is not possible at the moment.

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin

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

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

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin

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:

CREATE VIEW `databik_table_list` AS 
SELECT `dadabik_table_list_table`.* FROM `dadabik_table_list_table` 
ORDER BY `dadabik_table_list_table`.`id`;

Edited 1 time(s). Last edit at 01/26/2012 09:04PM by peartaa.

That's very smart. Bravo! And thanks for sharing.

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin