1

I have a table in my database with 200 columns in it, and the table can have maximum of 10 records in that.

Here search based on data is a least priority but search on the column name is the most used feature.

Sort feature is also required on the column names but not on data.

  • Could you have the records as columns for the exhibition? in this case you would have a table with 10 columns and 200 rows. I think it would be easier to read and filter. – Aline Jan 4 at 12:03
  • We need more information to understand how & why users need access to the information, the question is to light on information as it stands. – DarrylGodden Jan 4 at 12:04
  • @Aline, going with your suggestion user need to go on pagination or lazy loading to get the rest of the data loaded, to read a single record data. – Dimple Jan 4 at 12:23
0

There is a special kind of databases called Column oriented DB. Maybe they have some useful UI patterns.

What we had in our case was a usual HTML table with most popular columns being visible. First column was locked and contained some unique key for rows, other columns were horizontally scrollable. First column of the header row contained hamburger icon, which in our case meant Column Control Menu. On pressing it, the huge popup menu appeared with alphabetical list of all possible columns. You could check/uncheck the columns you need. There was also a quick search for columns there.

For column oriented table you usually don't need to see all the columns at once, because data there is either sparse or not very unique.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.