DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

General order
April 27, 2011 01:31PM
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
Re: General order
April 27, 2011 01:39PM
Hi, it is not possible at the moment.

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: General order
April 27, 2011 01:49PM
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
Re: General order
April 27, 2011 02:51PM
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
Re: General order
January 26, 2012 09:03PM
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.
Re: General order
March 09, 2012 11:52AM
That's very smart. Bravo! And thanks for sharing.

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Sorry, only registered users may post in this forum.

Click here to login