#634 Hide/Show operaor and value fields in table search page

[Ammar Yasir]

Due to a lot of columns availaible in a table, all of the operator and value fields are shown to users. So at start they are hidden and can be toggled hide/unhide on clicking the corresponding column line.

[Ammar Yasir]

Basic Idea, just hides/unhides the fields

[Marc Delisle]

What's the advantage of hiding this information?

[Ammar Yasir]

I thought that by showing all the data type, collation, operation select box and field box, user sees a lot of unwanted options, so hide them and display the datatype, collation etc. when a user clicks on the field.

[Marc Delisle]

Let's see what other think of this. I can see an advantage of seeing all this information by default: you have an immediate idea of all the columns and their size.

[Garvin Hicking]

To me a quick overview without the need to toggle something on off is much more important; even though I do see a need for a "non-professional users" view. Maybe the toggle state could be saved in a cookie so when once enabled it stays that way for the user's machine?

IMHO screen space should be used to display information, and at that place there's currently enough place to do so.

[Tyron Madlener]

If the patches intention is to reduce the information overflow on the search page, it is the wrong way to do it imho.

I'd rather permanently remove the collation column (this information is probably not being used in 99.5% of the searches)

[Piotr Przybylski]

I don't like the idea of complicating search by requiring user to click on all rows that he wants to filter by. If we want to fit more data on screen, I'd rather decrease CSS margins/paddings there.

[Marc Delisle]

Thanks for the feedback. I thing we'll say "no thanks" to this patch.

I agree to remove (for 3.5.0) the collation column in table Search (I don't see how knowing about the collation can influence the value I enter as a search term).

[Ammar Yasir]

I too agree that collation column could potentially be removed/toggled. My intention was that some columns which are not that significant on the table search (or any other) pages could be toggled on/of. It would be more effective than removing the column entirely.