search

arsturges / RVB

A DOE tool to map appliance efficiency legislation to CO2 reductions.
ead5.lbl.gov
1 stars 0 forks source link

/rulemakings/50 #39

Closed arsturges closed 6 years ago

arsturges commented 14 years ago

This is not showing proper data, at least for rulemaking 50, phase 4, task 1. Straight SQL query:

select * from milestones where rulemaking_id = 50 and phase_id = 4 and task_id = 1 and date_category_id = 3;

This query gives different results than what's showing in the final rule/BT program/actual start field. Major major issue.

arsturges commented 14 years ago

From development log: First query: SELECT * FROM milestones WHERE (milestones.rulemaking_id = 50 AND (milestones.revision_number = 14))

Then, from http://localhost:3000/rulemakings/50?revision_number=13&commit=Go:

SELECT * FROM milestones WHERE (milestones.rulemaking_id = 50 AND (milestones.revision_number = 14))

revision_number isn't changing.

arsturges commented 14 years ago

One problem fixed: BT Program review in the show view was incorrectly finding task 8 instead of 1.

Revision number still not yielding correctly.