This topic is locked

Selecting a Subset of Columns to Export

12/1/2009 5:09:57 PM
PHPRunner General questions
J
jrwatsio author

I've set up a query page that allows users to set various criteria to filter oceanographic data - 800,000 records by 40 columns. The search works great, very fast, but the results include all 40 data columns. If the user is only interested in 6 columns, is there straightforward way to make the 'columns of interest' user selectable using checkboxes or ?? If doable, would it be easier to select columns before the search or after before exporting? Cheers.

J
Jane 12/2/2009

Hi,
unfortunately there is no easy solution how to hide columns on the page. This task requires some custom coding.

Here are some tips:

  1. create new table with information what columns do you want to show
  2. check values in this table and hide whole column in the List page: After record processed and List page: Before display events on the Events tab