Rat when trying to filter for metric name+Discussion


More of the data cleanup issue.

Ethan McCutchen.....2020-08-15 00:49:38 UTC

I don't understand that. Like there's some relationship data in the Tin metric (https://wikirate.org/Commons+uses_Tin_smelted_by) that is causing the rat? And is one supposed to fix it if there's no way to see the problem?

I went to https://wikirate.org/Commons+uses_Tin_smelted_by and found that some of the paging seemed to work, but for ex, I sorted alphabetically and then tried to get to page 2 and it is not working (though page 3 is). Could that be a connected issue?

https://wikirate.org/Commons+uses_Tin_smelted_by?filter%5Bnot_ids%5D=&sort=bookmarkers&filter%5Byear%5D=latest&filter%5Bstatus%5D=exists&filter%5Bcompany_name%5D=

theresah.....2020-08-17 11:40:05 UTC

To clarify, I'm the one who has to clean up the data. The old renaming bugs left us with a bunch of messes to clean up in the lookup tables.

 

Not only do I think the new renaming handling will fix a lot of bugs, but I'm also adding low level data constraints that will help prevent the data from ever getting so screwy.

Ethan McCutchen.....2020-08-17 15:31:53 UTC

This looks good on staging. OK to close?

Ethan McCutchen.....2020-08-18 14:27:13 UTC

Yes, looks good!

theresah.....2020-08-18 14:38:26 UTC