related problem, history not showing up correctly here: https://staging.wikirate.org/Business_Human_Rights_Resource_Centre+Modern_Slavery_statement+Coach+2018+value?view=history. (though, unlike on the live site, the acts are at least opening.
sql for future reference: select * from card_changes cc join card_actions ca on card_action_id = ca.id where card_id = 3766425;
see also Blank Answer
Hi, related, I cannot update/delete blank values.. for instance: https://wikirate.org/Research_Page?rp%5Bcompany%5D=TUI+Group&rp%5Bmetric%5D=Business+%26+Human+Rights+Resource+Centre%2BModern+Slavery+statement&rp%5Bpinned%5D%5B%5D=company&rp%5Bproject%5D=Australian_National_University&rp%5Bsource%5D=Source-000057452&rp%5Byear%5D=2017&view=slot_machine
I'm not sure what to do with this ticket. So many things have been renamed that none of the links work anymore. And yet it's potentially tracking 3 or 4 different issues. Can you make new tickets for any issues you can still reproduce?
OK, I have a bit more of a beat on this now.
The issue appears to be that there are a good number (219) of answer cards with no value cards. They have answers in the lookup table, but the values are blank there. I haven't yet found any evidence of these cards in the trash. (For my own future reference, the CQL is `Card.search type: "Answer", not: { right_plus: "value" }, return: "name"`.)
Here's a sample:
Walk Free Foundation+MSA Performance Indicators+Princes Group+2017
Business & Human Rights Resource Centre+Modern Slavery statement+Bose Limited+2016
Business & Human Rights Resource Centre+Modern Slavery statement+Huntapac Produce Ltd+2017
Global Reporting Initiative+Female employees G4 10 a+Philipp Kuehl+Grupo éxito+2017
Wikirate SDG Metric design+Female Workers+LG Household and Health Care Ltd+2016
Wikirate SDG Metric design+Female workers managers differential+LG Household and Health Care Ltd+2016
Wikirate SDG Metric design+Female Workers+Sibanye Gold+2016
Clean Clothes Campaign+Address+J Thomson Colour Printers Ltd+2016
Clean Clothes Campaign+Address+Core Image Ltd+2016
Clean Clothes Campaign+Address+Corporate Media Supplies+2016
Clean Clothes Campaign+Address+CPI Colour+2016
Clean Clothes Campaign+Address+Tactical Fulfilment Solutions Ltd+2016
Poverty Footprint+Women in Management Positions+Empresa de Energia de Bogota+2017
Global Reporting Initiative+Environmental fines G4 EN29 a+Grupo éxito+2017
Business & Human Rights Resource Centre+MSA Statement Approval+Huntapac Produce Ltd+2017
Business Human Rights Resource Centre+MSA Statement Signed+Angus Soft Fruits+2016
Business Human Rights Resource Centre+MSA Statement Approval+Mitsubishi Corporation+2016
Business Human Rights Resource Centre+MSA Statement Approval+Missguided Limited+2017
Wikirate SDG Metric design+SDG13 Climate Action Actions+ArcelorMittal+2014
Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)+Wilmar International+2014
Global Reporting Initiative+ Female injury rate (G4-LA6-a)+Wilmar International+2014
Global_Reporting_Initiative+Environmental_fines_G4_EN29_a+Nedbank_Group+2014
Global Reporting Initiative+Total Waste to Landfill G4 EN23 a+Sanlam+2014
Global Reporting Initiative+Sulfur Oxide SOx emissions G4 EN21 a+Akbank+2014
US Securities & Exchange Comission+Unrecognized Tax Benefits Reductions Resulting from Lapse of Applicable statute of Limitations+Babcock & Wilcox Enterprises Inc+2014
The question is: do we have a way of knowing what value they're supposed to have? Do we have a way of finding and fixing them?
No I don't think we have a back up with that info. But we definitely can find out if the source is still there, other wise they have to be competely re-researched.
fixed.