Disable All Fields Except a Few

[ag]

I noticed that by default all fields are displayed. The problem is I have over 100 columns in a table (I know it is bad design, but it was not done by us). So is there any way to disable all fields at once, and selectively enable a couples?

Thanks!

 

[JP]

This can be accomplished using the Interfaces Configurator (internal_table_manager.php) accessed from the Admin page (admin.php).

 

[DebbieS]

You can use phpMyAdmin (if using MySQL) to execute a statement on all records in the dadabik back-end table which manages the display. Then go into the configuration and enable the ones you want.

 

[ag]

Thanks for the hints, we managed to update all 150 fields with the following SQL (with a very old version of dadabik!). For those who are curious, the following are the example SQL. Please change it for your own table e.g. dadabik_XXX: -

update dadabik_Movies
set
present_search_form_field = 0,
present_results_search_field = 0,
present_details_form_field = 0,
present_insert_form_field = 0,
present_ext_update_form_field = 0
where
name_field <> "MovieID" and
name_field <> "Title" and
name_field <> "Genre" and
name_field <> "CatalogNo" and
name_field <> "Year" and
name_field <> "UPC" and
name_field <> "Country" and
name_field <> "Custom1" and
name_field <> "Custom3";

commit;