INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: drosoph on October 15, 2002, 07:51:52 pm

Title: Numeric View Schemes - still messed in 90067
Post by: drosoph on October 15, 2002, 07:51:52 pm

Ive been pointing out errors in Numeric View schemes for a while now (first it was Decade, the BPM) ... now it is TRACK ...

Granted, noone would really create a TRACK view scheme (or I cant think of a reason) .. but looking at it ... it really shows me how the coding was done ...

There is a group for UNASSIGNED, "0", & "00" ... all with the same values .. Also, there is a "01" and a "1" grouping (same files).

The ordering is 1 ,10,100,11,12,13, 2 ,21,22,223,23 ...  Anyone see a problem :)

The last time I saw these kinds of problems we were working with a database at work that had numerical values and the key was listed as 'string' and should have been interger(32).  As a string it was doing a 'best-fit' analysis of the values ... causing the numbering to be 1,10,100,11,12,etc ...

From what Ive seen, there have been regressions caused by certain changes in the DB ... and then, after a few changes, the view scheme for the particular problem I'm addressing get fixed.  I don't think that the problem is being addressed as a whole, but rather in the view scheme (altering each code separately to handle the new view scheme I bring to the table) ... I think a DB change would be more important at this point.   Making each field defineable as string vs text to make the coding simpler (and the ordering will work at that point).

If we are going to be allowing users to create "CUSTOM FIELDS" in the future and make View Schemes based on these custom fields, you will have the same problems that have been cropping up that I have mentioned previously for BPM scheme, Decade scheme, & Track scheme.

Title: Re: Numeric View Schemes - still messed in 90067
Post by: drosoph on October 15, 2002, 07:59:42 pm

Noted Numeric Problems:

Decade Scheme Regression: Overlap in Groupings --FIXED

BPM Scheme:  Bad Sort Order, Files not listed (unless = min value in grouping) -- FIXED

Track Scheme:  Bad Sort Order, Duplicate Groupings

Duration Scheme:  Files not listed

Bitrate Scheme:  Bad Sort Order (workaround, create groupings and it will sort correctly)

Title: Re: Numeric View Schemes - still messed in 90067
Post by: Matt on October 16, 2002, 07:02:54 pm

Just give us some time... we'll get it right one of these builds  ;)

Oh, and the DB isn't the problem -- it's really smart.  The problems are inside the new grouping logic and/or tree sorting code.

Thanks for all your help.