Download & Extend

Range content in the Analysis page could link to a list of unique values present in the field being analyzed

Project:Table Wizard
Version:6.x-1.2
Component:Code
Category:feature request
Priority:minor
Assigned:Unassigned
Status:active

Issue Summary

The analysis page provide much useful information. Here is a suggestion of one extra information it could provide:

The "Range" content in the Analysis page could link to a list of unique values present in the field being analyzed. This list could have an extra field: the count for each unique value.

I'm not sure on current status of Table Wizard development as it seems to depend on Migrate 6.x-2.0 status.

I can try to provide a patch if there is interest from the maintainers. Please advise.

Comments

#1

Priority:normal» minor

The Table Wizard is being deprecated in favor of the Data module, so there's really no interest on our part.

If you do go ahead with generating a patch, it really must be opt-in per field - maintaining such a list for every field by default would be horrendous for, say, a 1 million row table where the PK is unique per row and most other columns have hundreds of thousands of unique values.

#2

If there is no interest, let's leave it as it is.

Just to clarify, this option wouldn't have any impact on the database whatsoever as it would not save any data. It would only make a DISTINCT query on the field being analyzed to show/export a list of values present in each field.